flashback recovery area restore problems

From: Cris Carampa <cris119_at_operamail.com>
Date: Thu, 21 Jul 2005 11:48:46 +0200
Message-ID: <42df6f9c$0$329$5fc30a8@news.tiscali.it>

Hello, I'm playing with the flashback recovery area with Oracle 10.1.0.4.0 standard edition on Linux.

I did specify a flashback recovery area with DBCA. Archivelogs go there and RMAN backups go there too.

Here are my RMAN options:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/opt/oracle/product/10gr1/dbs/snapcf_bol4.f'; # default

What I'm trying to do is take a full database backup with RMAN ("backup as copy database"), then shut down the database, erase all the database files and trying to recover the database.

Here's my recovery steps:

1. startup nomount
2. RESTORE CONTROLFILE from
   '/var/oracle/flash-recovery-area/BOL4/controlfile/o1_mf_TAG20050721T094957_1fyocprl_.ctl';
   
3. alter database mount ;
4. restore database ;
5. recover database ;

Whan I'm getting after step 5 is always:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 07/21/2005 12:28:57 RMAN-06054: media recovery requesting unknown log: thread 1 seq xxx lowscn yyy

The same thing happens both with "backup as copy database" and "backup as copy database plus archivelog".

What I did that was wrong?

Thank you. Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)
"E` evidente che siamo di fronte allo sfruttamento opportunistico
  di quella quota di astensioni fatalmente derivanti da disinteresse
  o indifferenza." (Gustavo Zagrebelsky)

Received on Thu Jul 21 2005 - 04:48:46 CDT