Home » RDBMS Server » Backup & Recovery » Archive log before full backup
Archive log before full backup [message #292382] Tue, 08 January 2008 18:35 Go to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
One copy of full backup taken on Sunday. Can those previous archive log before Sunday still able to apply for recovery?

Re: Archive log before full backup [message #292387 is a reply to message #292382] Tue, 08 January 2008 19:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It depends on what you may want to apply them to? Archivelogs are meant to roll forward and therefore, you could potentially use them for an older backup or older datafiles.

Older archive logs could also be used for a standby database and/or streams configuration.
Re: Archive log before full backup [message #292393 is a reply to message #292387] Tue, 08 January 2008 20:39 Go to previous messageGo to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
Roll forward is what I understand.. I would like to confirm, can the archive log roll backward in any latest version as for my understanding, it can't.. correct me if it's not.

Thank you.
Re: Archive log before full backup [message #292394 is a reply to message #292393] Tue, 08 January 2008 21:01 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You are correct. They do not and can not provide the ability to rollback.
Re: Archive log before full backup [message #292515 is a reply to message #292382] Wed, 09 January 2008 01:59 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:

Can those previous archive log before Sunday still able to apply for recovery?


No way,it would be like restoring redo log files from backup.
That would result in loss of data.
Re: Archive log before full backup [message #293517 is a reply to message #292515] Sun, 13 January 2008 21:18 Go to previous messageGo to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
Hi, Thanks for all the reply.

That means, we only keep archive redo log that is AFTER the full backup. Once the full backup for the day is discard, then, archive redo log before the full backup will no more required.. thanks for the confirmation.





Re: Archive log before full backup [message #293624 is a reply to message #293517] Mon, 14 January 2008 05:16 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That's correct. If you needed to restore, you would restore the datafiles and then apply any archive/redo logs produced after the backup.

However, that being said, you never know when they may come in handy for a LogMiner function.

[Updated on: Mon, 14 January 2008 05:24]

Report message to a moderator

Previous Topic: Apply archive logs standby
Next Topic: How to startup Oracle without backups of archive log & control file
Goto Forum:
  


Current Time: Wed Dec 07 16:31:10 CST 2016

Total time taken to generate the page: 0.10843 seconds