Re: restore using rman

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sat, 14 Feb 2009 04:30:14 -0800 (PST)
Message-ID: <49224265-ad24-43d1-a805-4e2c0506ca3b_at_f29g2000vbf.googlegroups.com>

On Feb 14, 1:31 am, Anthony <akkha1..._at_gmail.com> wrote:
> Hi,
>
> I don't know if following is possible:
>
>   1.  restore all datafiles from a rman backup
>   2.  restore to the SAME server but to a different location
>   3. 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?

What oracle version exactly?

Certainly this type of scenario is possible on a unix/linux box ... are you sure your syntax is correct?

Perhaps windows os is imposing some limitation? Received on Sat Feb 14 2009 - 06:30:14 CST