ORACLE DATABSE CLONING USING COLD BACKUP
ORACLE DATABSE CLONING USING COLD BACKUP DESCRIPTION: The Cold database backup is, while taking backup or doing cloning, we need to shutdown the source database. This method is usually used for test server when database is in no archive log mode. First we want to take a backup of control file, note down the data file location, and finally shut down the database in source database side. Second. Transfer the data file, temp file to target database, create a pfile(init.ora) for target database. Then start the target database in no mount stage, then in there recreate a control file, then open the database in reset logs. Send the datafile,log files and control files to target destination: [oracle@oracle trainee]$ scp -r *.log oracle@192.168.1.122:/u01/shan The authenticity of host ‘192.168.1.122 (192.168.1.122)’ can’t be established. RSA key fingerprint is 9b:35:ae:ab:bf:6b:33:b4:43:86:f5:98:8b:bb:11:1c. Are you sure you want to continue connecting (yes/no)? oracle Please type ‘yes’ or ‘no’: yes oracle@192.168.1.122’s password: redo01.log 100% 200MB 3.1MB/s 01:05 redo02.log 100% 200MB 4.0MB/s 00:50 redo03.log 100% 200MB 3.5MB/s 00:58 [oracle@oracle trainee]$ scp -r users01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: users01.dbf 100% 5128KB 5.0MB/s 00:01 [oracle@oracle trainee]$ scp -r undotbs01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: undotbs01.dbf 100% 70MB 3.7MB/s 00:19 [oracle@oracle trainee]$ scp -r temp01.dbf oracle@192.168.1.122:/u01/shan oracle@192.168.1.122’s password: temp01.dbf 100% 32MB 2.9MB/s 00:11…
Read More