Home » RDBMS Server » Backup & Recovery » Question on Backup archive log files (Oracle 11.1.0.7.0)
Question on Backup archive log files [message #518522] Thu, 04 August 2011 06:17 Go to next message
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

Re: Question on Backup archive log files [message #518524 is a reply to message #518522] Thu, 04 August 2011 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing.

Regards
Michel
Re: Question on Backup archive log files [message #518537 is a reply to message #518524] Thu, 04 August 2011 08:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing happens to the database.

Quote:
Then what about these 100 files which got removed?

They are removed.

Regards
Michel
Re: Question on Backup archive log files [message #518548 is a reply to message #518539] Thu, 04 August 2011 09:45 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Question on Backup archive log files [message #518555 is a reply to message #518550] Thu, 04 August 2011 10:12 Go to previous messageGo to next message
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 ?


Re: Question on Backup archive log files [message #518556 is a reply to message #518555] Thu, 04 August 2011 10:17 Go to previous messageGo to next message
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.
Re: Question on Backup archive log files [message #518557 is a reply to message #518556] Thu, 04 August 2011 10:20 Go to previous messageGo to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member

But i need to take those deleted files (from full backup) for next day incremental backup or what will happend in database ?

Re: Question on Backup archive log files [message #518559 is a reply to message #518557] Thu, 04 August 2011 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't need any previous archived log for incremental backup.

Regards
Michel
Re: Question on Backup archive log files [message #518560 is a reply to message #518559] Thu, 04 August 2011 11:07 Go to previous message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member


Thank you all for your answers.. Smile


You answers help me clear my questions.
Previous Topic: Restoring spfile and control file to a new location
Next Topic: RMAN trying to read from wrong backup?
Goto Forum:
  


Current Time: Tue Nov 30 15:34:39 CST 2021