Better Edge Backup v5.2
User Guide
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved.
Page 65 of 121 (September 16, 2008)
ORA-00280: change 547222 for thread 1 is in sequence #384
ORA-00278: log file '/data/ora815/vin/archive/ARCH0000000383.LOG' no longer needed for this
recovery
ORA-00308: cannot open archived log '/data/ora815/vin/archive/ARCH0000000384.LOG'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SVRMGR> recover database using backup controlfile until cancel
ORA-00279: change 547222 generated at 06/18/03 19:58:26 needed for thread 1
ORA-00289: suggestion : /data/ora815/vin/archive/ARCH0000000384.LOG
ORA-00280: change 547222 for thread 1 is in sequence #384
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SVRMGR> alter database open resetlogs;
Statement processed.
(if Oracle 9i) Use Recovery Manager to restore you database by doing the following: a. Run Oracle Server Manager (rman) b. Connect to the target database c. Startup mount d. Reapply all transactions from the archived log f iles to the last sequence e. Open database Oracle 9i Example: C:\>rman nocatalog
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN> connect target
connected to target database (not started)
RMAN> startup mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 269556596 bytes
Fixed Size 453492 bytes
Variable Size 243269632 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
RMAN> recover database until sequence=63 thread=1;
Starting recover at 24-JUN-03
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
starting media recovery
archive log thread 1 sequence 56 is already on disk as file
C:\ORACLE\ORADATA\VIN\ARCHIVE\1_56.DBF
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_56.DBF thread=1 sequence=56
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_57.DBF thread=1 sequence=57
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_58.DBF thread=1 sequence=58
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_59.DBF thread=1 sequence=59
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_60.DBF thread=1 sequence=60
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_61.DBF thread=1 sequence=61
archive log filename=C:\ORACLE\ORADATA\VIN\ARCHIVE\1_62.DBF thread=1 sequence=62
media recovery complete
Finished recover at 24-JUN-03
RMAN> alter database open resetlogs;
database opened