Confusion Over Recovery

[indrajit2002]

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?

[davey23uk]

post your full restore script and errors

[indrajit2002]

THE SCRIPT OF RECOVERY IS

run
{
allocate channel c1;
restore database;
recover database;
}

[davey23uk]

and the error?

[indrajit2002]

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

[dbtoo]

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

[indrajit2002]

The Database Was In Open State And In Archive Log Mode

[PAVB]

Shouldn't the database be in mount state for rman database recovery?

[davey23uk]

it sure should

[jhmartin]

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.