Database Software

Trying to duplicate database in order to upgrade to 11.2 and migrate from Windows to Solaris with minimal downtime using GoldenGate. The source database is 11.1.0.7 on Windows 2003 x64 in a 2 node RAC. The auxiliary database is 11.1.0.7 on a single Windows 2003 x64 server. The steps to get to where the error occurred are:

1. Created auxiliary instance on remote node. oradim and listener creation.

2. Copied password file from target to remote node and put in %ORACLE_HOME%\database and %ORACLE_HOME%\dbs directory.

3. Created PFILE in %ORACLE_HOME%\database and copied to %ORACLE_HOME%\dbs just in case.

db_name='UTILAX'
instance_name=UTILAX
diagnostic_dest='D:\oracle\admin\utilax'
db_file_name_convert=('+DATA/util','D:\oracle\oradata\utilax')
log_file_name_convert=('+DATA/util','D:\oracle\log\utilax')
sga_target=5g
control_files=D:\oracle\oradata\utilax\control01.dbf
compatible='11.1.0'

4.Startup nomount performed.

5. Ran full backup on primary node to D drive outside of ASM.

%rman target=/ catalog=rman/password@RMAN

RMAN> run {
allocate channel d1 type disk;
backup format 'D:\backups\df_t%t_s%s_p%p' database;
sql 'alter system archive log current';
backup format 'D:\backups\al_t%t_s%s_p%p' archivelog all;
release channel d1;
}

6. Copied just those files from the manual backup (22GB) to remote host into the same directory on the D drive. Same D:\backups folder on both servers.

7. Connected with rman to target, catalog, and auxiliary databases. Ran rman command to duplicate database on target instance.

DUPLICATE TARGET DATABASE TO 'UTILAX' FROM ACTIVE DATABASE;

Received errors
RMAN-03009: failure of backup command on ORA_DISK_1 channel
ORA-17628: Oracle error 19505 returned by remote Oracle server

8. Looked in alert log of auxiliary database. Found errors:
ORA-19505: failed to identify file "D:\ORACLE\ORADATA\UTILAX\DATAFILE\SYSTEM.327.716381457
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified

9. Created all directories down to that path and tried again. Same errors.


Must be missing one or two steps but followed 382269.1 metalink document as close as possible. Sorry for the lack of screenshots but the databases are on private networks. Can someone who has done this regularly offer any help?

Thanks