Printable View
DEAR FRIENDS,
I HAVE TAKEN A RMAN BACKUP OF MY DATABASE WHILE IT WAS OPEN BY WRITING THE CODE
run
{
allocate channel c1 type disk;
backup database format 'db_%u_%d_%s';
release channel c1;
}
BUT WHILE I AM TRYING TO RESTORE AND RECOVER THE DATABASE WHILE IT IS OPEN USING RMAN IT IS GETTING FAILED.THE DATABASE IS IN ARCHIVE LOG MODE.
PLEASE HELP.WHAT SHOULD I DO?
post your full restore script and errors
THE SCRIPT OF RECOVERY IS
run
{
allocate channel c1;
restore database;
recover database;
}
and the error?
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/17/2007 18:23:48
ORA-19573: cannot obtain exclusive enqueue for datafile 1
What state is the database in?
The generic steps for media recovery using RMAN are as follows:
Place the database in the appropriate state: mounted or open. For example, mount the database when performing whole database recovery, or open the database when performing online tablespace recovery.
http://download.oracle.com/docs/cd/B...2.htm#BGBCIGHG
The Database Was In Open State And In Archive Log Mode
Shouldn't the database be in mount state for rman database recovery?
it sure should
In gneral, it can be open as long as you don't need to recover the system tablespace. You need to offline the affected tablespace before you can restore / recover it though. That error indicates that the tablespace being restored is still online.
However, for a general restore / recover, it can't be open.