OraFAQ Forum: Backup & Recovery » Recovery after incremental backup

Home » RDBMS Server » Backup & Recovery » Recovery after incremental backup (11g )

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

Recovery after incremental backup [message #661859]

Tue, 04 April 2017 09:45

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

Report message to a moderator

Re: Recovery after incremental backup [message #661860 is a reply to message #661859]

Tue, 04 April 2017 10:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If done properly, then no loss of data (assuming all REDO from last good backup is available).

Report message to a moderator

Re: Recovery after incremental backup [message #661866 is a reply to message #661860]

Tue, 04 April 2017 12:44

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 ?

Report message to a moderator

Re: Recovery after incremental backup [message #661867 is a reply to message #661866]

Tue, 04 April 2017 12:47

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

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.

Report message to a moderator

Re: Recovery after incremental backup [message #661881 is a reply to message #661866]

Wed, 05 April 2017 02:51

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Is your AUTOBACKUP of control file set to ON? If so:

RMAN> restore database;
RMAN> recover database;

Report message to a moderator

Re: Recovery after incremental backup [message #661882 is a reply to message #661881]

Wed, 05 April 2017 03:15

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

Senior Member
Account Moderator

Only if he uses RMAN to backup. Wink

Report message to a moderator

Re: Recovery after incremental backup [message #661883 is a reply to message #661881]

Wed, 05 April 2017 03:21

rohitdba
Messages: 14
Registered: March 2017

Junior Member

Yes i do have auto backup configured

Report message to a moderator

Re: Recovery after incremental backup [message #661884 is a reply to message #661882]

Wed, 05 April 2017 03:22

rohitdba
Messages: 14
Registered: March 2017

Junior Member

Yes michael i am using Rman utility for backup.

Report message to a moderator

Re: Recovery after incremental backup [message #661885 is a reply to message #661884]

Wed, 05 April 2017 03:28

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

EdStevens
Messages: 1376
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.

Report message to a moderator

Previous Topic:	Create backup
Next Topic:	Oracle Backup with RMAN take a long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 00:53:52 CST 2025