Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Restore Database with RMAN in another HOST

Cac47Feb 23 2010 — edited Feb 23 2010
Hello 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2010
Added on Feb 23 2010
21 comments
7,473 views