Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

How to configure simple standard RMAN backups for Oracle DB with catalog database

Create Catalog Schema

At the database you intend to use as catalog database:

Create Tablespace

...

for

...

catalog schema

Panelcode
languagesql
SQL> create tablespace CAT_TBS;

 
Tablespace created.

Create Catalog Schema

Panelcode
languagesql
SQL> create user RMANCAT identified by XXX default tablespace CAT_TBS temporary tablespace TEMP quota unlimited on CAT_TBS;
Panel

SQL> grant create session to RMANCAT;

Grant succeeded.
SQL> grant

 
SQL> grant create session to RMANCAT;
Grant succeeded.
SQL> grant recovery_catalog_owner to RMANCAT;


Grant succeeded.


SQL> grant execute on dbms_stats to RMANCAT;


Grant succeeded.

Configure RMAN

At the database you want to backup, confugure RMAN with access to catalog

...