Home » RDBMS Server » Backup & Recovery » Recovery after incremental backup (11g )
Recovery after incremental backup [message #661859] Tue, 04 April 2017 09:45 Go to next message
rohitdba
Messages: 14
Registered: March 2017
Junior Member
Hi ,
I want to know that if we are taking incremental backup of daily basis and if the backup of Wednesday fail due to some reason and on Thursday i want to restore the database till now, so will data will it be restore with all the available data or there is loss of data.(archive log is enable) ?

Thanks
Rohit Parsai
Re: Recovery after incremental backup [message #661860 is a reply to message #661859] Tue, 04 April 2017 10:17 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
If done properly, then no loss of data (assuming all REDO from last good backup is available).
Re: Recovery after incremental backup [message #661866 is a reply to message #661860] Tue, 04 April 2017 12:44 Go to previous messageGo to next message
rohitdba
Messages: 14
Registered: March 2017
Junior Member
Thanks for the reply can you please tell me what kind of recovery should perform and will redo apply to them automatically ?
Re: Recovery after incremental backup [message #661867 is a reply to message #661866] Tue, 04 April 2017 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is only one kind of recovery: RECOVER DATABASE [UNTIL ...].

Quote:
will redo apply to them automatically ?
Yes, if they are in the place it thinks they are.

Re: Recovery after incremental backup [message #661881 is a reply to message #661866] Wed, 05 April 2017 02:51 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
Is your AUTOBACKUP of control file set to ON? If so:
RMAN> restore database;
RMAN> recover database;
Re: Recovery after incremental backup [message #661882 is a reply to message #661881] Wed, 05 April 2017 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Only if he uses RMAN to backup. Wink

Re: Recovery after incremental backup [message #661883 is a reply to message #661881] Wed, 05 April 2017 03:21 Go to previous messageGo to next message
rohitdba
Messages: 14
Registered: March 2017
Junior Member
Yes i do have auto backup configured
Re: Recovery after incremental backup [message #661884 is a reply to message #661882] Wed, 05 April 2017 03:22 Go to previous messageGo to next message
rohitdba
Messages: 14
Registered: March 2017
Junior Member
Yes michael i am using Rman utility for backup.

Re: Recovery after incremental backup [message #661885 is a reply to message #661884] Wed, 05 April 2017 03:28 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
Michel Cadot wrote on Tue, 04 April 2017 18:47

There is only one kind of recovery: RECOVER DATABASE [UNTIL ...].
But you could try it on a test system first Smile

[Updated on: Wed, 05 April 2017 03:29]

Report message to a moderator

Re: Recovery after incremental backup [message #661887 is a reply to message #661859] Wed, 05 April 2017 07:10 Go to previous message
EdStevens
Messages: 863
Registered: September 2013
Senior Member
rohitdba wrote on Tue, 04 April 2017 09:45
Hi ,
I want to know that if we are taking incremental backup of daily basis and if the backup of Wednesday fail due to some reason and on Thursday i want to restore the database till now, so will data will it be restore with all the available data or there is loss of data.(archive log is enable) ?

Thanks
Rohit Parsai
Think!
How does recovering when your last level 1 is one day old differ from recovering when your last level 1 is three days old? Three months old?

Rman doesn't care how old the last good level 1 backup is. When you recover, it will start with whatever level 1 backups are available and applicable. After those are processed it will continue with the archive logs.
Previous Topic: Create backup
Next Topic: Oracle Backup with RMAN take a long time
Goto Forum:
  


Current Time: Sat Dec 16 15:27:06 CST 2017

Total time taken to generate the page: 0.09597 seconds