Cloneb
1) Make sure all rman backup files from PRODA are in the same location(s) in the new server as the source server (same path names)
2) Copy the initPRODA.ora file to the new ${Oracle Home}/dbs location and:
a) change the name to initCLONEB.ora
b) Add the db_file_name_convert and log_file_name_convert to translate the file locations to new locations.
c) DO NOT yet change the db_name
3) Set ORACLE_SID to CLONEB
4) Statup RMAN and execute these commands
Code:
CONNECT TARGET /
STARTUP NOMOUNT
### This is the PRODA db-id:
SET DBID=123456789;
RESTORE CONTROLFILE FROM '/backup/PRODA/rman/c-nnnnn-mmmm-00';
ALTER DATABASE MOUNT;
RUN {
ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
ALLOCATE CHANNEL C2 DEVICE TYPE DISK;
ALLOCATE CHANNEL C3 DEVICE TYPE DISK;
ALLOCATE CHANNEL C4 DEVICE TYPE DISK;
### You need to set the point in time recovery:
SET UNTIL SEQUENCE 6215 THREAD 1;
###
RESTORE DATABASE;
RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;
5) Use sqlplus to create the temporary files.
6) Use the nid (newid) utility to change the database name.
7) Backup the clone immediately.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb