Oracle 11gR2利用RMAN复制整库记录

Oracle 11gR2利用RMAN复制整库记录源端和目标端配置好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）
）
）源库创建pfileSQL> create pfile="/home/oracle/pfile.ora" from spfile;File created.将源库的pfile、listener、tnsname、orapw文件传输到目标库的指定位置并加以修改[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 bytesFixed Size 2232368 bytesVariable Size 2936016848 bytesDatabase Buffers 922746880 bytesRedo 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 copyinput datafile copy RECID=31 STAMP=886273519 file name=/u01/app/oracle/oradata/testhisnew/test27.dbfdatafile 33 switched to datafile copyinput datafile copy RECID=32 STAMP=886273519 file name=/u01/app/oracle/oradata/testhisnew/testdeltable01.dbfcontents of Memory Script:{ Alter clone database open resetlogs;}executing Memory Scriptdatabase openedFinished Duplicate Db at 28-JUL-15.复制完成后启动关闭目标库，验证是否复制成功，并观察alter日志是否有报错日志，确认无误后及时做全库备份。--------------------------------------推荐阅读 --------------------------------------RMAN备份时遭遇ORA-19571 http://www.linuxidc.com/Linux/2015-07/120409.htmRMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址