DESCRIPTION:
In this blog,we are going to learn Oracle Database Cloning.
INTRODUCTION:
The cloning operation creates a copy of the database data files, and creates new online redo log files and control files. The database can be optionally recovered to a specified time, based on the specified recovery options.
[oracle@oracle CLONE1]$ scp -r *.log oracle@192.168.1.155:/u01/Biju1 The authenticity of host '192.168.1.155 (192.168.1.155)' 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.155' (RSA) to the list of known hosts. oracle@192.168.1.155'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 CLONE1]$ scp -r users01.dbf oracle@192.168.1.155:/u01/Biju1 oracle@192.168.1.155's password: users01.dbf 100% 5128KB 5.0MB/s 00:01
[oracle@oracle CLONE1]$ scp -r undotbs01.dbf oracle@192.168.1.155:/u01/Biju1 oracle@192.168.1.155's password: undotbs01.dbf 100% 70MB 3.7MB/s 00:19 [oracle@oracle CLONE1]$ scp -r temp01.dbf oracle@192.168.1.155:/u01/Biju1 oracle@192.168.1.155's password: temp01.dbf 100% 32MB 2.9MB/s 00:11
[oracle@oracle CLONE1]$ scp -r system01.dbf oracle@192.168.1.155:/u01/Biju1 oracle@192.168.1.155's password: system01.dbf 100% 810MB 3.0MB/s 04:31
[oracle@oracle CLONE1]$ scp -r sysaux01.dbf oracle@192.168.1.155:/u01/Biju1 oracle@192.168.1.155's password: sysaux01.dbf 100% 490MB 3.2MB/s 02:34 [oracle@oracle u01]$ scp -r ctrl.sql oracle@192.168.1.155:/u01/Biju1 oracle@192.168.1.155's password: ctrl.sql 100% 5865 5.7KB/s 00:00
Now all the files are in the target destination.
[oracle@biju Biju1]$ ls
ctrl.sql redo01.log redo03.log system01.dbf undotbs01.dbf
initoracle.ora redo02.log sysaux01.dbf temp01.dbf users01.dbf
Edit the control file
[oracle@biju Biju1]$ vi ctrl.sql CREATE CONTROLFILE SET DATABASE "CLONE1" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/u01/Biju1/redo01.log' SIZE 200M BLOCKSIZE 512, GROUP 2 '/u01/Biju1/redo02.log' SIZE 200M BLOCKSIZE 512, GROUP 3 '/u01/Biju1/redo03.log' SIZE 200M BLOCKSIZE 512 DATAFILE '/u01/Biju1/system01.dbf', '/u01/Biju1/sysaux01.dbf', '/u01/biju/undotbs01.dbf', '/u01/biju/users01.dbf' CHARACTER SET AL32UTF8 Edit the PFILE
[oracle@biju Biju1]$ vi initoracle.ora db_name=CLONE1 control_files='/u01/biju/ctrl.ctl' Open the database.
[oracle@biju Biju1]$ export ORACLE_SID=CLONE1 [oracle@biju Biju1]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 20 22:32:35 2020 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup pfile='/u01/Biju1/inittarinee.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 ------ ------------- CLONE1 READ WRITE
Recent Posts