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

From: Linda Hagedorn <Linda_at_pets.com>
Date: Wed, 7 Jun 2000 08:03:52 -0700
Message-Id: <10521.108053@fatcity.com>

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 Received on Wed Jun 07 2000 - 10:03:52 CDT