Fw: RMAN Restore with Incremental

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 2 Apr 2008 09:13:10 -0700 (PDT)
Message-ID: <962058.32554.qm@web38909.mail.mud.yahoo.com>

Sometimes an incremental backup will end up backing up the entire database. This is particularly true if you are not using a block change tracking file. In fact, if you are using retention criteria and the FRA you might well see the base level 0 GO AWAY because, according to the retention criteria, it is really no longer needed.

List the details of your 409400 backup contents. I bet you find all the datafiles in it.


Robert G. Freeman
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

  • Original Message ---- From: Charlotte Hammond <charlottejanehammond_at_yahoo.com> To: oracle-l_at_freelists.org Sent: Wednesday, April 2, 2008 3:23:52 AM Subject: RMAN Restore with Incremental

Hi All,
I'm a bit confused by this RMAN behaviour. I have a full backup and a level 1 incremental a few days later. However if I restore (preview) it only attempts to use the level 1 (example below). Surely this is of no use without the preceeding full backup. What am I missing? Thank you for any hints! ( EE)

RMAN> list backup of database summary;  

List of Backups

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
397695 B F A DISK 27-MAR-08 1 1 YES
409400 B 1 A DISK 31-MAR-08 1 1 YES
TAG20080331T021633 RMAN> restore validate database;
Starting restore at 02-APR-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backupset channel ORA_DISK_1: reading from backup piece /oracle/FRA/TESTDB/backupset/2008_03_31/o1_mf_nnnd1_TAG20080331T021633_3z0gvkk3_.bkp channel ORA_DISK_1: restored backup piece 1 piece
handle=/oracle/FRA/TESTDB/backupset/2008_03_31/o1_mf_nnnd1_TAG20080331T021633_3z0gvkk3_.bkp tag=TAG20080331T021633
channel ORA_DISK_1: validation complete, elapsed time: 00:00:47 Finished restore at 02-APR-08  

You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com



http://www.freelists.org/webpage/oracle-l Received on Wed Apr 02 2008 - 11:13:10 CDT

Original text of this message