restore using rman
Date: Fri, 13 Feb 2009 22:31:02 -0800 (PST)
Message-ID: <a8492b44-78f7-4929-a6e0-a35c10d6f44e_at_w1g2000prm.googlegroups.com>
Hi,
I don't know if following is possible:
- restore all datafiles from a rman backup
- restore to the SAME server but to a different location
- during the restore, the existing production database is up and open all the time
The reason is because I got a request to restore a 200GB database. But I do not have a spare machine now to do a duplicate/cloning. I am not allowed to create another instance on the same box for the cloning. Is it possible at all?
I tried a small database and it works fine but when I use the production, I got the error:
un {
allocate channel ch1 type 'sbt_tape'
PARMS="BLKSIZE=262144,ENV=(CvClientName=svr-gis-db-
p,CvInstanceName=Instance001)
";
set newname for datafile 'G:\ORACLE\ORADATA\GPRODP\DCSE_DATA.D03.DBF'
to 'I:\oracle\backup\20091003\DCSE_DATA.D03.DBF';
restore datafile 21
until time = "TO_DATE('10/03/2008 05:00:00','MM/DD/YYYY
HH24:MI:SS')" ;
release channel ch1;
}
The database is in open mode.
My intention is to restore the data file to a different location,
leaving the production running and intact.
I did a redirect and do not execute the switch command. But I got the
error:
creating datafile fno=21 name=I:\ORACLE\BACKUP
\20091003\DCSE_DATA.D03.DBF
released channel: ch1
RMAN-00571:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571:
RMAN-03002: failure of restore command at 02/10/2009 17:53:44 ORA-01182: cannot create database file 21 - file is in use or recovery ORA-01110: data file 21: 'G:\ORACLE\ORADATA\GPRODP\DCSE_DATA.D03.DBF'
Any suggestion? Received on Sat Feb 14 2009 - 00:31:02 CST