RESYNC CATALOG command to perform a full resynchronization of metadata in a recovery catalog schema with metadata in a target database control file. You can also use the
FROM CONTROLFILECOPY clause to resynchronize the current control file with the RMAN metadata in a control file copy.
Typically, you run
RESYNC CATALOG in the following situations:
The recovery catalog was unavailable when you executed RMAN commands that automatically perform a resynchronization.
The target database is running in
ARCHIVELOG mode, because the recovery catalog is not updated automatically when an online redo log switch occurs or when a redo log is archived.
You made changes to the physical structure of the target database such as adding or dropping a tablespace. As with log archiving, the recovery catalog is not updated automatically when the physical schema changes.
RMAN is connected as
TARGET to a standby database. You want to update the recovery catalog with metadata about RMAN operations performed on this database.
RMAN is connected as
TARGET to a standby database. You want to update the recovery catalog with metadata about a physical change on the primary database (see Example 2-123).
RMAN must be connected as
TARGET to a mounted or open database and connected as
CATALOG to a recovery catalog database.
Resynchronizations are full or partial. If full, and if the target database has mounted the current control file (but not a newly created control file or a control file that is less current than a control file that was used previously), then RMAN updates all changed records for the physical schema: datafiles, tablespaces, redo threads, and online redo logs. If the database is open, then RMAN also obtains data about rollback segments. If the resynchronization is partial, then RMAN does not resynchronize metadata about the physical schema or rollback segments.
If the target control file is mounted and the catalog database is available at command execution, then RMAN automatically resynchronizes the recovery catalog as needed when you use RMAN commands. RMAN performs a full resynchronization after structural changes to database (adding or dropping database files, creating new incarnation, and so on) or after changes to the RMAN persistent configuration.
Starting with Oracle Database 11g, a single recovery catalog schema can keep track of database filenames for all databases in a Data Guard environment. This catalog schema also keeps track of where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created for all databases. If RMAN is connected as
TARGET to a standby database, then RMAN implicitly executes a full resynchronization if the standby control file contains information about a physical schema change on the primary database.
||Updates the recovery catalog with RMAN metadata in the current control file of the target database (default).
RMAN creates a snapshot control file in order to obtain a read-consistent view of the control file, then updates the recovery catalog with any new information from the snapshot. The
||Updates the current control file and recovery catalog with RMAN metadata from a control file copy (see Example 2-122). Use filename to specify the name of the control file copy to use for resynchronization.
The primary use for
Note: The control file copy can either be in the current database incarnation, or created in a prior incarnation (that is, prior to the most recent
||Resynchronizes the recovery catalog with control file metadata in the specified database or databases (see Example 2-124).
You can specify a single database with
Note: You must have previously used
When you run
For a sample use case, suppose that you recently connected RMAN as
This example performs a full resynchronization of the target database after archiving all unarchived redo logs.
RMAN> CONNECT TARGET / RMAN> CONNECT CATALOG rman@catdb recovery catalog database Password: password connected to recovery catalog database RMAN> SQL "ALTER SYSTEM ARCHIVE LOG CURRENT"; RMAN> RESYNC CATALOG;
Assume that you start the RMAN client and connect to a target database and recovery catalog. The following commands shut down and mount the target database, update the RMAN repository in the current control file with metadata from a backup control file, and then open the database.
STARTUP FORCE MOUNT RESYNC CATALOG FROM CONTROLFILECOPY '/disk1/cfile.dbf'; ALTER DATABASE OPEN;
Suppose that you have a Data Guard environment containing primary database
prod and standby database
standby3. You start SQL*Plus, connect to database
prod, and add a datafile to tablespace
users as follows:
SQL> ALTER TABLESPACE users ADD DATAFILE ''?/oradata/prod/users03.dbf'' 2 SIZE 1M AUTOEXTEND ON 3 NEXT 10K MAXSIZE 10M";
Your goal is update the recovery catalog with metadata about this change. After the change has propagated to
standby3, you start the RMAN client, connect to
TARGET, and connect to the recovery catalog. You then use the
RESYNC command to resynchronize the catalog with the control file of the standby database:
RMAN> RESYNC CATALOG;
The recovery catalog is updated with metadata about the datafile added to the
users tablespace of database
Suppose that primary database
prod and standby database
dgprod3 exist in a Data Guard environment. Your goal is to create an RMAN configuration for
You connect RMAN to database
TARGET and then connect to the recovery catalog. You use
CONFIGURE to update the persistent RMAN configuration for
dgprod3 in the recovery catalog as follows:
CONFIGURE DEFAULT DEVICE TYPE TO sbt FOR DB_UNIQUE_NAME dgprod3; CONFIGURE DB_UNIQUE_NAME dgprod3 CONNECT IDENTIFIER 'inst3';
You have not yet performed any backups or other RMAN operations on
dgprod3, so the control file of
dgprod3 and the recovery catalog metadata for
dgprod3 are not synchronized. In the same RMAN session, you synchronize the
dgprod3 control file with the recovery catalog as follows:
RESYNC CATALOG FROM DB_UNIQUE_NAME dgprod3;
RMAN updates the default device type to SBT at
dgprod3 and also updates the recovery catalog with the names from the
dgprod3 control file.