OraFAQ Forum: Backup & Recovery » Incremental Vs Ar chive log backups

Home » RDBMS Server » Backup & Recovery » Incremental Vs Ar chive log backups (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Incremental Vs Ar chive log backups [message #606248]

Tue, 21 January 2014 09:57

akshara
Messages: 9
Registered: January 2014

Junior Member

Hello Everyone,

Can anyone please tell me the difference between incremental backup and archive log backups? Doesn't both backs up only modified data.If i take full backup once a week and daily archive log backups does it work? or do i need to take incremental backup daily?

Please do reply.

Thanks!!!

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #606249 is a reply to message #606248]

Tue, 21 January 2014 10:37

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Backup and Recovery Basics

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #606253 is a reply to message #606249]

Tue, 21 January 2014 12:49

akshara
Messages: 9
Registered: January 2014

Junior Member

Thanks Michel!!

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #606337 is a reply to message #606248]

Wed, 22 January 2014 08:21

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

Incremental (and full) backups are backups of data blocks from the database data files.
Archive log backups are backups of the archivelogs, which are themselves "backups" of the online redo logs.
All/both are needed to effect full recovery.

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #606742 is a reply to message #606337]

Tue, 28 January 2014 12:40

akshara
Messages: 9
Registered: January 2014

Junior Member

thanks EdStevens!!

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #606872 is a reply to message #606742]

Thu, 30 January 2014 05:28

mrkamranumer
Messages: 11
Registered: January 2014

Junior Member

hi dear all,

Yes i agree increment backups are needed on daily basis with incremental level=1 so that you can recover your database if required in case of failure
and i also recommend that you take backup through a schedule if possible cold backup daily to avoid any imbiguity

Thanks
Kamran Saeed

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #606874 is a reply to message #606872]

Thu, 30 January 2014 05:42

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Yes i agree increment backups are needed on daily basis with incremental level=1 so that you can recover your database if required in case of failure

Maybe they are needed, maybe not, you can't say that in a general way, it is not correct for anyone in any case.
You have no absolute need of incremental backup.

Quote:

i also recommend that you take backup through a schedule if possible cold backup daily to avoid any imbiguity

NO! cold backup is so Oracle version less than 7.
Do NOT stop your database; or only if you have a very good reason to do it (for instance for an OS upgrade).

What do you mean by "imbiguity"?

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #607251 is a reply to message #606874]

Tue, 04 February 2014 04:31

mrkamranumer
Messages: 11
Registered: January 2014

Junior Member

Dear what i wanted to tell you was , if your scenario is 9 to 5 and for a certain period of time you have availability of database idle time,
you must go for cold backup with archive mode enabled as it would be consistant

thats what i mean

Thanks

Report message to a moderator

Re: Incremental Vs Ar chive log backups [message #607255 is a reply to message #607251]

Tue, 04 February 2014 04:49

John Watson
Messages: 8803
Registered: January 2010
Location: Global Village

Senior Member

Kamran, many DBAs (including me) disagree you on this. Shutting down a database is seriously bad for performance. It takes time for the buffer cache and the shared pool to stabilize with contents that is suitable for the workload. Furthermore, the optimizer has self-learning capabilities (think of cardinality feedback, adaptive cursor sharing) that take time.
You lose all this with every restart.

Report message to a moderator

Previous Topic:	Backup Failed
Next Topic:	RMAN Duplicate Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 09:35:11 CDT 2023