General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle and EVA Snapclone question

Bruce Coxe
Occasional Visitor

Oracle and EVA Snapclone question

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.
2 REPLIES
TwoProc
Honored Contributor

Re: Oracle and EVA Snapclone question

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;

We are the people our parents warned us about --Jimmy Buffett
Indira Aramandla
Honored Contributor

Re: Oracle and EVA Snapclone question

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
Never give up, Keep Trying