Home » RDBMS Server » Backup & Recovery » Command(s) to applying level 1 backup to level 0 backup set. (10g)
Command(s) to applying level 1 backup to level 0 backup set. [message #338689] Tue, 05 August 2008 11:48 Go to next message
zaff
Messages: 50
Registered: July 2008
Member
Hi guys,
This is the output of ‘list backupset’:
List of Backup Sets
===================


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------
64 Incr 0 1.05G DISK 00:03:44 05-AUG-08 BP Key: 64 Status: AVAILABLE Compressed: NO Tag: TAG20080805T154418
Piece Name: D:\RMAN_BACKUPS\MYTESTDB\2QJN9K6K
List of Datafiles in backup set 64
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 1020188 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\SYSTEM01.DBF
2 0 Incr 1020188 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\SYSAUX01.DBF
3 0 Incr 1020188 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\UNDOTBS01.DBF
4 0 Incr 1020188 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\USERS01.DBF
5 0 Incr 1020188 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------
67 Incr 1 9.42M DISK 00:00:06 05-AUG-08
BP Key: 67 Status: AVAILABLE Compressed: NO Tag: TAG20080805T155323
Piece Name: D:\RMAN_BACKUPS\MYTESTDB\2TJN9KQK
SPFILE Included: Modification time: 05-AUG-08
SPFILE db_unique_name: MYTESTDB
Control File Included: Ckp SCN: 1020545 Ckp time: 05-AUG-08

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------
68 Incr 1 1.62M DISK 00:01:42 05-AUG-08
BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20080805T170131
Piece Name: D:\RMAN_BACKUPS\MYTESTDB\2UJN9ONC
List of Datafiles in backup set 68
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 1 Incr 1022350 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\SYSTEM01.DBF
2 1 Incr 1022350 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\SYSAUX01.DBF
3 1 Incr 1022350 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\UNDOTBS01.DBF
4 1 Incr 1022350 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\USERS01.DBF
5 1 Incr 1022350 05-AUG-08 D:\APP\ORACLE\ORADATA\MYTESTDB\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------
69 Incr 1 9.42M DISK 00:00:05 05-AUG-08
BP Key: 69 Status: AVAILABLE Compressed: NO Tag: TAG20080805T170131
Piece Name: D:\RMAN_BACKUPS\MYTESTDB\2VJN9OQO
SPFILE Included: Modification time: 05-AUG-08
SPFILE db_unique_name: MYTESTDB
Control File Included: Ckp SCN: 1022379 Ckp time: 05-AUG-08

How do I apply backup set #68 (level 1) to the full backup #64 (level 0)?

Thanks in advance,
Zaff
Re: Command(s) to applying level 1 backup to level 0 backup set. [message #338695 is a reply to message #338689] Tue, 05 August 2008 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean "apply"?

Regards
Michel
Re: Command(s) to applying level 1 backup to level 0 backup set. [message #338718 is a reply to message #338689] Tue, 05 August 2008 16:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It will do so if necessary during restore/recovery.
Re: Command(s) to applying level 1 backup to level 0 backup set. [message #338917 is a reply to message #338689] Wed, 06 August 2008 04:43 Go to previous messageGo to next message
zaff
Messages: 50
Registered: July 2008
Member
well, by 'apply' i meant, applying changes in the incremental backup to the level 0 full backupset to bring it up-to-date.

I just found out that this is NOT possible with backup sets, this can only be done with image copies. So i'm assuming the changes in the incrementals are only applied at the point of restore/recovery.

Thanks,
Zaff
Re: Command(s) to applying level 1 backup to level 0 backup set. [message #338935 is a reply to message #338917] Wed, 06 August 2008 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is correct.

By the way, you already posted this 10 days ago in http://www.orafaq.com/forum/m/336310/102589/#msg_336310 and this answer was the same one.

Regards
Michel
Re: Command(s) to applying level 1 backup to level 0 backup set. [message #338938 is a reply to message #338689] Wed, 06 August 2008 05:06 Go to previous messageGo to next message
zaff
Messages: 50
Registered: July 2008
Member
Well, in the previous post the answer was slightly ambiguous and I wasn’t sure if my issue was clear enough. So I thought I simplify the issue.

Thanks for your help guys.
Re: Command(s) to applying level 1 backup to level 0 backup set. [message #338944 is a reply to message #338938] Wed, 06 August 2008 05:15 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ambiguous? Well, you could go on on the same topic and not start a new one then we can post immediatly an accurate answer and save time.

Regards
Michel
Previous Topic: Block Corruption through RMAN
Next Topic: How we can recover through RMAN...
Goto Forum:
  


Current Time: Thu Dec 08 18:05:05 CST 2016

Total time taken to generate the page: 0.10175 seconds