tailieunhanh - Oracle Database Administration for Microsoft SQL Server DBAs part 16

Oracle Database Administration for Microsoft SQL Server DBAs part 16 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 132 Oracle Database Administration for Microsoft SQL Server DBAs If another database is to have the catalog the connect catalog string will have the database as part of the string rman rmanpswdRMANCAT RMAN connect catalog rman rmanpswd connected to recovery catalog database RMAN create catalog recovery catalog created RMAN register database database registered in recovery catalog starting full resync of recovery catalog full resync complete RMAN After the catalog is created the databases can be registered with the catalog. The target database that is connected is the one that is registered with the catalog. Now the target database is ready for backups. You can configure RMAN for the default backup type where the backup files should be written the format of the backup file retention policies compression encryption and control file autobackup. The tape drivers and encryption options are part of the Oracle Secure Backup product. Other vendors provide drivers to write directly to tape and encryption and Secure Backup will also integrate directly with RMAN. Looking at the configuration for RMAN is just like looking at the parameters in the Oracle database but from the RMAN command line. RMAN show default device type RMAN configuration parameters for database with db_unique_name MMDEV1 are CONFIGURE DEFAULT DEVICE TYPE TO DISK default Change the default device from disk to tape RMAN configure default device type to sbt new RMAN configuration parameters CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE new RMAN configuration parameters are successfully stored These configuration settings can be part of a script. If they are set in a script the script settings will overwrite any defaults that are set up for that database in RMAN. Chapter 6 Database Backup Restore and Recovery 133 Here are some examples of setting the defaults for the backup directory file format type of backup and retention policy f --example to configure channel to write to disk using the diskgroup format RMAN .