RE: Hot backup files, FTP to different box, recovery session canc

LInda,

not quite...you still need to start the recovery, even if you cancel it

so....

startup mount
recover database until cancel;
(then cancel it)

alter database open resetlogs;

best is to ALWAYS create a backup controlfile and use that:

on the original system:

alter database backup controlfile to <somefilename>;

then copy somefilename to the control file locations on the new system.

Do:

startup mount
recover database until cancel using backup controlfile; (then cancel it)

alter database open resetlogs;

I think that will do it for you.

Rachel
>From: Linda Hagedorn <Linda_at_pets.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Hot backup files, FTP to different box, recovery session canc
>Date: Wed, 07 Jun 2000 08:18:45 -0800
>
>Hi Rachel,
>
>Thanks for the info. I tried the resetlogs, but this is the response.
>It's
>complaining that RESETLOGS option only valid after an incomplete database
>recovery. Do I have the commands in the right order?
>
>Thanks again, Linda
>
>
>SVRMGR> connect internal
>
>Connected.
>SVRMGR> startup mount
>
>ORACLE instance started.
>
>Total System Global Area 784768528 bytes
>
>Fixed Size 48656 bytes
>
>Variable Size 129261568 bytes
>
>Database Buffers 655360000 bytes
>
>Redo Buffers 98304 bytes
>
>Database mounted.
>SVRMGR> alter database open resetlogs;
>
>alter database open resetlogs
>
>*
>
>ORA-01139: RESETLOGS option only valid after an incomplete database
>recovery
>
>SVRMGR> alter database open;
>
>alter database open
>
>*
>
>ORA-01113: file 1 needs media recovery
>
>ORA-01110: data file 1:
>'/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf'
>SVRMGR> recover
>
>ORA-00283: recovery session canceled due to errors
>
>ORA-00322: log 5 of thread 1 is not current copy
>
>ORA-00312: online log 5 thread 1:
>'/opt/oracle/app/oracle/oradata/PETS/log2/red'
>ORA-00322: log 5 of thread 1 is not current copy
>
>ORA-00312: online log 5 thread 1:
>'/opt/oracle/app/oracle/oradata/PETS/log1/red'
>SVRMGR> alter database open resetlogs;
>
>alter database open resetlogs
>
>*
>
>ORA-01139: RESETLOGS option only valid after an incomplete database
>recovery
>
>SVRMGR>
>
>
>--
>Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).