设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › Active Duplication Database问题

Active Duplication Database问题

[复制链接]
查看11 | 回复4 | 2011-5-7 01:45:08 | 显示全部楼层 |阅读模式
本帖最后由 loksqqq 于 2017-11-6 17:24 编辑
刚学习11G的DuplicateDatabase，在进行异机Duplicate成功后 (主機Database為orcl，复制Database為orcl3)，查看复制Database的Pfile时，有以下问题疑惑
Orcl3的Pfile内容：
orcl.__db_cache_size=113246208
orcl3.__db_cache_size=243269632
orcl.__java_pool_size=4194304
orcl3.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl3.__large_pool_size=4194304
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl3.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=239075328
orcl3.__pga_aggregate_target=201326592
orcl.__sga_target=339738624
orcl3.__sga_target=377487360
orcl.__shared_io_pool_size=0
orcl3.__shared_io_pool_size=0
orcl.__shared_pool_size=205520896
orcl3.__shared_pool_size=117440512
orcl.__streams_pool_size=4194304
orcl3.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl3/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl3/controlfile/current.260.914189965','/u01/app/oracle/flash_recovery_area/orcl3/controlfile/current.256.914189965'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/'
*.db_domain='example.com'
*.db_file_name_convert='+DATA/orcl/datafile/','/u01/app/oracle/oradata/orcl3/datafile'
*.db_name='orcl3'#Reset to original value by RMAN
*.db_recovery_file_dest_size=4070572032
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area/'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_file_name_convert='+DATA/orcl/onlinelog/','/u01/app/oracle/oradata/orcl3/onlinelog','+FRA/orcl/onlinelog/','/u01/app/oracle/flash_recovery_area/orcl3/onlinelog'
*.memory_target=576716800
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='shared'
*.undo_tablespace='UNDOTBS1'
复制代码1. PFile中1-18行出现重复的参数(一个是orcl、一个是orcl3)，请问orcl3中的orcl相关参数是否没用了，可否删除掉?2. PFile中26及32行的*.log_file_name_convert与*.db_file_name_convert中影射的参数是否没用了，可否删除?
以下是进行ActiveDuplication Database过程所进行的设定：mkdir -p /u01/app/oracle/oradata
mkdir -p /u01/app/oracle/oradata/orcl3
mkdir -p /u01/app/oracle/oradata/orcl3/datafile
mkdir -p /u01/app/oracle/oradata/orcl3/tempfile
mkdir -p /u01/app/oracle/oradata/orcl3/onlinelog
mkdir -p /u01/app/oracle/oradata/orcl3/controlfile
mkdir -p /u01/app/oracle/flash_recovery_area
mkdir -p /u01/app/oracle/flash_recovery_area/orcl3
mkdir -p /u01/app/oracle/flash_recovery_area/orcl3/onlinelog
mkdir -p /u01/app/oracle/flash_recovery_area/orcl3/controlfile
mkdir -p /u01/app/oracle/diag/rdbms/orcl3/orcl3/trace
mkdir -p /u01/app/oracle/diag/rdbms/orcl3/orcl3/cdump
mkdir -p /u01/app/oracle/admin/orcl3/adump

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1/dbs
cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
vi initorcl3.ora (copy Target Database pfile to duplication database and replace the orcl to orcl3)
orcl3.__db_cache_size=113246208
orcl3.__java_pool_size=4194304
orcl3.__large_pool_size=4194304
orcl3.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl3.__pga_aggregate_target=239075328
orcl3.__sga_target=339738624
orcl3.__shared_io_pool_size=0
orcl3.__shared_pool_size=205520896
orcl3.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/orcl3/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+DATA/orcl/controlfile/current.260.914189965','+FRA/orcl/controlfile/current.256.914189965'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain='example.com'
*.db_name='orcl3'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4070572032
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.memory_target=576716800
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='shared'
*.undo_tablespace='UNDOTBS1'

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapworcl password=oracle

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl3.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl3)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
lsnrctl stop
lsnrctl start

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
vi $ORACLE_HOME/network/admin/tnsnames.ora
ORCL3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl3.example.com) -- global_dbname of orcl2 listener
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.136)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl) -- global_dbname of orcl listener
)
)
tnsping orcl3
tnsping orcl

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------- Target Database -------------------
cd $ORACLE_HOME/network/admin
vi tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.example.com)
)
)
ORCL3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.79)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl3.example.com)
)
)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
sqlplus sys/oracle as sysdba
startup nomount
exit
rman target sys/oracle@orcl auxiliary sys/oracle@orcl3
run
{
set newname for datafile 1 to '/u01/app/oracle/oradata/orcl3/datafile/system.256.914189793';
set newname for datafile 2 to '/u01/app/oracle/oradata/orcl3/datafile/sysaux.257.914189795';
set newname for datafile 3 to '/u01/app/oracle/oradata/orcl3/datafile/undotbs1.258.914189797';
set newname for datafile 4 to '/u01/app/oracle/oradata/orcl3/datafile/users.259.914189797';
set newname for datafile 5 to '/u01/app/oracle/oradata/orcl3/datafile/example.265.914190037';
set newname for tempfile 1 to '/u01/app/oracle/oradata/orcl3/tempfile/temp.264.914190027';
duplicate target database to orcl3
from active database
spfile
parameter_value_convert ('orcl','orcl3')
set audit_file_dest='/u01/app/oracle/admin/orcl3/adump'
set db_file_name_convert='+DATA/orcl/datafile/','/u01/app/oracle/oradata/orcl3/datafile'
set log_file_name_convert='+DATA/orcl/onlinelog/','/u01/app/oracle/oradata/orcl3/onlinelog','+FRA/orcl/onlinelog/','/u01/app/oracle/flash_recovery_area/orcl3/onlinelog'
set control_files='/u01/app/oracle/oradata/orcl3/controlfile/current.260.914189965','/u01/app/oracle/flash_recovery_area/orcl3/controlfile/current.256.914189965'
set db_name='orcl3'
set db_create_file_dest='/u01/app/oracle/oradata/'
set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area/'
nofilenamecheck;
}
复制代码






回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
双下划线的参数，应该全部删除。
对于你这种ASM转文件系统，并且没有使用OMF的，*.log_file_name_convert与*.db_file_name_convert是必须使用的，具体方法去看官方文档

回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
zergduan 发表于 2017-11-7 11:09
双下划线的参数，应该全部删除。
对于你这种ASM转文件系统，并且没有使用OMF的，*.log_file_name_convert ...
请教一下：
双下划线的参数不是用来设定内存如何分配的参数吗?
如果把双下划线的参数去掉不就删除了内存分配吗?
在PFILE中有指定*.db_create_file_dest不是启用了OMF吗?
因为Database还在学习中，所以有一些不懂的地方，请大大指教一下，谢谢

回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
loksqqq 发表于 2017-11-7 12:11
请教一下：
双下划线的参数不是用来设定内存如何分配的参数吗?
如果把双下划线的参数去掉不就删除了内 ...
1。双下划线代表AMM，上一次当前内存个组件分配大小，不需要保留，每次启动会自动生成
2. 是的你已经启动OMF，无需使用两个convert参数。
回复

使用道具 举报

千问 | 2011-5-7 01:45:08 | 显示全部楼层
RMAN duplicate 会自动生成和更改pfile。所以你应该检查spfile，而不是pfile。
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行