| Incremental backup Doubt! [message #256685] |
Mon, 06 August 2007 05:40  |
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
|
Member |
|
|
Hi,
In 10g is there any new feature to merge the incremental backups?
ie :
Monday - Level 0 (incremental) with tag level_0_mon
Tuesday - Level 1 (incremental) with tag level_1_tue
Wednesday - Level 1 (incremental) with tag level_1_wed
In the above schedule, shall i merge the tuesday level backup with the monday level 0 backup and keep it as fullbackup upto tuesday ?
I read it in oracle doc but i cant understand it clearly so asking. plz...
|
|
|
|
|
|
| Re: Incremental backup Doubt! [message #257005 is a reply to message #256685] |
Tue, 07 August 2007 06:50  |
nani_ar
Messages: 58
Registered: March 2006
|
Member |
|
|
hi,
u can use
BACKUP INCREMENTAL LEVEL 1
FOR RECOVER OF COPY
WITH TAG WEEKLY DATABASE;
on all days to merge the incremental backups with the full backup taken with the tag 'weekly'. This will backup the changes occured during the normal days and merge it with the full backup, making the current day's backup as the full backup..However, this is applicable to disk backups only
|
|
|
|
|
|
|
|
| Re: Incremental backup Doubt! [message #260699 is a reply to message #256685] |
Mon, 20 August 2007 14:03 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
| navaneethdba wrote on Mon, 06 August 2007 06:40 | Hi,
In 10g is there any new feature to merge the incremental backups?
ie :
Monday - Level 0 (incremental) with tag level_0_mon
Tuesday - Level 1 (incremental) with tag level_1_tue
Wednesday - Level 1 (incremental) with tag level_1_wed
In the above schedule, shall i merge the tuesday level backup with the monday level 0 backup and keep it as fullbackup upto tuesday ?
I read it in oracle doc but i cant understand it clearly so asking. plz...
|
Level0 is a level0 .. lowest level. There is no INCREMENTAL on this.
Then you wanna do CUMULITIVE L1 on Tue and then another CUNULITIVE L1 on Wed. In this manner, the CU of Wednesday covers the backup of Tuesday.
Is this what you were asking ??
[Updated on: Mon, 20 August 2007 14:04] Report message to a moderator |
|
|
|
| Re: Incremental backup Doubt! [message #260805 is a reply to message #260699] |
Tue, 21 August 2007 00:15 |
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
|
Member |
|
|
Hi,
No ya.
In 10g new feature which can merge the incremental backups.
Ex:
if u have taken a full backup on monday(level 0),tuesday level 1,wednesday level 1, thursday level 1, friday level 1.
if Saturday database crashed.Prior to 10g, What we do is restore fullbackup (level 0) and apply all 4 incremental backups.It will take a long time.
In 10g using Incremental merge, we merge the monday(level 0) backup with tuesday (level 1) backup and we can keep it as tuesday fullbackup. like wise we can merge all incremental backups and then restore. So it cuts down the recovery time. And also avoids the need of taking full backup.
Refer this link...
http://www.oracle.com/technology/pub/articles/10gdba/week9_10gdba.html
Regards,
VNK
|
|
|
|
| Re: Incremental backup Doubt! [message #261014 is a reply to message #256685] |
Tue, 21 August 2007 09:24 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Well that is a nice feature to have (in 10g).
What we usually do is
Mon L0
Tue L1 CUML
Wed L1 CUML
Thu L1 CUML
Fri L1 CUML
so let's say you have a crash on Sat, then I need to get just the Mon L0 and Fri L1 and then PIT.
With this feature, basically you are doing some work BEFORE the restore (merge Mon, Tue, Wed, Thu and Fri and make it a L0) and then a little more work after wards.
Nice.
--
Sanjay B.
[Updated on: Tue, 21 August 2007 09:24] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
