RMAN TSPITR Puzzle
Date: Wed, 25 May 2011 10:12:06 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E1257ECE393_at_ONEWS06.oneneck.corp>
Hi list,
I'm trying to do an automated Tablespace Point In Time Recovery (TSPITR) with RMAN and I'm stumped on why it is requiring an old controlfile, which unfortunately is offsite already. I've got a good full backup from 5/21, but when I try to run TSPITR to the log sequence backed up at the end of that backup, RMAN tries to restore the control file from 5/14, before the last full backup. Any idea why it would need to restore that control file instead of the one taken after the most recent full backup?
Here are the details:
Version: 10.2.0.4
Backup schedule: Weekly full hot backups every Saturday night only (this is a dev DB)
Backup command used: BACKUP DATABASE PLUS ARCHIVELOG
Here you can see the archive log backup completed for sequence 646 after the full backup on 5/21, and the subsequent control file autobackup:
Starting backup at 21-MAY-11 23:04
current log archived
channel ch00: starting compressed archive log backupset
channel ch00: specifying archive log(s) in backup set
input archive log thread=1 sequence=646 recid=600 stamp=751763048
channel ch00: starting piece 1 at 21-MAY-11 23:04
channel ch00: finished piece 1 at 21-MAY-11 23:36
piece handle=baandev_al_367_1_751763049 tag=BAANDEV_HOT_DB_BK_FULL comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:32:46
channel ch00: deleting archive log(s)
archive log filename=/baandev/oraarc/1_646_724152171.dbf recid=600 stamp=751763048
Finished backup at 21-MAY-11 23:36
Starting Control File and SPFILE Autobackup at 21-MAY-11 23:36 piece handle=c-18885843-20110521-00 comment=API Version 2.0,MMS Version 5.0.0.0 Finished Control File and SPFILE Autobackup at 21-MAY-11 23:46
Here you can see the TSPITR command I'm running with UNTIL SEQUENCE 647 because that means it should apply up to sequence 646, which was the last log from the hot backup on 5/21 above:
RMAN> RECOVER TABLESPACE baan6data, baan6indx UNTIL SEQUENCE 647 THREAD 1 AUXILIARY DESTINATION '/baandev/oradat/auxdest';
And, here you can see RMAN is trying to restore the control file backup from the previous weekend, 5/14, instead of the one on 5/21, and it's failing because the backup from 5/14 has already been shipped offsite:
channel ORA_AUX_SBT_TAPE_1: starting datafile backupset restore channel ORA_AUX_SBT_TAPE_1: restoring control file channel ORA_AUX_SBT_TAPE_1: reading from backup piece c-18885843-20110514-00 ORA-19870: error reading backup piece c-18885843-20110514-00 ORA-19507: failed to retrieve sequential file, handle="c-18885843-20110514-00", parms=""ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text:
Failed to open backup file for restore. failover to previous backup
Thanks in advance for your time and any ideas on why this could be happening.
Brandon
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2011 - 12:12:06 CDT