-
Confusion Over Recovery
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
-
confusion over recovery
THE SCRIPT OF RECOVERY IS
run
{
allocate channel c1;
restore database;
recover database;
}
-
-
confusion over recovery
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|