Home » RDBMS Server » Backup & Recovery » My question about incremental backup
My question about incremental backup [message #529172] Sat, 29 October 2011 04:35 Go to next message
khosravi
Messages: 68
Registered: April 2006
Member
Hello

I've seen that RMAN sometimes read and apply "incremental level 1" backups in RESTORE stage and sometimes at RECOVER stage

I don't know what conditions cause RMAN read and apply incremental level 1 backups at RECOVER stage
and what conditions cause RMAN read and apply incremental level 1 backups at RESTORE stage

can you tell me ?

thanks
Re: My question about incremental backup [message #529173 is a reply to message #529172] Sat, 29 October 2011 05:14 Go to previous messageGo to next message
John Watson
Messages: 4863
Registered: January 2010
Location: Global Village
Senior Member
I thought that incremental level 1 backups were applied only during RECOVER, never during RESTORE. Can you copy/paste an RMAN session that shows a level 1 being applied in a RESTORE command?
Re: My question about incremental backup [message #529235 is a reply to message #529173] Sun, 30 October 2011 02:45 Go to previous messageGo to next message
khosravi
Messages: 68
Registered: April 2006
Member
Hi

In follow I pasted a RMAN log that RMAN has used some incremental backups in RESTORE stage and some in RECOVER stage (all logs are related to full restore and recover of a big database)
In this restore RMAN not only used incremental backups in RESTORE stage but even before the full backup
(I didn't paste all log )


RMAN>
Starting restore at 11-OCT-29 15:35:32

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=16 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=17 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=18 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=19 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=20 devtype=DISK
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00031 to /ORAmis/ora9ent/oradata/ARAHISTO/statespack_ts.dbf
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00032 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df01.dbf
restoring datafile 00033 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df02.dbf
restoring datafile 00034 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df03.dbf
restoring datafile 00035 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df04.dbf
restoring datafile 00036 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df05.dbf
restoring datafile 00037 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df01.dbf
restoring datafile 00038 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df02.dbf
restoring datafile 00039 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df03.dbf
restoring datafile 00040 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df04.dbf
restoring datafile 00041 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df05.dbf
restoring datafile 00042 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df01.dbf
restoring datafile 00043 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df02.dbf
restoring datafile 00044 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df03.dbf
restoring datafile 00045 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df04.dbf
restoring datafile 00046 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df05.dbf
restoring datafile 00047 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df01.dbf
restoring datafile 00048 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df02.dbf
restoring datafile 00049 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df03.dbf
restoring datafile 00050 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df04.dbf
restoring datafile 00051 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df05.dbf
channel ORA_DISK_4: starting datafile backupset restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
restoring datafile 00052 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs101.dbf
restoring datafile 00053 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs102.dbf
restoring datafile 00054 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs103.dbf
restoring datafile 00055 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs104.dbf
restoring datafile 00056 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs105.dbf
restoring datafile 00057 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs201.dbf
restoring datafile 00058 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs202.dbf
restoring datafile 00059 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs203.dbf
restoring datafile 00060 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs204.dbf
restoring datafile 00061 to /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs205.dbf
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /ORAmis/ora9ent/oradata/ARAHISTO/system01.dbf
restoring datafile 00002 to /ORAmis/ora9ent/oradata/ARAHISTO/audit_trail_01.dbf
restoring datafile 00003 to /ORAmis/ora9ent/oradata/ARAHISTO/cwmlite01.dbf
restoring datafile 00004 to /ORAmis/ora9ent/oradata/ARAHISTO/drsys01.dbf
restoring datafile 00005 to /ORAmis/ora9ent/oradata/ARAHISTO/example01.dbf
restoring datafile 00006 to /ORAmis/ora9ent/oradata/ARAHISTO/indx01.dbf
restoring datafile 00007 to /ORAmis/ora9ent/oradata/ARAHISTO/odm01.dbf
restoring datafile 00008 to /ORAmis/ora9ent/oradata/ARAHISTO/tools01.dbf
restoring datafile 00009 to /ORAmis/ora9ent/oradata/ARAHISTO/users01.dbf
restoring datafile 00010 to /ORAmis/ora9ent/oradata/ARAHISTO/xdb01.dbf
restoring datafile 00011 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_01.dbf
restoring datafile 00012 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_01.dbf
restoring datafile 00013 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_SMALL_01.dbf
restoring datafile 00014 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_01.dbf
restoring datafile 00015 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_01.dbf
restoring datafile 00016 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_02.dbf
restoring datafile 00017 to /ORAmis/ora9ent/oradata/ARAHISTO/undotbs201.dbf
restoring datafile 00018 to /ORAmis/ora9ent/oradata/ARAHISTO/undotbs202.dbf
restoring datafile 00019 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_02.dbf
restoring datafile 00020 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_02.dbf
restoring datafile 00021 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_02.dbf
restoring datafile 00022 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_SMALL_02.dbf
restoring datafile 00023 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_03.dbf
restoring datafile 00024 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_04.dbf
restoring datafile 00025 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_03.dbf
restoring datafile 00026 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_03.dbf
restoring datafile 00027 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_04.dbf
restoring datafile 00028 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_04.dbf
restoring datafile 00029 to /ORAmis/ora9ent/oradata/ARAHISTO/undotbs203.dbf
restoring datafile 00030 to /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_03.dbf
channel ORA_DISK_3: restored backup piece 1
piece handle=/RmanAramis/arahisto/bs/db_incre_date_20111006_ts_763786071_ARAHISTO_3587.bk tag=TAG20111006T020003 params=NULL
channel ORA_DISK_3: restore complete
channel ORA_DISK_2: restored backup piece 1
piece handle=/RmanAramis/arahisto/bs/db_incre_date_20111004_ts_763610404_ARAHISTO_3560.bk tag=TAG20111004T020003 params=NULL
channel ORA_DISK_2: restore complete
channel ORA_DISK_4: restored backup piece 1
piece handle=/RmanAramis/arahisto/bs/db_incre_date_20111010_ts_764128805_ARAHISTO_3601.bk tag=TAG20111010T020004 params=NULL
channel ORA_DISK_4: restore complete
channel ORA_DISK_1: restored backup piece 1
piece handle=/RmanAramis/arahisto/bs/db_full_date_20111003_ts_763576066_ARAHISTO_3557.bk tag=FULL_WEEKLY_L0 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 11-OCT-29 16:11:52

Starting recover at 11-OCT-29 16:17:05
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /ORAmis/ora9ent/oradata/ARAHISTO/system01.dbf
destination for restore of datafile 00002: /ORAmis/ora9ent/oradata/ARAHISTO/audit_trail_01.dbf
destination for restore of datafile 00003: /ORAmis/ora9ent/oradata/ARAHISTO/cwmlite01.dbf
destination for restore of datafile 00004: /ORAmis/ora9ent/oradata/ARAHISTO/drsys01.dbf
destination for restore of datafile 00005: /ORAmis/ora9ent/oradata/ARAHISTO/example01.dbf
destination for restore of datafile 00006: /ORAmis/ora9ent/oradata/ARAHISTO/indx01.dbf
destination for restore of datafile 00007: /ORAmis/ora9ent/oradata/ARAHISTO/odm01.dbf
destination for restore of datafile 00008: /ORAmis/ora9ent/oradata/ARAHISTO/tools01.dbf
destination for restore of datafile 00009: /ORAmis/ora9ent/oradata/ARAHISTO/users01.dbf
destination for restore of datafile 00010: /ORAmis/ora9ent/oradata/ARAHISTO/xdb01.dbf
destination for restore of datafile 00011: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_01.dbf
destination for restore of datafile 00012: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_01.dbf
destination for restore of datafile 00013: /ORAmis/ora9ent/oradata/ARAHISTO/TS_SMALL_01.dbf
destination for restore of datafile 00014: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_01.dbf
destination for restore of datafile 00015: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_01.dbf
destination for restore of datafile 00016: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_02.dbf
destination for restore of datafile 00017: /ORAmis/ora9ent/oradata/ARAHISTO/undotbs201.dbf
destination for restore of datafile 00018: /ORAmis/ora9ent/oradata/ARAHISTO/undotbs202.dbf
destination for restore of datafile 00019: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_02.dbf
destination for restore of datafile 00020: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_02.dbf
destination for restore of datafile 00021: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_02.dbf
destination for restore of datafile 00022: /ORAmis/ora9ent/oradata/ARAHISTO/TS_SMALL_02.dbf
destination for restore of datafile 00023: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_03.dbf
destination for restore of datafile 00024: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_PART_04.dbf
destination for restore of datafile 00025: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_03.dbf
destination for restore of datafile 00026: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_03.dbf
destination for restore of datafile 00027: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_PART_04.dbf
destination for restore of datafile 00028: /ORAmis/ora9ent/oradata/ARAHISTO/TS_MEDIUM_04.dbf
destination for restore of datafile 00029: /ORAmis/ora9ent/oradata/ARAHISTO/undotbs203.dbf
destination for restore of datafile 00030: /ORAmis/ora9ent/oradata/ARAHISTO/TS_BIG_03.dbf
channel ORA_DISK_2: starting incremental datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00032: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df01.dbf
destination for restore of datafile 00033: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df02.dbf
destination for restore of datafile 00034: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df03.dbf
destination for restore of datafile 00035: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df04.dbf
destination for restore of datafile 00036: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df05.dbf
destination for restore of datafile 00037: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df01.dbf
destination for restore of datafile 00038: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df02.dbf
destination for restore of datafile 00039: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df03.dbf
destination for restore of datafile 00040: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df04.dbf
destination for restore of datafile 00041: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df05.dbf
destination for restore of datafile 00042: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df01.dbf
destination for restore of datafile 00043: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df02.dbf
destination for restore of datafile 00044: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df03.dbf
destination for restore of datafile 00045: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df04.dbf
destination for restore of datafile 00046: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df05.dbf
destination for restore of datafile 00047: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df01.dbf
destination for restore of datafile 00048: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df02.dbf
destination for restore of datafile 00049: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df03.dbf
destination for restore of datafile 00050: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df04.dbf
destination for restore of datafile 00051: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df05.dbf
channel ORA_DISK_2: restored backup piece 1
piece handle=/RmanAramis/arahisto/bs/db_incre_date_20111008_ts_763958860_ARAHISTO_3592.bk tag=TAG20111008T020003 params=NULL
channel ORA_DISK_2: restore complete
channel ORA_DISK_2: starting incremental datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00032: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df01.dbf
destination for restore of datafile 00033: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df02.dbf
destination for restore of datafile 00034: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df03.dbf
destination for restore of datafile 00035: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df04.dbf
destination for restore of datafile 00036: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_1_df05.dbf
destination for restore of datafile 00037: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df01.dbf
destination for restore of datafile 00038: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df02.dbf
destination for restore of datafile 00039: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df03.dbf
destination for restore of datafile 00040: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df04.dbf
destination for restore of datafile 00041: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_tb_tbs_32k_2_df05.dbf
destination for restore of datafile 00042: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df01.dbf
destination for restore of datafile 00043: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df02.dbf
destination for restore of datafile 00044: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df03.dbf
destination for restore of datafile 00045: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df04.dbf
destination for restore of datafile 00046: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_2_df05.dbf
destination for restore of datafile 00047: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df01.dbf
destination for restore of datafile 00048: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df02.dbf
destination for restore of datafile 00049: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df03.dbf
destination for restore of datafile 00050: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df04.dbf
destination for restore of datafile 00051: /ORAmis/ora9ent/oradata/ARAHISTO/mdb_ind_tbs_32k_1_df05.dbf
channel ORA_DISK_2: restored backup piece 1
piece handle=/RmanAramis/arahisto/bs/db_incre_date_20111009_ts_764045251_ARAHISTO_3597.bk tag=TAG20111009T020004 params=NULL


Re: My question about incremental backup [message #529241 is a reply to message #529235] Sun, 30 October 2011 03:46 Go to previous messageGo to next message
John Watson
Messages: 4863
Registered: January 2010
Location: Global Village
Senior Member
Hi - the message that indicates applying an incremental backup is "starting incremental datafile backup set restore" which occurs only during your recoverey, not during the restore.

Why do you believe that an incremental is being applied during the restore? Is it because of this message:
piece handle=/RmanAramis/arahisto/bs/db_incre_date_20111006_ts_763786071_ARAHISTO_3587.bk tag=TAG20111006T020003 params=NULL
channel ORA_DISK_3: restore complete

Just because the name includes the string "...incre..." does not mean that it is an incremental level 1 rather than a level 0. Is it possible that your backup script requested a level 1 backup, but because no level 0 existed at that time RMAN did a level 0 instread, and that is what is being restored? Remember that a FULL backup can't be used as a basis for a level 1. I am relying on your naming convention: the tag FULL_WEEKLY_L0 suggests that it was created as FULL rather than level0.

Re: My question about incremental backup [message #529242 is a reply to message #529235] Sun, 30 October 2011 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 60011
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think it uses incremental 1 backup in restore when the file didn't exist in incremental 0 or full (that is when it has been created after the incremental 0).

Regards
Michel
Re: My question about incremental backup [message #529253 is a reply to message #529242] Sun, 30 October 2011 06:11 Go to previous message
khosravi
Messages: 68
Registered: April 2006
Member
Thank all of you

Michel you are right if we add a datafile after incremental level 0 backup then we backup incremental level 1 , In RESTORE rman uses the incremental level 1 backup
Previous Topic: rman tuning - one question
Next Topic: rman target xxx/xxx@tnsname
Goto Forum:
  


Current Time: Sun Dec 21 09:38:02 CST 2014

Total time taken to generate the page: 0.07565 seconds