OraFAQ Forum: Backup & Recovery » Archive log before full backup

Home » RDBMS Server » Backup & Recovery » Archive log before full backup

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

Archive log before full backup [message #292382]

Tue, 08 January 2008 18:35

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?

Report message to a moderator

Re: Archive log before full backup [message #292387 is a reply to message #292382]

Tue, 08 January 2008 19:45

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.

Report message to a moderator

Re: Archive log before full backup [message #292393 is a reply to message #292387]

Tue, 08 January 2008 20:39

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.

Report message to a moderator

Re: Archive log before full backup [message #292394 is a reply to message #292393]

Tue, 08 January 2008 21:01

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You are correct. They do not and can not provide the ability to rollback.

Report message to a moderator

Re: Archive log before full backup [message #292515 is a reply to message #292382]

Wed, 09 January 2008 01:59

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.

Report message to a moderator

Re: Archive log before full backup [message #293517 is a reply to message #292515]

Sun, 13 January 2008 21:18

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.

Report message to a moderator

Re: Archive log before full backup [message #293624 is a reply to message #293517]

Mon, 14 January 2008 05:16

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:11:55 CST 2024