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-00channel ch01: ORA-19870: error while restoring backup piece F:\RMAN\CTRLFILES\CT
RL-PROD-C-2267984545-20150826-00ORA-19505: failed to identify file "F:\RMAN\CTRLFILES\CTRL-PROD-C-2267984545-2015
0826-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 ?