> hello Niall, > > This ths second output, in the second scenario, I have put the wrong > output. This is the correct. > Thanks, > > > [oracle@wissem backupset]$ rlrman target / > > Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 3 22:13:10 2011 > > Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. > > connected to target database: ORAWISS (DBID=3175451436) > > RMAN> run{ > > 2> allocate channel dev1 type disk; > > 3> set until time "to_date('2011-01-07:21:35:36', 'yyyy-dd-mm:hh24:mi:ss')"; > > 4> restore database; > > 5> recover database; > > 6> } > > using target database control file instead of recovery catalog > > allocated channel: dev1 > > channel dev1: SID=19 device type=DISK > > executing command: SET until clause > > Starting restore at 03-JUL-11 > > released channel: dev1 > > RMAN-00571: =========================================================== > > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > > RMAN-00571: =========================================================== > > RMAN-03002: failure of restore command at 07/03/2011 22:13:32 > > RMAN-06026: some targets not found - aborting restore > > RMAN-06023: no backup or copy of datafile 5 found to restore > > RMAN-06023: no backup or copy of datafile 4 found to restore > > RMAN-06023: no backup or copy of datafile 2 found to restore > > RMAN-06023: no backup or copy of datafile 1 found to restore > > RMAN> > > > > > On 6 July 2011 10:17, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: > >> I'm probably missing something, but your second scenario seems to be >> trying to recover into the future. >> >> On 6 Jul 2011 08:44, "wissem elkhlifi" <wissem@xxxxxxxxxxxxxxxx> wrote: >> >> Hi, >> >> About RMAN incremental updated backup.I am comparing between the use >> of “until time” clause and not including this clause "until time" in my >> backups. >> With our backup strategy, we need to recover the database to any time >> within the past 31 days and we weekly move the backups to tape. >> From the output below, I have the coclusion to use UNTIL TIME clause >> if we want to recover the database to any point in time >> within the recovery window of 31 days. But, we have backup tapes! What >> do you think? >> >> 1- First Backup Script >> >> CONNECT TARGET / >> >> CROSSCHECK BACKUP; >> CROSSCHECK ARCHIVELOG ALL; >> >> # Incrementally updated backup. >> RECOVER COPY OF DATABASE WITH TAG 'LVL0_MERGE_INCR' UNTIL TIME >> 'SYSDATE-31'; >> BACKUP CHECK LOGICAL INCREMENTAL LEVEL 1 CUMULATIVE COPIES=1 FOR >> RECOVER OF COPY WITH TAG 'LVL0_MERGE_INCR' DATABASE; >> >> # Switch current logfile to archive >> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; >> >> # Backup archivelogs >> BACKUP CHECK LOGICAL AS COMPRESSED BACKUPSET FILESPERSET 10 ARCHIVELOG >> ALL DELETE INPUT; >> >> # delete obsolete backups >> CROSSCHECK BACKUP; >> DELETE NOPROMPT OBSOLETE; >> DELETE NOPROMPT EXPIRED BACKUP; >> >> exit; >> >> 2- Second backup script: >> >> CONNECT TARGET / >> >> CROSSCHECK BACKUP; >> CROSSCHECK ARCHIVELOG ALL; >> >> # Incrementally updated backup. >> RECOVER COPY OF DATABASE WITH TAG 'LVL0_MERGE_INCR'; >> BACKUP CHECK LOGICAL INCREMENTAL LEVEL 1 CUMULATIVE COPIES=1 FOR >> RECOVER OF COPY WITH TAG 'LVL0_MERGE_INCR' DATABASE; >> >> # Switch current logfile to archive >> sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; >> >> # Backup archivelogs >> BACKUP CHECK LOGICAL AS COMPRESSED BACKUPSET FILESPERSET 10 ARCHIVELOG >> ALL DELETE INPUT; >> >> # delete obsolete backups >> CROSSCHECK BACKUP; >> DELETE NOPROMPT OBSOLETE; >> DELETE NOPROMPT EXPIRED BACKUP; >> >> exit; >> >> My database is 11gR2. >> >> RMAN settings are the same for both scenarios and are the following >> and my db is in archivelog mode: >> >> RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; >> >> RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS; >> >> >> 1- Backup Script number one: >> >> WITH UNTIL CLAUSE >> RECOVER COPY OF DATABASE WITH TAG ‘LVL0_MERGE_INCR’ UNTIL TIME >> ‘SYSDATE-31′; >> >> Now, using RMAN we will try to recover the database to a time in the >> past within the 31 days of recovery window. >> >> RMAN> run{ >> >> 2> allocate channel dev1 type disk; >> >> 3> set until time "to_date('2011-28-06:20:55:36', >> 'yyyy-dd-mm:hh24:mi:ss')"; >> >> 4> restore database; >> >> 5> recover database; >> >> 6> } >> >> allocated channel: dev1 >> >> channel dev1: SID=395 device type=DISK >> >> executing command: SET until clause >> >> .... (content truncated) >> >> media recovery complete, elapsed time: 00:00:01 >> >> Finished recover at 01-JUL-11 >> >> released channel: dev1 >> >> RMAN> >> >> >> SQL> alter database open resetlogs; >> >> Database altered. >> >> >> From the output above, you can see we can recover the database to any >> point in time within the 31 days of recovery window. >> >> 2- Backup Script number two: >> >> Without the until time clause >> >> RECOVER COPY OF DATABASE WITH TAG ‘LVL0_MERGE_INCR’; >> >> >> [oracle@wissem backupset]$ rlrman target / >> >> Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 28 >> 23:25:35 2011 >> >> Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights >> reserved. >> >> connected to target database: ORAWISS (DBID=3175451436) >> >> RMAN> run{ >> 2> set until time "to_date('2011-01-07:21:35:36', >> 'yyyy-dd-mm:hh24:mi:ss')"; >> 3> restore database; >> 4> recover database; >> 5> } >> >> executing command: SET until clause >> >> Starting restore at 28-JUN-11 >> using target database control file instead of recovery catalog >> allocated channel: ORA_DISK_1 >> channel ORA_DISK_1: SID=395 device type=DISK >> allocated channel: ORA_DISK_2 >> channel ORA_DISK_2: SID=10 device type=DISK >> >> RMAN-00571: >> =========================================================== >> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS >> =============== >> RMAN-00571: >> =========================================================== >> RMAN-03002: failure of restore command at 06/28/2011 23:25:53 >> RMAN-06026: some targets not found - aborting restore >> RMAN-06023: no backup or copy of datafile 5 found to restore >> RMAN-06023: no backup or copy of datafile 4 found to restore >> RMAN-06023: no backup or copy of datafile 2 found to restore >> RMAN-06023: no backup or copy of datafile 1 found to restore >> >> RMAN> >> >> We have all the backups, we cannot recover within the recovery window >> of 31 days. >> But, if we will have backups in tape, is it possible to have this >> error? >> >> >> Thank you >> >> > --