Home » RDBMS Server » Backup & Recovery » restore database
restore database [message #190059] Tue, 29 August 2006 03:12 Go to next message
ramkrishnasg
Messages: 1
Registered: August 2006
Location: pune
Junior Member
hi i am ramkrishna of the new member of orafaq, my problem is that i hv handle the 10g database on redhat 7.2,
my question is that i hv given full backup using rman in disk ,if this backup is shifted in tape and delete the disk backup and restore the backup on tape to disk it is possible? how? pls wxplain me.
Re: restore database [message #190124 is a reply to message #190059] Tue, 29 August 2006 05:45 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
See brother you can restore database from place where it was backedup
so first of all in your case... copy your tape backup at the place on hard disk were you were taking backup by rman

b'coz rman maintain catlog and when you give command on rman to restore backup it will try to restore from where it was backed up... in your case it was backedup on disk. so put your tape backup on hard disk where rman copy backup.

cheers...!
Sunilkumar

[Updated on: Tue, 29 August 2006 05:46]

Report message to a moderator

Re: restore database [message #190127 is a reply to message #190059] Tue, 29 August 2006 05:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Why was this created as a poll ??
Re: restore database [message #190135 is a reply to message #190059] Tue, 29 August 2006 06:20 Go to previous message
ramkrishna_gosavi
Messages: 15
Registered: June 2006
Location: pune
Junior Member
thanks but i hv use following script

conect target /
startup nomount;
set dbid 09309030;
run
{
allocate chanel c1 device type disk;
restore controlfile autobackup;
alter database mount;
restore database;
recover database;
}
Previous Topic: RMAN ERROR: ORA-00209
Next Topic: intersting error
Goto Forum:
  


Current Time: Fri Dec 09 02:12:32 CST 2016

Total time taken to generate the page: 0.09931 seconds