TEST and Duplicate DB
필요 디렉터리 생성
mkdir /data
cd /data
mkdir reorcl arc2
pfile을 복제 및 수정
SYS@orcl>create pfile from spfile;
[oracle@lnx04 dbs]$ cp initorcl.ora initreorcl.ora
[oracle@lnx04 dbs]$ vi initreorcl.ora
치환 명령을 이용한다 :% s/orcl/reorcl/g
control_files의 경로
FRA 관련항목 주석처리
logfile 경로 수정
convert할 항목들 경로 설정
reorcl.__db_cache_size=687865856
reorcl.__java_pool_size=16777216
reorcl.__large_pool_size=16777216
reorcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
reorcl.__pga_aggregate_target=587202560
reorcl.__sga_target=1124073472
reorcl.__shared_io_pool_size=0
reorcl.__shared_pool_size=335544320
reorcl.__streams_pool_size=33554432
*.audit_file_dest='/u01/app/oracle/admin/reorcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data/reorcl/control01.ctl','/data/reorcl/control02.ctl'#Restore Controlfile
*.db_16k_cache_size=16777216
*.db_block_size=8192
*.db_domain=''
*.db_flashback_retention_target=2880
*.db_name='reorcl'
#*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
#*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=reorclXDB)'
*.log_archive_dest_1='location=/data/arc2'
*.log_archive_format='ORCL_%r_%t_%s.arc'
*.log_archive_max_processes=4
*.memory_target=1697644544
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan='DAYTIME'
reorcl.resource_manager_plan='DAYTIME'
*.undo_tablespace='UNDOTBS1'
*.db_file_name_convert=(/u01/app/oracle/oradata/orcl/,/data/reorcl/)
*.log_file_name_convert=(/u01/app/oracle/oradata/orcl/,/data/reorcl/)
[oracle@lnx04 dbs]$ orapwd file=orapwreorcl password=oracle
vi listener.ora
#sid_list_listener =
# (sid_list =
# (sid_desc =
# (sid_name = PLSExtProc)
# (oracle_home = /u01/app/oracle/product/11.2.0/db_1)
# (program = extproc)
# )
# (sid_desc =
# (sid_name=reorcl)
# (oracle_home = u01/app/oracle/product/11.2.0/db_1)
# )
# )
vi tnsnames.ora
REORCL =
(description =
(address_list =
(address = (protocol = tcp)(host = lnx04.ocmkorea.com)(port = 1521))
(load_balance = yes)
)
(connect_data =
(server = dedicated)
(sid = reorcl)
)
)
[oracle@lnx04 admin]$ tnsping reorcl
OK (0 msec)
[oracle@lnx04 admin]$ export ORACLE_SID=reorcl
[oracle@lnx04 admin]$ echo $ORACLE_SID
reorcl
[oracle@lnx04 admin]$ sqlplus sys/oracle as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 7 15:04:59 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SYS@reorcl>startup nomount
ORACLE instance started.
duplicate 전 모든 세션을 닫고 다른 세션으로 창을 하나 연다
another session
[oracle@lnx04 ~]$ export ORACLE_SID=reorcl
[oracle@lnx04 ~]$ echo $ORACLE_SID
reorcl
[oracle@lnx04 ~]$ rman nocatalog
RMAN> connect target sys/oracle@orcl;
RMAN> connect auxiliary sys/oracle; < reorcl 접속
RMAN> duplicate target database to reorcl ; < 수동 채널도 할당이 가능
database opened
Finished Duplicate Db at 2015-11-07:15:18:01
SYS@reorcl>select name from v$datafile;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
/data/reorcl/system01.dbf
/data/reorcl/sysaux01.dbf
/data/reorcl/undotbs01.dbf
/data/reorcl/users01.dbf
/data/reorcl/example01.dbf
/data/reorcl/rman_tbs.dbf
6 rows selected.
SYS@reorcl>select name from v$tablespace;
NAME
------------------------------
SYSTEM
TEMP
SYSAUX
UNDOTBS1
USERS
EXAMPLE
6 rows selected.
SYS@reorcl>select instance_name , status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
reorcl OPEN