DBA Hub

📋Steps in this guide1/3

Database Cloning Using Cold Backup

Cold database backup means while taking backup or doing cloning, we need to shutdown the source database.

oracle configurationintermediate
by OracleDba
13 views
1

Overview

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 no archive log mode. Please 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.Here we will clone a database PRIM to a new server with name TRGDB

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
alter database backup controlfile to trace as '/u01/app/oracle/ctrl_bkokp.sql';

SQL> select file_name from dba_data_files;

FILE_NAME
---------------------------------------------------------------
/u01/app/oracle/product/oradata/PRIM/system01.dbf
/u01/app/oracle/product/oradata/PRIM/sysaux01.dbf
/u01/app/oracle/product/oradata/PRIM/undotbs01.dbf
/u01/app/oracle/product/oradata/PRIM/users01.dbf
/u01/app/oracle/product/oradata/PRIM/CTLDATA_01.dbf
/u01/app/oracle/product/oradata/PRIM/CTLIDX_01.dbf
/u01/app/oracle/product/oradata/PRIM/catalog01.dbf
/u01/app/oracle/product/oradata/PRIM/catalog_idx01.dbf
/u01/app/oracle/product/oradata/PRIM/GGATE_01.dbf


SQL> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------
/u01/app/oracle/product/oradata/PRIM/temp01.dbf
/u01/app/oracle/product/oradata/PRIM/catalog_temp01.dbf
2

Section 2

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
shut immediate

scp /u01/app/oracle/product/oradata/PRIM/*dbf
[email protected]
:/u01/app/oracle/product/oradata/TRGDB/

cat initTRGDB.ora

*.audit_file_dest='/u01/app/oracle/admin/TRGDB/adump'
*.audit_trail='D
*.compatible='12.1.0.2.0'
*.control_files='/u01/app/oracle/product/oradata/TRGDB/control01.ctl','/u01/app/oracle/product/oradata/TRGDB/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='TRGDB'
*.diagnostic_dest='/u01/app/oracle/'*.event=''
*.open_cursors=300
*.pga_aggregate_target=524288000
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.sessions=1536
*.sga_max_size=7373586432
*.sga_target=7373586432
*.undo_tablespace='UNDOTBS1'

export ORACLE_SID=TRGDB
startup nomount pfile=initTRGDB.ora

ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE.

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "TCOMDB01" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2336
LOGFILE
GROUP 1 '/u01/app/oracle/product/oradata/PRIM/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/product/oradata/PRIM/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/product/oradata/PRIM/redo03.log' SIZE 50M BLOCKSIZE 512
 STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/product/oradata/PRIM/system01.dbf',
'/u01/app/oracle/product/oradata/PRIM/CTLDATA_01.dbf',
'/u01/app/oracle/product/oradata/PRIM/sysaux01.dbf',
'/u01/app/oracle/product/oradata/PRIM/undotbs01.dbf',
'/u01/app/oracle/product/oradata/PRIM/CTLIDX_01.dbf',
'/u01/app/oracle/product/oradata/PRIM/users01.dbf',
'/u01/app/oracle/product/oradata/PRIM/catalog01.dbf',
'/u01/app/oracle/product/oradata/PRIM/catalog_idx01.dbf',
'/u01/app/oracle/product/oradata/PRIM/GGATE_01.dbf'
CHARACTER SET AL32UTF8
;
3

Section 3

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
CREATE CONTROLFILE SET DATABASE "TRGDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2336
LOGFILE
GROUP 1 '/u01/app/oracle/product/oradata/TRGDB/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/product/oradata/TRGDB/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/product/oradata/TRGDB/redo03.log' SIZE 50M BLOCKSIZE 512
 STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/product/oradata/TRGDB/system01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/CTLDATA_01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/sysaux01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/undotbs01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/CTLIDX_01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/users01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/catalog01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/catalog_idx01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/GGATE_01.dbf'
CHARACTER SET AL32UTF8
;

SQL>CREATE CONTROLFILE SET DATABASE "PRIM" RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2336
LOGFILE
GROUP 1 '/u01/app/oracle/product/oradata/TRGDB/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/product/oradata/TRGDB/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/product/oradata/TRGDB/redo03.log' SIZE 50M BLOCKSIZE 512
 STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/product/oradata/TRGDB/system01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/CTLDATA_01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/sysaux01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/undotbs01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/CTLIDX_01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/users01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/catalog01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/catalog_idx01.dbf',
'/u01/app/oracle/product/oradata/TRGDB/GGATE_01.dbf'
CHARACTER SET AL32UTF8
;
/

controlfile created;

ALTER DATABASE OPEN RESETLOGS;

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/product/oradata/PRIM/temp01.dbf'
SIZE 11529M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
ALTER TABLESPACE CATALOG_TEMP ADD TEMPFILE '/u01/app/oracle/product/oradata/PRIM/catalog_temp01.dbf'
SIZE 524288000 REUSE AUTOEXTEND OFF;
 End of tempfile additions.

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/product/oradata/TRGDB/temp01.dbf'
SIZE 11529M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;


ALTER TABLESPACE CATALOG_TEMP ADD TEMPFILE '/u01/app/oracle/product/oradata/TRGDB/catalog_temp01.dbf'
SIZE 524288000 REUSE AUTOEXTEND OFF;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!