Re: Help needed making a DB copy

From: srivenu <srivenu_at_hotmail.com>
Date: 16 Mar 2004 23:38:05 -0800
Message-ID: <1a68177.0403162338.57602507@posting.google.com>

How did you shutdown the database ?
Did you also copy the redo log files ?
If you did, then do the following at this step

> recover database until cancel using backup controlfile;
> ORA-00279: change 109582288 generated at 03/16/2004 11:01:21
>needed for thread 1
> ORA-00289: suggestion : /oracle/SND/saparch/SNDarch1_2.dbf
> ORA-00280: change 109582288 for thread 1 is in sequence #2
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Itstead of Cancelling here, give the name of the Redo logs that you copied. Give the first Redo log first, if it fails give the second one... One of them will succeed.
regards
Srivenu Received on Wed Mar 17 2004 - 01:38:05 CST