Skip to Main Content

Database Software

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!

RMAN duplicate with specific backup location

DPRMAug 27 2015 — edited Sep 1 2015

Hello,

I explain here my architecture :

- Production Oracle 11.2.0.4 server : prod-db with instance name PROD with RMAN backups on drive F:

- Test Oracle 11.2.0.4 server : test-db with instance name TEST with RMAN backups on drive F: and production drive backup available on drive G:

- Client name: client

My goal is to duplicate the production server to the test server instance and I can't achieve this. The connection is from the client side.

I do it like this :

- startup nomount the TEST

- On the client run the following "rman target sys/pass@PROD auxiliary sys/pass@TEST"

Then in RMAN I run the following :

RUN

{

        ALLOCATE AUXILIARY CHANNEL ch01 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL ch02 DEVICE TYPE DISK;

        DUPLICATE DATABASE TO TEST BACKUP LOCATION 'G:\RMAN';

}

RMAN does not see my "BACKUP LOCATION" command because he tries to duplicate from the F: drive and doesn't find the backup files.

I have thing like this :

channel ch01: reading from backup piece F:\RMAN\CTRLFILES\CTRL-PROD-C-2267984545-20150826-00

channel ch01: ORA-19870: error while restoring backup piece F:\RMAN\CTRLFILES\CTRL-PROD-C-2267984545-20150826-00

ORA-19505: failed to identify file "F:\RMAN\CTRLFILES\CTRL-PROD-C-2267984545-20150826-00"

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

I tried simple quote, double quote, almost everything and RMAN always look for the backup in the F: drive. Can you help me to use the G: drive ?

This post has been answered by Shivananda Rao on Sep 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2015
Added on Aug 27 2015
21 comments
13,225 views