ITPub博客

首页 > 数据库 > Oracle > 11gR2利用RMAN复制整库记录

11gR2利用RMAN复制整库记录

原创 Oracle 作者:静以致远√团团 时间:2015-07-29 14:28:04 0 删除 编辑

源端和目标端配置好TNS和监听(11g动态监听sys无法在nomount状态登入,需配置静态监听)

[oracle@154-Oracle_Archive admin]$ vi tnsnames.ora 

TESTHIS.154 =
  (DESCRIPTION =
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.234.154)(PORT = 1521))
      )
      (CONNECT_DATA =
        (SERVER = DEDICATED)
       (SID = TESTHIS)
       )
    )  

TESTHIS.11 = 
  (DESCRIPTION =
     (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.234.11)(PORT = 1521)) 
      )
      (CONNECT_DATA =
        (SERVER = DEDICATED)
       (SID = testhisnew)
       )
    )

[oracle@154-Oracle_Archive admin]$ vi listener.ora 

# listener.ora Network Configuration File: /opt/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 154-Oracle_Archive.hubs1.pu)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = testhis
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = testhis)
    )
  )
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->

源库创建pfile

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

File created.

 

将源库的pfilelistenertnsnameorapw文件传输到目标库的指定位置并加以修改

[oracle@154-Oracle_Archive admin]$ scp *.ora root@192.168.234.11:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin
root@192.168.234.11's password: 
listener.ora                                                                      100%  619     0.6KB/s   00:00    
tnsnames.ora                                                                      100%  448     0.4KB/s   00:00    

 

[oracle@154-Oracle_Archive ~]$ scp pfile.ora root@192.168.234.11:/home/oracle
root@192.168.234.11's password: 
pfile.ora                                                                         100% 1018     1.0KB/s   00:00

 

[oracle@154-Oracle_Archive dbs]$ scp orapwtesthis root@192.168.234.11:/home/oracle
root@192.168.234.11's password: 
Permission denied, please try again.
root@192.168.234.11's password: 
orapwtesthis                                                                       100% 1536     1.5KB/s   00:00 

[oracle@Oracle_archive ~]$ cp orapwtesthis /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwtesthisnew

 

修改pfile文件

[oracle@Oracle_archive ~]$ vi pfile.ora 
testhisnew.__db_cache_size=922746880
testhisnew.__java_pool_size=33554432
testhisnew.__large_pool_size=16777216
testhisnew.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
testhisnew.__pga_aggregate_target=1358954496
testhisnew.__sga_target=2533359616
testhisnew.__shared_io_pool_size=0
testhisnew.__shared_pool_size=1493172224
testhisnew.__streams_pool_size=33554432
*.audit_file_dest='/u01/app/oracle/admin/testhisnew/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/testhisnew/control01.ctl','/u01/app/oracle/fast_recovery_area/testhisnew/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='testhisne'   //最长8个字符
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testhisnewXDB)'
*.log_archive_dest_1='location=/u01/app/oracle/test_arch'
*.memory_target=3879731200
*.open_cursors=300
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1105
*.undo_tablespace='UNDOTBS1'

 

db_file_name_convert=('/u01/app/oracle/oradata/testhis/','/u01/app/oracle/oradata/testhisnew/')

log_file_name_convert=('/u01/app/oracle/oradata/testhis/','/u01/app/oracle/oradata/testhisnew/')

 

创建相关目录

[oracle@Oracle_archive ~]$ mkdir -p /u01/app/oracle/admin/testhis_n/adump
[oracle@Oracle_archive ~]$ mkdir -p /u01/app/oracle/oradata/testhis_n/
[oracle@Oracle_archive ~]$ mkdir -p /u01/app/oracle/fast_recovery_area/testhis_n/

 

登入数据库创建spfile并启动实例

[oracle@Oracle_archive ~]$ echo $ORACLE_SID
testhisnew
[oracle@Oracle_archive ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 28 16:14:04 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

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

File created.

 

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area 3874926592 bytes

Fixed Size                  2232368 bytes

Variable Size            2936016848 bytes

Database Buffers          922746880 bytes

Redo Buffers               13930496 bytes

 

源端登入两数据库,执行复制

[oracle@154-Oracle_Archive admin]$ rman target sys/******@testhis.154 auxiliary sys/******@testhis.11

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jul 28 17:46:30 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TESTHIS (DBID=1362777844)
connected to auxiliary database: TESTHISNE (not mounted)

RMAN> duplicate target database to testhisne from active database nofilenamecheck;

 

.

.

.

datafile 32 switched to datafile copy

input datafile copy RECID=31 STAMP=886273519 file name=/u01/app/oracle/oradata/testhisnew/test27.dbf

datafile 33 switched to datafile copy

input datafile copy RECID=32 STAMP=886273519 file name=/u01/app/oracle/oradata/testhisnew/testdeltable01.dbf

 

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

 

database opened

Finished Duplicate Db at 28-JUL-15

.

 

复制完成后启动关闭目标库,验证是否复制成功,并观察alter日志是否有报错日志,确认无误后及时做全库备份

 

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

请登录后发表评论 登录
全部评论
每个人都有梦想,去实现吧!

注册时间:2013-11-14

  • 博文量
    164
  • 访问量
    2103471