• Arun Kumar

RMAN DB Full Backup & Recovery

In this article we will be looking at RMAN incremental backup & how to perform database recovery using incremental backup.

Take RMAN DB FULL Backup

Connect to the target DB and catalog. Take DB full backup

RMAN> backup database plus archivelog;

Once backup is completed, check backup tag via below command

RMAN> list backup of database summary;

Create User and Table

SQL> create user mgr2 identified by mgr2;
SQL> grant connect, resource, create session to mgr2;
SQL> conn mgr2/mgr2
SQL> create table test(serial number(2),name varchar2(5));
SQL> insert into test values(1,'one');
SQL> insert into test values(2,'Two');
SQL> insert into test values(3,'Three');
SQL> insert into test values(4,'Four');
SQL> commit;

Simulate Failure

Get the location of spfile, datafile & control file

SQL> show parameter spfile;
SQL> select name from v$controlfile;
SQL> select name from v$datafile;

Delete all the spfile, datafiles & Control files from server

rm -rf <DF locations>
rm -rf <control file locations> 
rm -rf <spfile location>

Start Database Recovery

Kill the DB instance, if running. You can do shut abort or kill pmon at OS level

Connect to RMAN and issue below command

RMAN> Restore spfile from autobackup;

RMAN> Restore controlfile from autobackup;
RMAN> sql 'alter database mount';

RMAN> Restore database from tag TAG20160618T204340;
RMAN> Recover database;
RMAN> sql 'alter database open RESETLOGS';

In case AUTOBACKUP is OFF, then Restore SPFILE & Control File using below

RMAN> list backup of spfile summary;
RMAN> list backup tag <give-latest-tag>;
RMAN> Restore spfile from tag '<give-latest-tag>';

RMAN> list backup of controlfile summary;
RMAN> list backup tag <give-latest-tag>;
RMAN> Restore controlfile from tag '<give-latest-tag>';

DB Recovery With Manual Channels

You can allocate manual channels and define one RMAN run block to perform complete database recovery

  • Fast recovery

  • Un-monitored recovery

RMAN> startup force nomount;
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
restore spfile from tag TAG20160618T205807;
startup force nomount;
restore controlfile from autobackup;
sql 'alter database mount';
restore database from tag TAG20160618T205739;
recover database;
sql 'alter database open RESETLOGS';
release channel ch1;
release channel ch2;


Recent Posts

See All

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au