Better Edge Backup v5.2

User Guide

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

Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved.

Page 65 of 121

(September 16, 2008)

Page 65
Image 65
Deonet Backup Solutions 5.2.7.0 manual Cancel