Showing posts with label BCV Hot backup with RMAN incremental backup. Show all posts
Showing posts with label BCV Hot backup with RMAN incremental backup. Show all posts

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;