Restore Database with RMAN in another HOST
Cac47Feb 23 2010 — edited Feb 23 2010Hello DBA's
I need to restore a Database Into Another Server to Retrieve Some data from tables delete accidentraly by Users.
I'm having some pb to restore a Database into another Host, quite probable a issue with the script.
just FYI RH5 on Oracle 10.2.0.4 but the issue is surely the Script.
So I've Restore the RMAn Backup files into another 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]$
these Backups are from "CPQ" database and I would like to restore Into This Server srvldbp12 but Renaming database CPQ into CPQR
So
I've Created all File System
Created the initCPQR.ora with all parameters "CPQR" instead "CPQ"
I Startup nomount the database "CPQR"
Then I Start RMAN a Follows :
[oracle@srvldbp12 index]$ rman target sys/l3dz3p1@sncpq
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Feb 23 09:52:35 2010
connected to target database: CPQ (DBID=3474491432)
RMAN> connect auxiliary /
connected to auxiliary database: CPQR (not mounted)
RMAN>
Than i run Script Below:
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;
}
AND I get all This Errors Messages !!!!!
channel ch1: reading from backup piece /backup/ORA_BACKUP_CPQ/CPQ_220220100222_full_2rl6ltgh_1_1
ORA-19870: error reading backup piece /backup/ORA_BACKUP_CPQ/CPQ_220220100222_full_2rl6ltgh_1_1
ORA-19505: failed to identify file "/backup/ORA_BACKUP_CPQ/CPQ_220220100222_full_2rl6ltgh_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_220220100222_full_2sl6ltko_1_1
ORA-19870: error reading backup piece /backup/ORA_BACKUP_CPQ/CPQ_220220100222_full_2sl6ltko_1_1
ORA-19505: failed to identify file "/backup/ORA_BACKUP_CPQ/CPQ_220220100222_full_2sl6ltko_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
Can you Help me How to Correct this Script ?
What is wrong on this Script ?
Can you Help me with this Issue?
Txs in advance.