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

You need to do a imcomplete recovery before using the resetlog options.

Instead of typing recover. Type recover database until cancel.

Winnie

Linda Hagedorn <Linda_at_pets.com> on 06/07/2000 09:18:44 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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

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