Current Position:Home > Duplicating a db to another host via rman

Duplicating a db to another host via rman

Update:10-11Source: network consolidation
Advertisement
I found a few documents on this topic, but didn't resolve my issue.
I am trying to restore an RMAN backup to a different host
(with same instance name, different path) from where the backup was taken.
And while running it gives the following error:
ORA-19505: failed to identify file "D:\ORACLE\BACKUP\TRACKER_20050920_FULL.S148P1"
ORA-27041: unable to open file
ORA-04002 unable to open file
O/S-Error : (OS 21) device not ready
Here D: drive is where I backup via rman ervery day.
If any of you had come across this problem and had a solution to this, could you please share it with me.
Thanks
P.S. I'm able to connect to catalog, target and auxiliary.
Charlie

The Best Answer

Advertisement
run on host B:
step 1. create auxiliary instance and connect to auxiliary instance in nomount mode
        SQL> connect sys/[email protected] as sysdba
        Connected to an idle instance.
        SQL>startup nomount pfile='C:\oracle\admin\tracker\scripts\initauxdb.ora'
run on host A:
step 2. RMAN> connect catalog rman/[email protected]
        RMAN> connect target sys/[email protected]
        RMAN> connect auxiliary sys/[email protected]
step 3. RMAN> run
        RMAN> {
        RMAN>    ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
        RMAN>    DUPLICATE TARGET DATABASE TO "auxdb"
        RMAN>    PFILE='D:\oracle\admin\tracker\scripts\initauxdb.ora';
        RMAN> }
        ORA-19505: failed to identify file "D:\ORACLE\BACKUP\TRACKER_20050920_FULL.S148P1"
        ORA-27041: unable to open file
        ORA-04002: unable to open file
        O/S-Error: (OS 21) device not readyAfter made whole backup of primary db to drive C on host A,
and redo step 2 and step 3.
The error messages as the same as step 3.
There's my backup script:
RMAN>run
RMAN>{
RMAN>  shutdown immediate;
RMAN>  startup mount;
RMAN>  ALLOCATE CHANNEL bck2disk1 DEVICE TYPE DISK;
RMAN>  BACKUP DATABASE FORMAT 'C:\oracle\backup\%d_%T_Full.S%sP%p';
RMAN>  sql "alter database open";
RMAN>  Release Channel bck2disk1;
RMAN>}Thanks a lot
Charlie
  • Duplicating a db to another host via rman Update:10-11

    I found a few documents on this topic, but didn't resolve my issue. I am trying to restore an RMAN backup to a different host (with same instance name, different path) from where the backup was taken. And while running it gives the following error: O

  • Duplicate database synchronize Update:11-30

    I have duplicated the database "prod" to "dup". $rman target sys/[email protected] auxiliary / RMAN> duplicate target database to DUP nofilenamecheck; My question is in order to synchronize the duplicate database from time to time, do I

  • Downstream capture Update:11-30

    Hi all! We have a non-rac production database and i've successfully done duplicating it to a asm rac using rman duplicate. Now, my plan is to make the rac instance as our report server and to configure it for advance replication using downstream capt

  • Duplicating DB with RMAN,DB mode:NOARCHIVE LOG? Update:11-30

    Hello, I want to get a duplicate database on a remote server machine with same file structure by using internet of VPN(virtual private network). My question is ... can we duplicate the database to remote server if the Database is in NOARCHIVELOG MODE

  • Duplicating by RMAN Update:11-30

    Hi, when duplicating by RMAN with this script : run { allocate auxiliary channel ch1 type disk; duplicate target database to w3k8b; exites with following errors : RMAN-03002: failure during compilation of command RMAN-03013: command type: recover RMA

  • Duplicating a Database with RMAN Update:11-30

    Hi, When Duplicating the database using RMAN, does it build the auxilary database from the existing rman backups of the target database or will it build direcly from the open / mount stage of the target dabase (where there is no concept of rman backu

  • RMAN-05001 - RMAN-03002 | Duplicating Database fails | Redo-Logs Update:11-30

    Sorry guys, first of all...my english is the worsteds you´ve ever seen... I got some kind of problem using rman duplicating a DB called cs2t into cs2b. Starting Duplicate Db at 17.05.2006 07:54:10 released channel: t1 released channel: t2 RMAN-00571:

  • Control file failed error while duplicating database using RMAN Update:10-11

    I am using oracle database 10g R2 and trying to make a clone of the source database orcl on the same machine but with different directory structure with the name of test. When i run the duplicate command to create test database, then following error

  • Control File error while duplicating Database through Rman Update:10-11

    Hi, Oracle Ver: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production Os:Win Xp I am trying to create a Standby through Rman.... I am using this Run Block to take backup of Primary Database....... run { allocate channel d1 type disk;

  • Duplicating a Database using RMAN Update:11-30

    Hi All, RMAN> run { 2> allocate auxiliary channel ch1 type disk; 3> duplicate target database to aux; 4> } using target database control file instead of recovery catalog allocated channel: ch1 channel ch1: sid=157 devtype=DISK Starting Duplica