OraFAQ Forum: Backup & Recovery » Command for restoring from Incremental Backup..!

Home » RDBMS Server » Backup & Recovery » Command for restoring from Incremental Backup..!

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

Command for restoring from Incremental Backup..! [message #579140]

Fri, 08 March 2013 03:10

raja_dba
Messages: 33
Registered: November 2012
Location: India

Member

Could I be helped with this scenario?

Every Sunday in the month - Full Backup

RMAN > BACKUP DATABASE;

Rest of the days - Incremental Level 1 Backup.

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE

Day of Month Backup Taken Backup Contents

1st Full Backup All files as of the 1st - Sunday

2nd Incremental #1 Files updates between the 1st and 2nd - Monday
3rd Incremental #2 Files updates between the 2nd and 3rd - Tuesday
4th Incremental #3 Files updates between the 3rd and 4th - Wednesday
5th Incremental #4 Files updates between the 4th and 5th - Thrusday
6th Incremental #6 Files updates between the 5th and 6th - Friday
7th Incremental #7 Files updates between the 6th and 7th - Saturday

8th Full Backup #8 Files updates from 1st,2nd to 7th - Sunday

9th Incremental #9 Files updates between the 8th and 9th _ Monday
10th Incremental #10 Files updates between the 9th and 10th - Tuesday
11th Incremental #11 Files updates between the 10th and 11th - Wednesday
12th Incremental #12 Files updates between the 11th and 12th - Thrusday
13th Incremental #13 Files updates between the 12th and 13th - Friday
14th Incremental #14 Files updates between the 13th and 14th - Saturday

15th Full Backup CRASHES - NOT COMPLETED - Sunday

I would need to restore now from #8 ( full backup ) and #9 to #14 ( incremental backup )

Can anyone please tell me the "restore command" to achieve the output?

Thanks,
Raja

Report message to a moderator

Re: Command for restoring from Incremental Backup..! [message #579142 is a reply to message #579140]

Fri, 08 March 2013 03:19

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

In mount mode, you need to use RMAN's RESTORE command and RECOVER command with an UNTIL clause, specifying the time to which you wish to take the database:

Code: [Select all] [Show/ hide]

restore database until time '.....';
recover database until time '....';

Report message to a moderator

Re: Command for restoring from Incremental Backup..! [message #579146 is a reply to message #579142]

Fri, 08 March 2013 03:33

raja_dba
Messages: 33
Registered: November 2012
Location: India

Member

John,

restore database
until time "to_date('Mar 01 2013 00:00:01','Mon DD YYYY HH24:MI:SS')";
recover database
until time "to_date('Mar 01 2013 00:00:01','Mon DD YYYY HH24:MI:SS')";

When I supply the time, does it takes the full backup "AND ALSO" the incremental backup?

Report message to a moderator

Re: Command for restoring from Incremental Backup..! [message #579148 is a reply to message #579146]

Fri, 08 March 2013 03:38

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Trust me. I'm a DBA.

(and use [code] tags).

Report message to a moderator

Re: Command for restoring from Incremental Backup..! [message #579151 is a reply to message #579148]

Fri, 08 March 2013 03:43

raja_dba
Messages: 33
Registered: November 2012
Location: India

Member

John,

Was not trying to mean anything, just wanted to make sure I have conveyed properly so I could get the resultant. Definitely next time using the [code] format. Thank you for your time.

Report message to a moderator

Re: Command for restoring from Incremental Backup..! [message #579157 is a reply to message #579151]

Fri, 08 March 2013 03:55

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

Senior Member
Account Moderator

The principle is that RMAN knows what it has to do, you don't need to tell it how, just what.

Regards
Michel

Report message to a moderator

Re: Command for restoring from Incremental Backup..! [message #579168 is a reply to message #579157]

Fri, 08 March 2013 04:13

raja_dba
Messages: 33
Registered: November 2012
Location: India

Member

Incremental backups also back up only the changed data, but they only back up the data that has changed since the last backup -- be it a full or incremental backup. They are sometimes called "differential incremental backups," while differential backups are sometimes called "cumulative incremental backups." Confused though RMAN concepts seems to be simple.

Report message to a moderator

Previous Topic:	scn is 0
Next Topic:	Databae Cloning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 08:40:55 CDT 2025