RE: RMAN TSPITR Puzzle
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "Brandon.Allen@xxxxxxxxxxx" <Brandon.Allen@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 May 2011 11:52:14 -0400
Brandon,
You only show the 'RECOVER' command. Did you do an explicit 'RESTORE
TABLESPACE' before the 'RECOVER TABLESPACE'? Did you have a corresponding
'until sequence 647' clause specified for the 'RESTORE'?
-Mark
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Allen, Brandon
Sent: Wednesday, May 25, 2011 1:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN TSPITR Puzzle
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.
Other related posts:
