Cold Backup Cloning of Database .

 Cold Backup : 

A cold backup is done when there is no user activity going on with the system. Also called as offline backup, is taken when the database is not running and no users are logged in. all files of the database are copied and no changes during the copy are made.

Cold backup can be preformed when Database is in archive mode as well as Non archive log mode  .

Backup Strategy : 

Gather all the details of physical files (CRD) files in  database . redo log files are online redo log and archived redo log ones . 

1.  Select file_name,tablespace_name from dba_data_files  ;
2. select * from v$controlfile 
3. select member from v$logfile ;
4. select name from v$archived_Log ;
   
5.  create pfile from spfile
   

 Backup  the contol file manually .

1. alter database backup controlfile to trace as '/tmp/coldbackup_controlfile.sql' ;
      

Stop all the DB services (Database ,Listener)on source DB Server.

Copy all the files(Datafiles,redologfiles,pfile,contol file backup) from source to backup location  to target server 

On the target node

1. Copy the Pfile to dbs location 
2. Edit the pfile and modify the Database name details ,  adump location ,contolfile details .
3. Create all the Directories as per requirement 
   
4. Startup the database in no mount 
5. Edit the backup control file   -- Delete everything before "CREATE CONTROLFILE" and after "CHARACTER SET " .
6. Modify the location of data files and logfiles to point to new locations.
   
7. Change the following words in sql file  (REUSE to SET) and (NORESETLOGS to RESETLOGS)
8. SAVE FILE WITH EXTENSION ".sql" ;
9. execute the sql file from sqlplus  
10. Once the control file is successfully Created ,Open the database in reset log mode .
11. "select open_Mode from v$database ;