RMAN异机不同路径结构Duplicate数据库

最新推荐文章于 2021-07-10 09:04:32 发布

seertan

最新推荐文章于 2021-07-10 09:04:32 发布

阅读量1.8k

点赞数

分类专栏： Oracle备份与恢复文章标签： duplicate Duplicate oracle Oracle ORACLE rman RMAN 复制数据库

本文链接：https://blog.youkuaiyun.com/seertan/article/details/8144183

版权

本文详细介绍了如何使用RMAN在不同机器上复制Oracle数据库，包括目标数据库和辅助数据库的配置、参数文件修改、备份集创建与复制、数据库复制命令的执行等步骤，最终成功建立一个与目标数据库一致的副本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

	taget database	auxiliary database
操作系统	RHEL 5 update 8 X86_64	RHEL 5 update 8 X86_64
主机名	oraedu	oraedu1
IP地址/子网掩码	192.168.127.11/24	192.168.127.12/24
/etc/hosts	127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.127.11 oraedu 192.168.127.12 oraedu1	127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.127.12 oraedu1 192.168.127.11 oraedu
~/.bash_porfile	if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin EDITOR=vi export PATH EDITOR ORACLE_BASE=/u01/app/oracle ORACLE_SID=orcl export ORACLE_BASE ORACLE_SID ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH	if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin EDITOR=vi export PATH EDITOR ORACLE_BASE=/u01/app/oracle ORACLE_SID=orclb export ORACLE_BASE ORACLE_SID ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH
安装oracle软件的用户	oracle	oracle
Oracle软件版本	oracle 10g 10.2.0.1.0 X86_64	oracle 10g 10.2.0.1.0 X86_64
$ORACLE_BASE	/u01/app/oracle/	/u01/app/oracle/
$ORACLE_HOME	/u01/app/oracle/product/10.2.0/db_1/	/u01/app/oracle/product/10.2.0/db_1/
$ORACLE_SID	orcl	orclb
lisntener.o	SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraedu)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )	#这里要用静态注册的方式，否则oraedu无法连接此侦听，不用静态注册也可以成功(2012-10-31修改) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_NAME = orclb) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (SID_NAME = orclb) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraedu1)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )
tnsnames.ora	EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraedu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) ORCLB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraedu1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclb) (UR=A) ) ) #一定要在连接orclb的服务描述符中加上(UR=A)，否则RMAN连接orclb不是"not mounted"状态，而是"not started"状态，auxiliary database是"not started"状态执行duplicate是无法成功的。 Note: The (UR=A) clause in tnsnames.ora is intended to work with a dynamically registered handler so the use of SERVICE_NAME versus SID is preferred. (ID 362656.1)	EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraedu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) <

最低0.47元/天解锁文章