All Recent Backups Appear "EXPIRED" through RMAN

From: sillz <beth.stover_at_gmail.com>
Date: Tue, 16 Oct 2007 15:34:25 -0700
Message-ID: <1192574065.481987.263310@y27g2000pre.googlegroups.com>

Hi,

I'm very new to disaster recovery on Oracle. I'm hoping to get some help recovering our database to a different server using RMAN. We're doing a disaster recovery drill. The assumption is we have lost our entire site, and we need to restore the database to a newly built server that has been set up with the same configuration as production -- same build, same OS, same Oracle version and patch level, same partition configuration, etc.

This has been set up in an isolated LAN that has no connection to the production systems.

We're using Oracle Database Server, Standard Edition version 9.2.0.7. Windows 2003 SP2. We have created backup sets using autobackup turned on, archive mode on and Backup Exec as the backup solution. They are all online backups. We will be updating to 10g early next year, and it's not an option to do it sooner.

We have created a seed database with the same name as production in our lab environment. We are at the point where we are ready to restore our control files. When we run our recovery commands in RMAN, it cannot locate the autobackups. We force it to search back several days, but it still cannot locate the autobackup. We even put in last night's backup from production (updating the control files in the test lab of course), but the backups cannot be found.

To troubleshoot, I did some listing and crosschecking of the backups through RMAN on both production and in the lab. In the lab, only the control files show as EXPIRED. The database backups in the test lab show as "AVAILABLE," but the control files are also 'EXPIRED'

Both systems are using the exact same control files. I copied them to the test lab this morning.

I set the DBID in the lab to be the same as prod before mounting the database.

Here's the output from RMAN in production. I'm really concerned now because all of the prod backups show as EXPIRED.

RMAN> list backup of controlfile summary; list backup of controlfile summary;

List of Backups

Key TY LV S Device Type Completion Time #Pieces #Copies Tag

------- -- -- - ----------- --------------- ------- ------- ---
600     B  F  X SBT_TAPE    05-OCT-07       1       1
605     B  F  X SBT_TAPE    08-OCT-07       1       1
609     B  F  X SBT_TAPE    09-OCT-07       1       1
613     B  F  X SBT_TAPE    10-OCT-07       1       1
618     B  F  X SBT_TAPE    11-OCT-07       1       1
623     B  F  X SBT_TAPE    12-OCT-07       1       1
628     B  F  X SBT_TAPE    15-OCT-07       1       1

RMAN> list backup of database summary;
list backup of database summary;

List of Backups

Key TY LV S Device Type Completion Time #Pieces #Copies Tag ------- -- -- - ----------- --------------- ------- ------- --- 598 B 0 X SBT_TAPE 05-OCT-07 1 1 TAG20071005T200427
603 B 0 X SBT_TAPE 08-OCT-07 1 1 TAG20071008T200352
607 B 0 X SBT_TAPE 09-OCT-07 1 1 TAG20071009T200214
611 B 0 X SBT_TAPE 10-OCT-07 1 1 TAG20071010T200332
616 B 0 X SBT_TAPE 11-OCT-07 1 1 TAG20071011T200429
621 B 0 X SBT_TAPE 12-OCT-07 1 1 TAG20071012T200536
626 B 0 X SBT_TAPE 15-OCT-07 1 1 TAG20071015T200537 RMAN> crosscheck backup of database;
crosscheck backup of database;
crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_ioiton6b_1_1 recid=598 stamp=635198667 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_itiu0k98_1_1 recid=603 stamp=635457832 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j1iu38i6_1_1 recid=607 stamp=635544134 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_j5iu5t0k_1_1 recid=611 stamp=635630613 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jaiu8hee_1_1 recid=616 stamp=635717070 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jfiub5sh_1_1 recid=621 stamp=635803537 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=BE_jkiuj30h_1_1 recid=626 stamp=636062737 Crosschecked 7 objects

RMAN> crosscheck backup of controlfile;
crosscheck backup of controlfile;
crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071005-00 recid=600 stamp=635201185 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071008-00 recid=605 stamp=635460079 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071009-00 recid=609 stamp=635546291 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071010-00 recid=613 stamp=635632821 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071011-00 recid=618 stamp=635719117 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071012-00 recid=623 stamp=635805984 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=c-11771011-20071015-00 recid=628 stamp=636064774 Crosschecked 7 objects

Does anyone know why all of my recent backups are showing as expired? These backups were performed on production. I'm running the RMAN commands both in production and the test lab. In prodcution, RMAN reports "EXPIRED" for both the control files and the backup.

Here's my show all from RMAN in production:

RMAN> show all;
show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # 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 SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE \SNCFPROD.ORA'; # default

Any thoughts would be really appreciated.

Beth Received on Tue Oct 16 2007 - 17:34:25 CDT