keep until rman

From: max scalf <oracle.blog3_at_gmail.com>
Date: Fri, 6 Dec 2013 11:54:54 -0600
Message-ID: <CAKoJ+qDgb_Q4+NeCjtgRg=Qb7GtFEiyzJqi+qKdJ8PAg_8t59A_at_mail.gmail.com>

Hello List,

I had a question that i am not able to find an answer on. oracle 11.2.0.3 (NO RECOVER CATALOG) Lets say I run the below backup...and let say i keep that backup for sysdate+365. Now 10 months into that year i get a request to restore that backup on a different server...obviously i tag my backup with "retain", so i can use that to restore database using tag(same with recover)...but for me to get to that point i first need to restore my spfile and control file....and lets assume i do not have the below output as to which backup piece is datafile, control file, spfile backup....how would i get the spfile/control file restore?

would i have to go to each backup file and says restore spfile from file1(if this fails), do restore spfile from file2(if this fails) go on do same for the next file....i guess it would be simple if you only have 5 backup files but if you have 100's of them for that DB that might be a problem...is there a way to overcome that or put something specific in my format caluse so i know that piece 1 is control file backup and piece 2 is spfile backup...any suggestions??

RMAN> backup check logical database format '/backup/test/special_reten/%d_retain_%s_%p_%t_%U' tag 'retain' keep until time 'sysdate+2';

Starting backup at 06-DEC-2013 11:24:09
current log archived

using channel ORA_DISK_1
backup will be obsolete on date 08-DEC-2013 11:24:09 archived logs required to recover from this backup will be backed up channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00004 name=/data/test/users01.dbf
input datafile file number=00001 name=/data/test/system01.dbf
input datafile file number=00002 name=/data/test/sysaux01.dbf
input datafile file number=00003 name=/data/test/undotbs01.dbf

channel ORA_DISK_1: starting piece 1 at 06-DEC-2013 11:24:09 channel ORA_DISK_1: finished piece 1 at 06-DEC-2013 11:24:44 piece
handle=/backup/test/special_reten/TEST_retain_333_1_833455449_adoqr1ap_1_1 tag=RETAIN comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35

using channel ORA_DISK_1
backup will be obsolete on date 08-DEC-2013 11:24:44 archived logs required to recover from this backup will be backed up channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 06-DEC-2013 11:24:44 channel ORA_DISK_1: finished piece 1 at 06-DEC-2013 11:24:45 piece
handle=/backup/test/special_reten/TEST_retain_334_1_833455484_aeoqr1bs_1_1 tag=RETAIN comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

current log archived
using channel ORA_DISK_1
backup will be obsolete on date 08-DEC-2013 11:24:45 archived logs required to recover from this backup will be backed up channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=2 RECID=56 STAMP=833455485 channel ORA_DISK_1: starting piece 1 at 06-DEC-2013 11:24:45 channel ORA_DISK_1: finished piece 1 at 06-DEC-2013 11:24:46 piece
handle=/backup/test/special_reten/TEST_retain_335_1_833455485_afoqr1bt_1_1 tag=RETAIN comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

using channel ORA_DISK_1
backup will be obsolete on date 08-DEC-2013 11:24:46 archived logs required to recover from this backup will be backed up channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 06-DEC-2013 11:24:47 channel ORA_DISK_1: finished piece 1 at 06-DEC-2013 11:24:48 piece
handle=/backup/test/special_reten/TEST_retain_336_1_833455486_agoqr1bu_1_1 tag=RETAIN comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 06-DEC-2013 11:24:48

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 06 2013 - 18:54:54 CET