Autonomous Database RMAN Recovery Catalog
You can use Oracle Autonomous Database as a Recovery Manager (RMAN) recovery catalog. A recovery catalog is a database schema that RMAN uses to store metadata about one or more Oracle databases.
- Use Autonomous Database as an RMAN Recovery Catalog
Recovery Manager (RMAN) recovery catalog is preinstalled in Autonomous Database in schema
RMAN$CATALOG. The preinstalled catalog version is based on the latest version of Oracle Database and is compatible with all supported Oracle database versions.
Use Autonomous Database as an RMAN Recovery Catalog
Recovery Manager (RMAN) recovery catalog is preinstalled
in Autonomous Database in schema
RMAN$CATALOG. The preinstalled catalog version is based on
the latest version of Oracle Database and is compatible with all supported Oracle
The recovery catalog contains metadata about RMAN operations for each registered target database. When RMAN is connected to a recovery catalog, RMAN obtains its metadata exclusively from the catalog.
Note:Autonomous Database is not supported as an RMAN target database. An RMAN target database is an Oracle Database to which RMAN is connected with the
TARGETkeyword. A target database is a database on which RMAN is performing backup and recovery operations. See Backing Up and Restoring Autonomous Transaction Processing Cloud for information on Autonomous Database backup and recovery operations.
Access to RMAN Recovery Catalog
Access to the recovery catalog is provided through
RMAN$VPC with the appropriate
access to the recovery catalog only. The
user is locked by default.
You can either proxy to the predefined user
RMAN$VPC through the ADMIN user or
explicitly unlock the preinstalled schema:
ADMIN user proxy into
RMAN$VPCusing ADMIN user's password:
ADMIN user can set a password for
RMAN$VPC. Then the
RMAN$VPCuser can directly connect:
connect admin/password@connect_string alter user rman$vpc identified by password account unlock; connect rman$vpc/password@connect_string
Use the RMAN Recovery Catalog
You can use the RMAN recovery catalog by connecting RMAN to the preinstalled recovery catalog. Registering a target database in the recovery catalog maintains the database’s records in the recovery catalog. For example, to register a target database:
RMAN> connect catalog rman$vpc/password@connect_string; connected to recovery catalog database recovery catalog schema version 21.01.00.00. is newer than RMAN version RMAN> register database; database registered in recovery catalog starting full resync of recovery catalog
To use your Autonomous Database as a recovery catalog, it is recommended to
connect with the
See Registering a Database in the Recovery Catalog for more details about using the RMAN recovery catalog.