restore database [message #190059] |
Tue, 29 August 2006 03:12 |
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 |
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 #190135 is a reply to message #190059] |
Tue, 29 August 2006 06:20 |
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;
}
|
|
|