Re: RMAN Restore Problem

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Thu, 11 Oct 2012 15:36:47 +0800
Message-ID: <CAMNBsZuUuhuA1oYOBhULd_jJUD5_po0AcuGG05FzbtH0f3L_YA_at_mail.gmail.com>

your command is "set newname for datafile 1 to '/u01/zilt/system.dbf';" I presume that you want to restore to filesystem and *not* to the ASM DG. Ensure that the SET NEWNAME *and* RESTORE DATABASE are in the *same* run block -- such as

run
{
set newname for datafile 1 to '/u01/zilt/system.dbf'; set newname for datafile 2 ...
set ...
...
...
restore database;
}

Hemant K Chitale

On Thu, Oct 11, 2012 at 4:02 AM, Venkat srinivasan < srini.venkat.raman_at_gmail.com> wrote:

> Hi Gurus,
>
> I would like to clone the 10G Db from Rman backup.Currently we are
> using asm and would like to clone the db to filesystem. I have taken
> the rman backup set and moved to the filesystem.steps below followed.
>
> Target machine.
>
> 1. startup nomount
> 2. restore the control file from the rman backup
> 3. mount the db
> 4. catalog backuppiece to new location.
> 5. run {
> set newname for datafile 1 to '/u01/zilt/system.dbf';
> 6. set newname for all the datafiles.
> 7. restore database.
>
> Its trying to restore in to the ASM disk group. I am getting the below
> error. Any idea what i have missed.
>
> restoring datafile 00003 to +DG_ZILTEST/zilt/datafile/sysaux.261.786493797
> channel ORA_DISK_1: reading from backup piece
> /newdisk/backup/zilt_rmanbkp/b_2cnmuc2k_1_1
> ORA-19870: error reading backup piece
> /u01/zilt_dump/rman_zilt/b_2cnmuc2k_1_1
> ORA-19504: failed to create file "+DG_ZILTEST"
> ORA-17502: ksfdcre:4 Failed to create file +DG_ZILTEST
> ORA-15001: diskgroup "DG_ZILTEST" does not exist or is not mounted
> ORA-15077: could not locate ASM instance serving a req
>
> Thanks in advance.
> Venkat
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Hemant K Chitale
http://hemantoracledba.blogspot.com


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 11 2012 - 09:36:47 CEST