Hi, i am trying to duplicate a database on the same server. It seems to have worked but am getting a lot of error messages in the alert log. Please can anyone advise if i am doing something wrong or i dont need to worry about these messages. Here is what i am doing:
Taking rman backup of proddb database and archivelog
Making pfile from spfile of proddb
create directories replacing name proddb with clonedb
copy proddbinit.ora file renaming to clonedbinit.ora replacing all references of proddb with clonedb
add 2 entries to clonedbinit.ora :
*.db_file_name_convert='PRODDB','CLONEDB'
*.log_file_name_convert='PRODDB','CLONEDB'
Set instance to CLONEDB and startup nomount
log into rman - rman AUXILIARY /
DUPLICATE DATABASE TO CLONEDB
BACKUP LOCATION '/U01/PRODDB'
I have not specified a SPFILE as i dont think i need one as i have created a full pfile
When i look through the alert log i get a load of messages saying 'ORA-01565: Unable to open Spfile' and error in identifying file &apos spfileclonedb.ora'
I read if you are cloning a database on the same server you should manually create your own pfile and not use the SPFILE option during duplication.
What am i doing wrong?
Many thanks
Adam