| Command(s) to applying level 1 backup to level 0 backup set. [message #338689] |
Tue, 05 August 2008 11:48  |
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 #338917 is a reply to message #338689] |
Wed, 06 August 2008 04:43  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
