Re: Help needed making a DB copy

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Wed, 17 Mar 2004 08:30:24 -0600
Message-ID: <n5og50h8497qa07f1072fjfuquhgl6l1b2@4ax.com>

On 16 Mar 2004 23:38:05 -0800, srivenu_at_hotmail.com (srivenu) wrote:

>How did you shutdown the database ?

Stopsap - which does a shutdown command.

>Did you also copy the redo log files ?

Yes

>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.

The log it is looking for rdoes not exist. We copied from DEV to SND. I have NO idea why it is looking for a log file that doesn't exist.

>Give the first Redo log first, if it fails give the second one...
>One of them will succeed.

Why would I need to give log files if the database was shut down cleanly?

>regards
>Srivenu

Thanks!
Vince

---

Come race with us!
www.mgpmrc.org Received on Wed Mar 17 2004 - 08:30:24 CST