Database Software

Hi,

I'm trying to recover up through a particular archive log file, and I cannot get RMAN to accept the request.

Here's what happens:
1. I restore a control file and database using RMAN (works fine)
2. I enter RMAN and catalog some archived log files (works fine - apparently)
3. I try to recover until a particular log file (fails - saying RMAN can't find the archived log file)
4. I try to recover until a SCN in one of the cataloged archived log files (works - and shows the thread/sequence that it said it couldn't find before!)

Is this a bug?

Any ideas will be greatly appreciated.

Thanks in advance,

David


Note the following RMAN session:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
RMAN> SHUTDOWN IMMEDIATE;
2> STARTUP NOMOUNT;
3> RESTORE CONTROLFILE FROM '/export/data/Backups/working/TESTDB.ctl';
4> MOUNT DATABASE;
5> RESTORE DATABASE;
6>
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started

Total System Global Area 286187904 bytes

Fixed Size 434560 bytes
Variable Size 218103808 bytes
Database Buffers 67108864 bytes
Redo Buffers 540672 bytes

Starting restore at 22-NOV-02

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
channel ORA_DISK_1, controlfile autobackup found: /export/data/Backups/working/TESTDB.ctl
channel ORA_DISK_1, controlfile autobackup restore complete
replicating controlfile
input filename=/export/apps/oracle9i/oradata/TESTDB/control01.ctl
output filename=/export/apps/oracle9i/oradata/TESTDB/control02.ctl
output filename=/export/apps/oracle9i/oradata/TESTDB/control03.ctl
Finished restore at 22-NOV-02

database mounted

Starting restore at 22-NOV-02

using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /export/apps/oracle9i/oradata/TESTDB/system01.dbf
restoring datafile 00002 to /export/apps/oracle9i/oradata/TESTDB/UNDOTBS.dbf
restoring datafile 00003 to /export/apps/oracle9i/oradata/TESTDB/cwmlite01.dbf
restoring datafile 00004 to /export/apps/oracle9i/oradata/TESTDB/drsys01.dbf
restoring datafile 00005 to /export/apps/oracle9i/oradata/TESTDB/example01.dbf
restoring datafile 00006 to /export/apps/oracle9i/oradata/TESTDB/indx01.dbf
restoring datafile 00007 to /export/apps/oracle9i/oradata/TESTDB/tools01.dbf
restoring datafile 00008 to /export/apps/oracle9i/oradata/TESTDB/users01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/export/data/Backups/working/TESTDB tag=null params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 22-NOV-02

Recovery Manager complete.
374 oracle@helios:/export/home/oracle/bin > !rman
rman TARGET sys/change_on_install@TESTDB NOCATALOG

Recovery Manager: Release 9.0.1.1.0 - 64bit Production

(c) Copyright 2001 Oracle Corporation. All rights reserved.

connected to target database: TESTDB (DBID=2260663153)
using target database controlfile instead of recovery catalog

RMAN> catalog archivelog '/export/apps/oracle9i/oradata/TESTDB/archive/1_1.dbf';

cataloged archive log
archive log filename=/export/apps/oracle9i/oradata/TESTDB/archive/1_1.dbf recid=9 stamp=478636816
RMAN> catalog archivelog '/export/apps/oracle9i/oradata/TESTDB/archive/1_2.dbf';

cataloged archive log
archive log filename=/export/apps/oracle9i/oradata/TESTDB/archive/1_2.dbf recid=10 stamp=478636824

RMAN> catalog archivelog '/export/apps/oracle9i/oradata/TESTDB/archive/1_3.dbf';

cataloged archive log
archive log filename=/export/apps/oracle9i/oradata/TESTDB/archive/1_3.dbf recid=11 stamp=478636830

RMAN> recover database until sequence=2 thread=1;

Starting recover at 22-NOV-02
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=8 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 11/22/2002 18:41:15
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-06003: ORACLE error from target database: RMAN-20206: log sequence not found in the recovery catalog

RMAN> recover database until scn=235865;

Starting recover at 22-NOV-02
using channel ORA_DISK_1



starting media recovery

archive log thread 1 sequence 1 is already on disk as file /export/apps/oracle9i/oradata/TESTDB/archive/1_1.dbf
archive log thread 1 sequence 2 is already on disk as file /export/apps/oracle9i/oradata/TESTDB/archive/1_2.dbf
archive log filename=/export/apps/oracle9i/oradata/TESTDB/archive/1_1.dbf thread=1 sequence=1
archive log filename=/export/apps/oracle9i/oradata/TESTDB/archive/1_2.dbf thread=1 sequence=2
media recovery complete
Finished recover at 22-NOV-02
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~