RE: RMAN Restore Problem

From: QuijadaReina, Julio C <QuijadJC_at_alfredstate.edu>
Date: Wed, 10 Oct 2012 20:26:16 +0000
Message-ID: <BB94727CB52F9B4C9DC35642F805A81762F50D8A_at_MBX2.alfredstate.edu>

Have you tried RMAN's duplicate command? That may simplify things for you.

Julio Quijada
Alfred State College

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Venkat srinivasan Sent: Wednesday, October 10, 2012 4:02 PM To: oracle-l_at_freelists.org
Subject: RMAN Restore Problem

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.
3. run { set newname for datafile 1 to '/u01/zilt/system.dbf'; 6. set newname for all the datafiles.
4. 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 10 2012 - 22:26:16 CEST