Oracle and EVA Snapclone question

[Bruce Coxe]

One of the major problems we are facing with the 'post snap' process (in order to start up and open our target database) is that we are not able to automate the recovery of the database in a manner that can be embedded into our script.

Every time we have recovered using the script, the session ends up recovering upto the last one of the files in the archive redo log destination, but bombs out because it still needs the next file (which incidentally is the CURRENT redo log sequence in the active redo log
files)
before it can come back with a 'media recovery complete' code (that would allow the database to open successfully).


Any assistance would be highly appreciated. Thank You.

[TwoProc]

add "until cancel" in your recovery command.

Recover database using backup controlfile until cancel;

...

...

And when you believe you are done, for next file name ...

CANCEL

alter database open resetlogs;

[Indira Aramandla]

Hi Bruce,

You can add

Recover database using backup controlfile until cancel;

and then

alter database open resetlogs;

or

Recover database using backup controlfile until time 'CCYY-MM-DD:HH:MI:SS';

where you ccyymmddhhmiss time will be the time the last log was archived.
and then

alter database open resetlogs;

IA