Home » RDBMS Server » Backup & Recovery » Command for restoring from Incremental Backup..!
Command for restoring from Incremental Backup..! [message #579140] Fri, 08 March 2013 03:10 Go to next message
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













Re: Command for restoring from Incremental Backup..! [message #579142 is a reply to message #579140] Fri, 08 March 2013 03:19 Go to previous messageGo to next message
John Watson
Messages: 8922
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:
restore database until time '.....';
recover database until time '....';
Re: Command for restoring from Incremental Backup..! [message #579146 is a reply to message #579142] Fri, 08 March 2013 03:33 Go to previous messageGo to next message
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?



Re: Command for restoring from Incremental Backup..! [message #579148 is a reply to message #579146] Fri, 08 March 2013 03:38 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Trust me. I'm a DBA.

(and use [code] tags).
Re: Command for restoring from Incremental Backup..! [message #579151 is a reply to message #579148] Fri, 08 March 2013 03:43 Go to previous messageGo to next message
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.

Re: Command for restoring from Incremental Backup..! [message #579157 is a reply to message #579151] Fri, 08 March 2013 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Command for restoring from Incremental Backup..! [message #579168 is a reply to message #579157] Fri, 08 March 2013 04:13 Go to previous message
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.
Previous Topic: scn is 0
Next Topic: Databae Cloning
Goto Forum:
  


Current Time: Fri Mar 29 01:54:50 CDT 2024