Wednesday, May 9, 2012

BCV Hot backup with RMAN incremental backup

Yes it is possible to restore database using combination of BCV hot backup and RMAN incremental backup. I tried below in my test environment and it worked.

summary :-
=====================================================================================================================================
take SCN number before
alter database begin backup;

Take hot backup
next day take rman incremental backup from above SCN
after backup copy control file

restore hot backup
restore control file
startup database
in RMAN :-
recover database noredo;

when asked for recovery for system1.dbf

alter database recover database;

if you get below error :-
SQL> alter database recover database;
alter database recover database
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-00314: log 2 of thread 1, expected sequence# 38 doesn't match 5
ORA-00312: online log 2 thread 1: 'D:\ORCL\ORADATA\ORCL\REDO02.LOG'
try :-
ALTER DATABASE CLEAR LOGFILE GROUP 2;
if it fails
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;

No comments:

Post a Comment