Database Cloning From Cold Backup

1. SHUTDOWN SOURCE DATABASE CLEANLY BYSHUTDOWN IMMEDIATE;
 
2. COPY ALL SOURCE DATABASE DATAFILES TO NEW LOCATION OF DUPLICATE DATABASE EXCEPT CONTROL FILES.
 
3. CREATE BDUMP,UDUMP,CDUMP FOLDERS IN WINDOWS
ORACLE_BASE/ADMIN/DATABASENAME_FOLDER/ {CDUMP,UDUMP,BDUMP}
IN LINUX$ORACLE_BASE/ADMIN/DATABASENAME_FOLDER/ {CDUMP,UDUMP,BDUMP}
 
4. STARTUP SOURCE DATABASE.
 
5. CREATE PFILE WITH NEW SID LIKE create pfile=’location’ from spfile.
 
6. MODIFY PFILE PARAMETERS OF DUPLICAT E DATABASE ACCORDING TO DUPLICATE DATABASE NAME AND THEIR FILES LOCATIONS.
 
7. CREATE CONTROL FILE USINGALTER DATABASE BACKUP CONTROLFILE TO TRACE AS "LOCATION"
 
8. CHANGE CONTROL FILE PARAMETERS i.e. REUSE BY SET
NORESETLOGS BY RESETLOGS.
SOURCE DATABASE DATAFILES LOCATIONS WITH DUPLICATE
DATABASE DATAFILES LOCATIONS.
　 
NOTE : IF YOU WANT TO USE FEW TABLESPACES OF SOURCE DATABASE
THEN DONT USE ALL DATAFILES JUST USE DATAFILES RELATED TO THOSE TABLESPACES.
　 
9. CREATE NEW SID USING ORADIM -NEW -SID STANDBYON COMMAND PROMPT(AT ORACLE_HOME/DATABASE/INITDATABASE_NAME.ORA)
CREATE PASSWORD FILE FOR DUPLICATE DATABASE BY ORAPWD FILE=’LOCATION’ PASSWORD={PASSWORD} (SAME LOCATION AS PARAMETER FILE )
 
10. (AT ORACLE_HOME/DATABASE/ORAPWDATABASE_NAME.ORA)
　 
11. GIVE ENTRY IN TNSNAMES.ORA AND LISTENER.ORA FILES OF DUPLICATE DATABASE.
　 
12. CONNECT TO INSTANCE OF DUPLICATE DATABASE.
LIKE: SQLPLUS "SYS AS SYSDBA"
　 
13. STARTUP NOMOUNT USING PARAMETER FILE LOCATIONBECAUSE AT NOMOUNT PFILE READED.LIKE : STARTUP NOMOUNT;
　 
14. CREATE CONTROL FILE BY SCRIPT WHERE NEW CONTOL FILE LOCATED.LIKE : CONTROL FILE IS AT C:\DB\CONTROL.CTL
THEN ON SQL PROMPT @C:\DB\CONTROL.CTL;
　 
15. ALTER DATABASE OPEN RESETLOGS
 
• CLONED DATABASE IS READY TO USE.