Home » RDBMS Server » Backup & Recovery » Archivelog backup and Incremental backup (Oracle,19.0.0.0.0, CentOS Linux release 7.6.1810 (Core))
Archivelog backup and Incremental backup [message #685318] Tue, 07 December 2021 22:57 Go to next message
BalajiDBA
Messages: 132
Registered: October 2018
Location: India
Senior Member
Hi,

Could someone please explain me why we take archive log backup when we have incremental backup everyday using RMAN in Oracle.

Regards,
Balaji
Re: Archivelog backup and Incremental backup [message #685320 is a reply to message #685318] Wed, 08 December 2021 06:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10703
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quoting the doc.

Quote:
To back up the database while it is open, or to be able to perform complete or point-in-time media recovery, you must enable the archiving of redo log files.
Information in the redo log files are "archived" into the archived log files. Kind of transactional log.
So, as long as you need an online backup , you need the archived logs too.
Quote:

A database backup, together with online and archived redo log files, guarantees that you can recover all committed transactions in the event of an operating system or disk failure.

If you keep an archived log, you can use a backup taken while the database is open and in normal system use.

You can keep a standby database current with its original database by continuously applying the original archived redo logs to the standby.


[Updated on: Wed, 08 December 2021 06:29]

Report message to a moderator

Re: Archivelog backup and Incremental backup [message #685321 is a reply to message #685320] Wed, 08 December 2021 06:49 Go to previous messageGo to next message
BalajiDBA
Messages: 132
Registered: October 2018
Location: India
Senior Member
Thank you for your explanations.

Regards,
Balaji
Re: Archivelog backup and Incremental backup [message #685322 is a reply to message #685321] Wed, 08 December 2021 07:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10703
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not mine, per se.
It is all in the documentation.
Re: Archivelog backup and Incremental backup [message #685323 is a reply to message #685322] Wed, 08 December 2021 07:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mahesh Rajendran wrote on Wed, 08 December 2021 14:30
Not mine, per se.
It is all in the documentation.
/forum/fa/449/0/
Re: Archivelog backup and Incremental backup [message #685324 is a reply to message #685318] Wed, 08 December 2021 09:02 Go to previous messageGo to next message
EdStevens
Messages: 1375
Registered: September 2013
Senior Member
BalajiDBA wrote on Tue, 07 December 2021 22:57
Hi,

Could someone please explain me why we take archive log backup when we have incremental backup everyday using RMAN in Oracle.

Regards,
Balaji
OK, suppose you take your incremental backup at 01:00 (one o'clock in the morning). Now suppose your database crashes at 09:00 (nine o'clock in the morning). How are you going to recover the transactions that occurred between 01:00 and 09:00? Your backup from 01:00 isn't going to reflect that activity.

And to add to it, the online backup isn't consistent to a given point-in-time, SCN. Data files are being modified even as they are being backed up. Suppose the backup process starts reading data file #1. Let's say it reads the first 50 blocks into a buffer, then starts writing them to the backup piece. But even as it is writing to the backup, some of those blocks get modified by DML going on in some other process. Those changes will not be in the backup, but they will be in the online redo logs and eventually written to the archive logs.

So, you tell me, why do we have archivelogs? Now, if they are needed for database recovery, where will you be if the archivelogs themselves are lost? Now, why do you suppose we might want backups of them as well?
Re: Archivelog backup and Incremental backup [message #685326 is a reply to message #685324] Wed, 08 December 2021 22:42 Go to previous messageGo to next message
BalajiDBA
Messages: 132
Registered: October 2018
Location: India
Senior Member
Quote:
So, you tell me, why do we have archivelogs? Now, if they are needed for database recovery, where will you be if the archivelogs themselves are lost? Now, why do you suppose we might want backups of them as well?
We can't restore the database to specific time if we don't have archive logs and their backup.

Regards,
Balaji
Re: Archivelog backup and Incremental backup [message #685332 is a reply to message #685326] Thu, 09 December 2021 08:51 Go to previous messageGo to next message
EdStevens
Messages: 1375
Registered: September 2013
Senior Member
BalajiDBA wrote on Wed, 08 December 2021 22:42
Quote:
So, you tell me, why do we have archivelogs? Now, if they are needed for database recovery, where will you be if the archivelogs themselves are lost? Now, why do you suppose we might want backups of them as well?
We can't restore the database to specific time if we don't have archive logs and their backup.

Regards,
Balaji
And there you have the answer to your original question.
Re: Archivelog backup and Incremental backup [message #685336 is a reply to message #685332] Fri, 10 December 2021 03:30 Go to previous message
BalajiDBA
Messages: 132
Registered: October 2018
Location: India
Senior Member
Thank you Smile
Previous Topic: Moving an oraDB10g
Next Topic: rman error
Goto Forum:
  


Current Time: Wed Aug 10 02:38:26 CDT 2022