OraFAQ Forum: Backup & Recovery » Question on Backup archive log files

Home » RDBMS Server » Backup & Recovery » Question on Backup archive log files (Oracle 11.1.0.7.0)

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

Question on Backup archive log files [message #518522]

Thu, 04 August 2011 06:17

Smith14
Messages: 38
Registered: July 2011
Location: India

Member

Hi,

I have one question to clarify regarding backup.

There is an incident that in production database 1000 archive log files generated.
From 1000 files, 100 archive log files have been removed.When i take incremental backup next day ,
what will happen in database?

Thank you

Report message to a moderator

Re: Question on Backup archive log files [message #518524 is a reply to message #518522]

Thu, 04 August 2011 06:21

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing.

Regards
Michel

Report message to a moderator

Re: Question on Backup archive log files [message #518537 is a reply to message #518524]

Thu, 04 August 2011 08:04

Smith14
Messages: 38
Registered: July 2011
Location: India

Member

What do you mean by Nothing ....michel

Then what about these 100 files which got removed?

[Updated on: Thu, 04 August 2011 08:26]

Report message to a moderator

Re: Question on Backup archive log files [message #518539 is a reply to message #518537]

Thu, 04 August 2011 08:41

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing happens to the database.

Quote:

Then what about these 100 files which got removed?

They are removed.

Regards
Michel

Report message to a moderator

Re: Question on Backup archive log files [message #518548 is a reply to message #518539]

Thu, 04 August 2011 09:45

Smith14
Messages: 38
Registered: July 2011
Location: India

Member

Then how to get the deleted files for backup ?

[Updated on: Thu, 04 August 2011 09:45]

Report message to a moderator

Re: Question on Backup archive log files [message #518550 is a reply to message #518548]

Thu, 04 August 2011 09:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Then how to get the deleted files for backup ?
a) restore from backups
b) take new Level 0 backup

Report message to a moderator

Re: Question on Backup archive log files [message #518555 is a reply to message #518550]

Thu, 04 August 2011 10:12

Smith14
Messages: 38
Registered: July 2011
Location: India

Member

Quote:

a) restore from backups
b) take new Level 0 backup

You mean if i take a new backup the deleted files wil be restored ?

Report message to a moderator

Re: Question on Backup archive log files [message #518556 is a reply to message #518555]

Thu, 04 August 2011 10:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>You mean if i take a new backup the deleted files wil be restored ?

if you take a new Level 0 backup, the deleted files are no longer needed to complete restore.

Report message to a moderator