DUPLICATING TO REMOTE HOST WITH CONNECTING TARGET

最新推荐文章于 2025-11-25 12:24:36 发布

原创最新推荐文章于 2025-11-25 12:24:36 发布 · 81 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

Oracle 专栏收录该内容

193 篇文章

订阅专栏

该篇博客详细记录了如何备份Oracle 11g数据库并将其克隆到新的服务器，包括创建dump文件夹、配置参数文件、复制备份、设置监听和tnsnames.ora，以及启动新库并验证克隆结果的过程。

--环境:

--目标数据库: orcl 10.10.10.8

--辅助数据库: test 10.10.10.7

$ cat /etc/issue

CentOS release 6.8 (Final)

Kernel \r on an \m

SQL> select * from v$version where rownum<2;

BANNER

----------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

RMAN> backup database include current controlfile plus archivelog delete input;

复制上面的备份到新库的相同位置中（注必须复制到新库，且为相同目录才行！！）

$ cd /oracle/fast_recovery_area/

$ tar zcvf orcl.tar.gz ORCL

$ scp orcl.tar.gz oracle@10.10.10.7:/oracle/fast_recovery_area/

备库

$ tar zxvf orcl.tar.gz

创建相应的dump文件夹

$ cd /oracle

$ mkdir -p oradata/test

$ mkdir -p fast_recovery_area/test

$ mkdir -p admin/test/adump

$ mkdir -p admin/test/dpdump

$ mkdir -p admin/test/pfile

配置辅助实例参数文件

原库执行

SQL> create pfile='/oracle/inittest.ora' from spfile;

$ vim /oracle/inittest.ora

test.__db_cache_size=125829120

test.__java_pool_size=4194304

test.__large_pool_size=8388608

test.__oracle_base='/oracle'#ORACLE_BASE set from environment

test.__pga_aggregate_target=192937984

test.__sga_target=293601280

test.__shared_io_pool_size=0

test.__shared_pool_size=146800640

test.__streams_pool_size=0

*.audit_file_dest='/oracle/admin/test/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/oracle/oradata/test/control01.ctl','/oracle/fast_recovery_area/test/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='test'

*.db_recovery_file_dest='/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4385144832

*.db_unique_name='test'

*.diagnostic_dest='/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=10.10.10.7)(PORT=1521)(SID=test))'

*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST

MANDATORY Valid_for=(all_logfiles, all_roles)'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=486539264

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

*.db_file_name_convert=('/oracle/oradata/orcl','/oracle/oradata/test')

*.log_file_name_convert=('/oracle/oradata/orcl','/oracle/oradata/test')

$ scp inittest.ora oracle@10.10.10.7:/oracle/product/11.2.0/dbhome_1/dbs/

生成辅助实例密码文件

$ orapwd file=$ORACLE_HOME/dbs/orapwtest password=oracle

配置网络

原库监听

$ cat listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)

(SID_NAME = orcl)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.8)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXPROC0))

)

$ cat tnsnames.ora

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.8)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ORCL)

)

TEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.7)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = TEST)

)

配置新库监听

$ cat listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = test)

(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)

(SID_NAME = test)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.7)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXPROC0))

)

分别重启监听:

$ lsnrctl reload

在主库测试下:

$ tnsping test

$ tnsping orcl

启动新库到nomount:

$ export ORACLE_SID=test

$ sqlplus / as sysdba

SQL> startup nomount

主库操作

$ rman target sys/oracle@orcl auxiliary sys/oracle@test

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 19 10:36:09 2018

connected to target database: ORCL (DBID=1516310366)

connected to auxiliary database: TEST (not mounted)

RMAN> duplicate target database to "test";

验证克隆的结果

$ export ORACLE_SID=test

$ sqlplus / as sysdba

SQL> select name,dbid,open_mode from v$database; -->使用了与之前数据库不同的dbid

NAME DBID OPEN_MODE

--------- ---------- --------------------

TEST 2292457546 READ WRITE