Home » RDBMS Server » Backup & Recovery » Incremental Vs Ar chive log backups (Oracle 10g)
Incremental Vs Ar chive log backups [message #606248] Tue, 21 January 2014 09:57 Go to next message
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!!!
Re: Incremental Vs Ar chive log backups [message #606249 is a reply to message #606248] Tue, 21 January 2014 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Backup and Recovery Basics

Re: Incremental Vs Ar chive log backups [message #606253 is a reply to message #606249] Tue, 21 January 2014 12:49 Go to previous messageGo to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
Thanks Michel!!
Re: Incremental Vs Ar chive log backups [message #606337 is a reply to message #606248] Wed, 22 January 2014 08:21 Go to previous messageGo to next message
EdStevens
Messages: 349
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.
Re: Incremental Vs Ar chive log backups [message #606742 is a reply to message #606337] Tue, 28 January 2014 12:40 Go to previous messageGo to next message
akshara
Messages: 9
Registered: January 2014
Junior Member
thanks EdStevens!!
Re: Incremental Vs Ar chive log backups [message #606872 is a reply to message #606742] Thu, 30 January 2014 05:28 Go to previous messageGo to next message
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
Re: Incremental Vs Ar chive log backups [message #606874 is a reply to message #606872] Thu, 30 January 2014 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
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"?

Re: Incremental Vs Ar chive log backups [message #607251 is a reply to message #606874] Tue, 04 February 2014 04:31 Go to previous messageGo to next message
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
Re: Incremental Vs Ar chive log backups [message #607255 is a reply to message #607251] Tue, 04 February 2014 04:49 Go to previous message
John Watson
Messages: 4859
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.
Previous Topic: Backup Failed
Next Topic: RMAN Duplicate Issue
Goto Forum:
  


Current Time: Fri Dec 19 21:53:31 CST 2014

Total time taken to generate the page: 0.06335 seconds