What is configure command and recovery catalog?

What is recovery catalog and configure command?

Recovery catalog:

- A recovery catalog is a schema stored in a database. It tracks backups and stores scripts for use in RMAN backup and recovery situations.

- A set of Oracle tables and views used by RMAN to store RMAN repository information about one or more Oracle databases.

- RMAN uses this metadata to manage the backup, restore, and recovery of Oracle databases.

- Use of it is optional unless you use RMAN in a Data Guard environment, in which case it is required.

- The primary storage for RMAN repository information for a database is always in the control file of the database.

- It is periodically updated with RMAN repository data from the control file.

- In the event of the loss of your control file, it provides most or all of the lost metadata required for restore and recovery of your database.

- The recovery catalog can also store records of archival backups and RMAN stored scripts for use with target databases.

Configure command:

- Configure command used in RMAN,is used to configure the parameters for the RMAN database.

- It is used while making backups and recoveries.

- The CONFIGURE command is used to create or change a persistent configuration affecting RMAN backup, restore, duplication, and maintenance jobs on a particular database.

- A configuration is in effect for any RMAN session on this database until the configuration is explicitly cleared or changed.

- The SHOW command can be used to display the configurations for one or more databases.
What are different types of backup? (Hot, Cold, logical, Physical)?
Cold Backup, Physical Backup, Logical Backup, Hot backup...
Concept of Flashback Query in Oracle (10g in particular)
Due to human errors, valuable data gets deleted or misentered. Oracle Flashback Technology provides a set of new features to view and undo the data back and forth.....
What is mean live lock and deadlock? How to prevent it?
A deadlock can occur when two or more processes that strive to acquire resources are not able to acquire them due to some of the following reasons:.....
Post your comment