经验：使用duplicate克隆一个新数据库

===================================
Request: duplicate database wminvq1 to wminvq4 with nocatalog.
target: wminvq1
duplicate: wminvq4
auxiliary: wminvq4
server: same
path: different
binary: same
backup directory: same (don't need copy)
===================================

1, rman backup $target and check archive logs. (rman: /ora/wmomsq1/data/wminvq1/rman; arch: /ora/wmomsq1/data/wminvq1/arch)

2, create $auxiliary

1)create directory
mkdir -p /opt/oracle/admin/wminvq4/audit
mkdir -p /opt/oracle/admin/wminvq4/bdump
mkdir -p /opt/oracle/admin/wminvq4/cdump
mkdir -p /opt/oracle/admin/wminvq4/create
mkdir -p /opt/oracle/admin/wminvq4/ctl
mkdir -p /opt/oracle/admin/wminvq4/log
mkdir -p /opt/oracle/admin/wminvq4/pfile
mkdir -p /opt/oracle/admin/wminvq4/task
mkdir -p /opt/oracle/admin/wminvq4/udump
mkdir -p /opt/oracle/admin/wminvq4/utils

mkdir -p /ora/wmomsq1/data/wminvq4/arch
mkdir -p /ora/wmomsq1/data/wminvq4/rman

mkdir -p /ora/wminvq4/data/control
mkdir -p /ora/wminvq4/data/redo
mkdir -p /ora/wminvq4/data/undo
ln -s /ora/wminvq4/data/control /ora/wminvq4/control
ln -s /ora/wminvq4/data/redo /ora/wminvq4/redo
ln -s /ora/wminvq4/data/undo /ora/wminvq4/undo

2)create password file
orapwd file=$ORACLE_HOME/dbs/orapwwminvq4 password=K88pal1ve entries=30

3)create pfile ( cp from target database pfile and modify db_name, path, shared_pool>200M, block_size same as target, db_file_name_convert, log_file_name_convert)
cp /opt/oracle/admin/wminvq1/pfile/initwminvq1.ora /opt/oracle/admin/wminvq4/pfile/initwminvq4.ora
ln -s /opt/oracle/admin/wminvq4/pfile/initwminvq4.ora /opt/oracle/product/1020/dbs/initwminvq4.ora
vi /opt/oracle/product/1020/dbs/initwminvq4.ora

=============================== initwminvq4.ora =======================================
*.aq_tm_processes=4
*.background_dump_dest='/opt/oracle/admin/wminvq4/bdump'
*.compatible='10.2.0'
*.control_files='/ora/wminvq4/control/wminvq4_control_01.ctl','/ora/wminvq4/control/wminvq4_control_02.ctl'
*.core_dump_dest='/opt/oracle/admin/wminvq4/cdump'
*.db_block_size=8192
*.db_cache_size=200m
*.db_domain='walmart.com'#AYW 03/13/2003
*.db_file_multiblock_read_count=32
*.db_files=1000
*.db_name='wminvq4'
*.dml_locks=200# SMALL
*.global_names=FALSE
*.instance_name='wminvq4'
*.java_pool_size=100m
*.job_queue_processes=20
*.log_archive_dest_1='location="/ora/wmomsq1/data/wminvq4/arch"'
*.log_buffer=256000# MEDIUM
*.log_checkpoint_interval=0
*.log_checkpoint_timeout=0
*.open_cursors=2000
*.open_links=10
*.optimizer_features_enable='10.2.0.2'
*.optimizer_index_caching=50
*.optimizer_index_cost_adj=50
*.optimizer_mode='choose'
*.OS_AUTHENT_PREFIX=''
*.parallel_max_servers=10
*.parallel_min_servers=5
*.pga_aggregate_target=1024m
*.processes=1500
*.QUERY_REWRITE_ENABLED='TRUE'
*.QUERY_REWRITE_INTEGRITY='TRUSTED'
*.remote_dependencies_mode='TIMESTAMP'
*.remote_login_passwordfile='exclusive'
*.replication_dependency_tracking=true
*.session_cached_cursors=50
*.shared_pool_reserved_size=20971520
*.shared_pool_size=314572800
*.sort_area_retained_size=0
*.sort_area_size=1024000
wminvq4.streams_pool_size=50m
*.timed_statistics=true# if you want timed statistics
*.undo_management='auto'
*.undo_retention=36000# see note-20060210
*.undo_tablespace='undotbs'
*.user_dump_dest='/opt/oracle/admin/wminvq4/udump'
*.utl_file_dir='/opt/oracle/admin/wminvq4/utils'
*.workarea_size_policy='auto'
*.db_file_name_convert=('/ora/wminvq1','/ora/wminvq4')
*.log_file_name_convert=('/ora/wminvq1','/ora/wminvq4')
============================================================

4)startup $auxiliary nomount and create spfile from pfile
ORACLE_SID=wminvq4
startup nomount pfile='/opt/oracle/product/1020/dbs/initwminvq4.ora'
create spfile='/opt/oracle/admin/wminvq4/pfile/spfilewminvq4.ora' from pfile;
host ln -s /opt/oracle/admin/wminvq4/pfile/spfilewminvq4.ora /opt/oracle/product/1020/dbs/spfilewminvq4.ora

5)restart $auxiliary nomount to apply spfile and check parameters
shutdown immediate
startup nomount
show parameter spfile
show parameter control_files
show parameter db_name
show parameter db_file_name_convert
show parameter log_file_name_convert
exit

6)setup listener and tnsnames to ensure from target database can connect to $auxiliary.

vi $TNS_ADMIN/listener.ora
==============listener.ora====================
#add service to listener:
SID_LIST_LISTENER =
  (SID_LIST =
     (SID_DESC =
      (SDU = 32767)
      (GLOBAL_DBNAME = wminvq4)
      (ORACLE_HOME = /opt/oracle/product/1020)
      (SID_NAME = wminvq4)
     )
 )
===================================

vi $TNS_ADMIN/tnsnames.ora
==============tnsnames.ora====================
#add:
wminvq4 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = caq-db4)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = wminvq4)
    )
  )
===================================

lsnrctl reload LISTENER
tnsping wminvq4
sqlplus sys/K88pal1ve@wminvq4 as sysdba
show parameter db_name
exit

3, rman duplicate database

1)prepare rman script
vi /ora/wmomsq1/data/wminvq4/rman/duplicate_wminvq4.rcv

====================duplicate_wminvq4.rcv========================
connect target /
connect auxiliary sys/password@wminvq4
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;

allocate auxiliary channel t1 type disk;
allocate auxiliary channel t2 type disk;

duplicate target database to wminvq4;
}
=======================================================

2)check rman backup

ORACLE_SID=wminvq1
rman target / auxiliary sys/password@wminvq4
catalog start with '/ora/wmomsq1/data/wminvq1/rman';
catalog start with '/ora/wmomsq1/data/wminvq1/arch';
list backup;
report schema;
exit

3)run duplicate
ORACLE_SID=wminvq1
##currently the database is in nomount status
nohup rman cmdfile='/ora/wmomsq1/data/wminvq4/rman/duplicate_wminvq4.rcv' log='/ora/wmomsq1/data/wminvq4/rman/duplicate_wminvq4.log' &
tail -f /ora/wmomsq1/data/wminvq4/rman/duplicate_wminvq4.log

4, post task & check
1) add sid to /var/opt/oracle/oratab
2) compare 'select count(*) from dba_objects', 'select count(*) from dba_users' ...

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8684388/viewspace-617943/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8684388/viewspace-617943/