Home » RDBMS Server » Backup & Recovery » Restore from RMAN full backup
Restore from RMAN full backup [message #610363] Wed, 19 March 2014 10:08 Go to next message
patdev
Messages: 54
Registered: August 2008
Member
Hi ,



please guide me for restoring Oracle 10.2.0.5 database from RMAN full backup?



Please help!

full backup is from 8th and I have archive log from 8th to 12 (14:55).

Can i use this

RMAN:> shutdown immediate;
RMAN:> startup mount;
RMAN> run
{
set until time "to_date('2014-03-12:15:00:00', 'yyyy-mm-dd:hh24:mi:ss')";
restore database;
recover database; }

will it take RMN full backup and log after that till march 12 (14:55)


Please guide

thank
Re: Restore from RMAN full backup [message #610367 is a reply to message #610363] Wed, 19 March 2014 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It will not take anything after the mentioned until time (15:00) but it will take a full backup made at 14:55.

Re: Restore from RMAN full backup [message #610368 is a reply to message #610367] Wed, 19 March 2014 10:38 Go to previous messageGo to next message
patdev
Messages: 54
Registered: August 2008
Member
the full backup was mad on 8th, will it take archive log was done on march 12 14:55?
Re: Restore from RMAN full backup [message #610370 is a reply to message #610368] Wed, 19 March 2014 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes, it needs it to recover to 15:00.

Re: Restore from RMAN full backup [message #610371 is a reply to message #610370] Wed, 19 March 2014 10:42 Go to previous message
patdev
Messages: 54
Registered: August 2008
Member
ok thanks. Just wanted to confirm that RMAN script is correct!

great help thanks.
Previous Topic: Estimating storage space for backing up
Next Topic: How to change the default location of an RMAN backup in 10g
Goto Forum:
  


Current Time: Mon Sep 22 05:39:20 CDT 2014

Total time taken to generate the page: 0.15718 seconds