How Duplicate a target database Into new Host with RMAN?
Cac47Feb 23 2010 — edited Feb 23 2010Dear DBA's
I need to Recover Some Data I just have the RMAN Backup. (Dump from Export not Valid)
So I Copy the RMAN Backup files into New host.
Shall I keep the same file system names and init names or can I duplicate Renaming Instance Name?
So I have my backup Files in New Host:
[oracle@srvldbp12 ORA_BACKUP_CPQ]$ ls -lrt
total 720016
-rw-r----- 1 oracle oinstall 17920 Feb 23 09:25 CPQ_180220100218_full_29l69gvb_1_1
-rw-r----- 1 oracle oinstall 180224 Feb 23 09:25 CPQ_180220100218_full_28l69gv9_1_1
-rw-r----- 1 oracle oinstall 728825856 Feb 23 09:25 CPQ_180220100218_full_27l69goi_1_1
-rw-r----- 1 oracle oinstall 7536640 Feb 23 09:32 cf_c-3474491432-20100218-00_CPQ
[oracle@srvldbp12 ORA_BACKUP_CPQ]$
To connect I do :
[oracle@srvldbp12 index]$ rman target sys/password@targetdb
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Feb 23 09:41:15 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: CPQ (DBID=3474491432)
RMAN> connect auxiliary /
connected to auxiliary database: CPQR (not mounted)
RMAN>
When I run run
{
allocate auxiliary channel ch1 type disk;
set newname for datafile 1 to '/u02/oradata/CPQR/system/system01.dbf';
set newname for datafile 2 to '/u02/oradata/CPQR/system/undotbs1.dbf';
set newname for datafile 3 to '/u02/oradata/CPQR/system/sysaux01.dbf';
set newname for datafile 4 to '/u01/oradata/CPQR/data/users01.dbf';
set newname for datafile 5 to '/u01/oradata/CPQR/data/cogix_data_01.dbf';
set newname for datafile 6 to '/u03/oradata/CPQR/index/cogix_index_01.dbf';
set newname for datafile 7 to '/u01/oradata/CPQR/data/surveytool_data_01.dbf';
set newname for datafile 8 to '/u03/oradata/CPQR/index/surveytool_index_01.dbf';
set newname for datafile 9 to '/u01/oradata/CPQR/data/tools_01.dbf';
set newname for tempfile 1 to '/u02/oradata/CPQR/system/temp01.dbf';
duplicate target database to CPQR
PFILE = $ORACLE_HOME/dbs/initCPQR.ora
LOGFILE group 1 (
'/u01/oradata/CPQR/rdo/redo01.log',
'/u01/oradata/CPQR/rdo/redo04.log') size 20M,
group 2 (
'/u01/oradata/CPQR/rdo/redo02.log',
'/u01/oradata/CPQR/rdo/redo05.log') size 20M,
group 3 (
'/u01/oradata/CPQR/rdo/redo03.log',
'/u01/oradata/CPQR/rdo/redo06.log') size 10M;
}
I get
channel ch1: reading from backup piece /backup/ORA_BACKUP_CPQ/CPQ_190220100219_full_2il6c54i_1_1
ORA-19870: error reading backup piece /backup/ORA_BACKUP_CPQ/CPQ_190220100219_full_2il6c54i_1_1
ORA-19505: failed to identify file "/backup/ORA_BACKUP_CPQ/CPQ_190220100219_full_2il6c54i_1_1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u01/oradata/CPQR/data/users01.dbf
restoring datafile 00009 to /u01/oradata/CPQR/data/tools_01.dbf
channel ch1: reading from backup piece /backup/ORA_BACKUP_CPQ/CPQ_190220100219_full_2jl6c5bk_1_1
ORA-19870: error reading backup piece /backup/ORA_BACKUP_CPQ/CPQ_190220100219_full_2jl6c5bk_1_1
ORA-19505: failed to identify file "/backup/ORA_BACKUP_CPQ/CPQ_190220100219_full_2jl6c5bk_1_1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/23/2010 09:53:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN>
What's Wrong?
Shall i use Same File System name ?
Shall I su same Instance Name?
Thxs