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;
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