Home » RDBMS Server » Backup & Recovery » Incremental backup Doubt!
Incremental backup Doubt! [message #256685] Mon, 06 August 2007 05:40 Go to next message
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 #256687 is a reply to message #256685] Mon, 06 August 2007 05:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

just
 cumulative
Re: Incremental backup Doubt! [message #257005 is a reply to message #256685] Tue, 07 August 2007 06:50 Go to previous messageGo to next message
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 #257011 is a reply to message #257005] Tue, 07 August 2007 07:01 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Thanx for reply....

so we can merge the incremental level 1 backups with incremental level 0 backups and keep it as fullbackups.
am i correct?

Re: Incremental backup Doubt! [message #257015 is a reply to message #257011] Tue, 07 August 2007 07:08 Go to previous messageGo to next message
nani_ar
Messages: 58
Registered: March 2006
Member
hi navneeth,

u r right..we can merge the incremental backups with fullbackup and keep it as full backup in case of any recovery...

regards
nani
Re: Incremental backup Doubt! [message #260699 is a reply to message #256685] Mon, 20 August 2007 14:03 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: RMAN-06207: fix ... want to run "delete force archivelog.."
Next Topic: ORA-00280..........
Goto Forum:
  


Current Time: Sun Dec 11 02:34:36 CST 2016

Total time taken to generate the page: 0.10283 seconds