Cold database backup means while taking backup or doing cloning, we need to shutdown the source database. This method is usually used for test database when database is in noarchivelog mode.
Note- Both the source and target db server should be on same platform and the target db version will be that of the source db.So make sure oracle binary is already installed on target db server.
SOURCE DB – jupiter
TARGET DB – sakthi
Steps:
1.Take backup of controlfile as trace:[SOURCE DB]
2. Note down the location of datafiles[SOURCE DB]
3. Shutdown the database:[SOURCE DB]
4. Copy the data files and temp files to the target db server
5. Prepare the init file for target db:[TARGET DB]
6. Start the database in nomount stage:[TARGET DB]
7. Re-recreate the controlfile [ TARGET DB ]
8. Open the database in resetlog mode
Send the datafile,log files and control files to target destination
[oracle@jupiter rock]$ scp -r *.log oracle@192.168.1.135:/u01/ram The authenticity of host '192.168.1.135 (192.168.1.135)' 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 Warning: Permanently added '192.168.1.135' (RSA) to the list of known hosts. oracle@192.168.1.135'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@jupiter rock]$ scp -r users01.dbf oracle@192.168.1.135:/u01/ram oracle@192.168.1.135's password: users01.dbf 100% 5128KB 5.0MB/s 00:01 [oracle@jupiter rock]$ scp -r undotbs01.dbf oracle@192.168.1.135:/u01/ram oracle@192.168.1.135's password: undotbs01.dbf 100% 70MB 3.7MB/s 00:19 [oracle@jupiter rock]$ scp -r temp01.dbf oracle@192.168.1.135:/u01/ram oracle@192.168.1.135's password: temp01.dbf 100% 32MB 2.9MB/s 00:11 [oracle@jupiter rock]$ scp -r system01.dbf oracle@192.168.1.135:/u01/ram oracle@192.168.1.135's password: system01.dbf 100% 810MB 3.0MB/s 04:31 [oracle@jupiter rock]$ scp -r sysaux01.dbf oracle@192.168.1.135:/u01/ram oracle@192.168.1.135's password: sysaux01.dbf 100% 490MB 3.2MB/s 02:34 [oracle@jupiter u01]$ scp -r ctrl.sql oracle@192.168.1.135:/u01/ram oracle@192.168.1.135's password: ctrl.sql 100% 5865 5.7KB/s 00:00
Now all the files are in the target destination.
[oracle@sakthi ram]$ ls
ctrl.sql redo01.log redo03.log system01.dbf undotbs01.dbf
initjupiter.ora redo02.log sysaux01.dbf temp01.dbf users01.dbf
Edit the control file
[oracle@sakthi ram]$ vi ctrl.sql CREATE CONTROLFILE SET DATABASE "ROCK" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/u01/ram/redo01.log' SIZE 200M BLOCKSIZE 512, GROUP 2 '/u01/ram/redo02.log' SIZE 200M BLOCKSIZE 512, GROUP 3 '/u01/ram/redo03.log' SIZE 200M BLOCKSIZE 512 DATAFILE '/u01/ram/system01.dbf', '/u01/ram/sysaux01.dbf', '/u01/ram/undotbs01.dbf', '/u01/ram/users01.dbf' CHARACTER SET AL32UTF8
Edit the PFILE
[oracle@sakthi ram]$ vi initjupiter.ora db_name=rock control_files='/u01/ram/ctrl.ctl'
NOW open the database.
[oracle@sakthi ram]$ export ORACLE_SID=rock [oracle@sakthi ram]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Fri Jan 18 01:20:35 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup pfile='/u01/ram/initjupiter.ora' nomount ORACLE instance started. Total System Global Area 243269632 bytes Fixed Size 8619256 bytes Variable Size 180357896 bytes Database Buffers 50331648 bytes Redo Buffers 3960832 bytes SQL> @ctrl.sql Control file created. SQL> alter database open resetlogs; Database altered. SQL> select name,open_mode from v$database; NAME OPEN_MODE ------ ------------- ROCK READ WRITE
Catch Me On:- Hariprasath Rajaram Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba FB Group:https://www.facebook.com/groups/894402327369506/ FB Page: https://www.facebook.com/dbahariprasath/? Twitter: https://twitter.com/hariprasathdba