Catalog Database in RMAN

Purpose of Catalog Database

A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog.

Catalog Database can be two types

  • Base recovery catalog
  • Virtual private catalog.

For more details

Create the tablespace for catalog user

SQL> create tablespace rman_cat datafile  (more...)

Basic of RMAN Backup and Recovery Scenario

Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database.
Check the archive log status

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 17

Next log sequence to archive 19

Current log sequence 19

Create a dummy table for testing

SQL> create  (more...)

RMAN Time Based Recovery

RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps.
First, take the full backup.

RMAN> run


allocate channel c1 device type disk;

allocate channel c2 device type disk;

backup database and archivelog all delete input;


Create a table

SQL> create tableb01(name varchar(100));

Table created.

SQL> insert intob01 values(‘Test’);

1 row created.

SQL> select to_char(sysdate,’YYYY-MM-DD hh24:mi:ss’) from dual;