首页 / 数据库 / MySQL / 【RMAN】使用duplicate本地复制数据库

任务：同一台主机使用RMAN的duplicate复制数据库，linux操作系统中有一套正在运行的数据库enmoedu  复制后的数据库aux 
 
实验步骤：
 
1.     主库RMAN备份
 
[Oracle@test ~]$ export ORACLE_SID=enmoedu
 
[oracle@test ~]$ rman target /
 
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 6 00:43:13 2014
 
Copyright （c） 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: ENMOEDU （DBID=108163061）
 
 
 
RMAN> backup database plus archivelog; 
 
Starting backup at 06-JUN-14
 
using target database control file instead of recovery catalog
 
allocated channel: ORA_DISK_1
 
channel ORA_DISK_1: SID=61 device type=DISK
 
channel ORA_DISK_1: starting full datafile backup set
 
channel ORA_DISK_1: specifying datafile（s） in backup set
 
input datafile file number=00001 name=/11g/app/oracle/oradata/enmoedu/system01.dbf
 
input datafile file number=00002 name=/11g/app/oracle/oradata/enmoedu/sysaux01.dbf
 
input datafile file number=00005 name=/11g/app/oracle/oradata/enmoedu/example01.dbf
 
input datafile file number=00003 name=/11g/app/oracle/oradata/enmoedu/undotbs01.dbf
 
input datafile file number=00006 name=/11g/app/oracle/oradata/enmoedu/pitr.dbf
 
input datafile file number=00007 name=/11g/app/oracle/oradata/enmoedu/pitr_ind.dbf
 
input datafile file number=00008 name=/11g/app/oracle/oradata/enmoedu/index01.dbf
 
input datafile file number=00010 name=/11g/app/oracle/oradata/enmoedu/ts_users_1.dbf
 
input datafile file number=00004 name=/11g/app/oracle/oradata/enmoedu/users01.dbf
 
input datafile file number=00009 name=/11g/app/oracle/oradata/enmoedu/ts_users.dbf
 
input datafile file number=00011 name=/11g/app/oracle/oradata/enmoedu/ts_users1.dbf
 
channel ORA_DISK_1: starting piece 1 at 06-JUN-14
 
channel ORA_DISK_1: finished piece 1 at 06-JUN-14
 
piece handle=/11g/app/backup/db_53pa49ha_1_1.bak tag=TAG20140606T004322 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
 
channel ORA_DISK_1: starting full datafile backup set
 
channel ORA_DISK_1: specifying datafile（s） in backup set
 
including current control file in backup set
 
including current SPFILE in backup set
 
channel ORA_DISK_1: starting piece 1 at 06-JUN-14
 
channel ORA_DISK_1: finished piece 1 at 06-JUN-14
 
piece handle=/11g/app/backup/db_54pa49i3_1_1.bak tag=TAG20140606T004322 comment=NONE
 
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
 
Finished backup at 06-JUN-14
 
 
 
RMAN>quit--------------------------------------------------------------------------------RMAN 配置归档日志删除策略 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.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下 安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm--------------------------------------------------------------------------------
 
 
2.     配置监听文件及tnsnames.ora
 
--监听改静态 listener.ora 因为复制的aux库是nomount状态，pmon是mount的时候去动态注册，所以需要加静态注册。Listener.ora文件修改后：
 
SID_LIST_LISTENER =
 
  （SID_LIST =
 
    （SID_DESC =
 
      （GLOBAL_DBNAME = enmoedu）
 
      （ORACLE_HOME = /11g/app/oracle/product/11.2.0/dbhome）
 
      （SID_NAME = enmoedu）
 
    ）
 
 
 
    （SID_DESC =
 
      （GLOBAL_DBNAME = aux）
 
      （ORACLE_HOME = /11g/app/oracle/product/11.2.0/dbhome）
 
      （SID_NAME = aux）
 
    ）
 
  ）
 
 
 
Tnsnames.ora文件中添加：
 
aux =
 
（DESCRIPTION =
 
    （ADDRESS = （PROTOCOL = TCP）（HOST = 192.168.10.8）（PORT = 1521））
 
    （CONNECT_DATA =
 
      （SERVER = DEDICATED）
 
      （SERVICE_NAME = aux）
 
    ）
 
）
 
 
 
3.     通过enmoedu库的SPFILE生成PFILE，复制PFILE文件，将SID名字更改为aux，并且将文件中参数进行修改。
 
[oracle@test ~]$ sqlplus  / as sysdba
 
SQLPlus Release 11.2.0.3.0 Production on Thu Jun 5 235614 2014
 
Copyright （c） 1982, 2011, Oracle.  All rights reserved.
 
 
 
Connected to
 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
 
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
 
 
SQL select instance_name,status from v$instance;
 
 
 
INSTANCE_NAME    STATUS
 
---------------- ------------
 
enmoedu          OPEN
 
 
 
SQL create pfile from spfile;
 
 
 
File created.
 
 
 
SQLexit
 
 
 
[oracle@test ~]$ cd $ORACLE_HOMEdbs
 
 
 
[oracle@test dbs]$ cp initenmoedu.ora initaux.ora
 
 
 
修改前initaux.ora
 
enmoedu.__db_cache_size=201326592
 
enmoedu.__java_pool_size=4194304
 
enmoedu.__large_pool_size=4194304
 
enmoedu.__oracle_base="/11g/app/oracle"#ORACLE_BASE set from environment
 
enmoedu.__pga_aggregate_target=293601280
 
enmoedu.__sga_target=545259520
 
enmoedu.__shared_io_pool_size=0
 
enmoedu.__shared_pool_size=318767104
 
enmoedu.__streams_pool_size=8388608
 
*._shared_io_pool_size=0
 
*.audit_file_dest="/11g/app/oracle/admin/enmoedu/adump"
 
*.audit_trail="db"
 
*.compatible="11.2.0.0.0"
 
*.control_files="/11g/app/oracle/oradata/enmoedu/control01.ctl","/11g/app/oracle/oradata/enmoedu/control02.ctl"
 
*.db_block_size=8192
 
*.db_cache_size=201326592
 
*.db_create_file_dest=""
 
*.db_domain=""
 
*.db_flashback_retention_target=2880
 
*.db_name="enmoedu"
 
*.db_recovery_file_dest_size=2147483648
 
*.db_recovery_file_dest="/11g/app/backup"
 
*.db_writer_processes=2
 
*.diagnostic_dest="/11g/app/oracle"
 
*.java_pool_size=4194304
 
*.large_pool_size=4194304
 
*.log_archive_format="%t_%s_%r.arc"
 
*.memory_target=0
 
*.open_cursors=300
 
*.pga_aggregate_target=293601280
 
*.processes=300
 
*.remote_login_passwordfile="EXCLUSIVE"
 
*.sga_target=0
 
*.shared_pool_size=318767104
 
*.streams_pool_size=8388608
 
*.undo_tablespace="UNDOTBS1"
 
 
 
 
 
修改后initaux.ora（具体参数可根据自己环境进行调整）标黄色部分为更改项，要建立更改后的路径目录
 
aux.__db_cache_size=201326592
 
aux.__java_pool_size=4194304
 
aux.__large_pool_size=4194304
 
aux.__oracle_base="/11g/app/oracle"#ORACLE_BASE set from environment
 
aux.__pga_aggregate_target=293601280
 
aux.__sga_target=545259520
 
aux.__shared_io_pool_size=0
 
aux.__shared_pool_size=318767104
 
aux.__streams_pool_size=8388608
 
*._shared_io_pool_size=0
 
*.audit_file_dest="/11g/app/oracle/admin/aux/adump"
 
*.audit_trail="db"
 
*.compatible="11.2.0.0.0"
 
*.control_files="/11g/app/oracle/oradata/aux/control01.ctl","/11g/app/oracle/oradata/aux/control02.ctl"
 
*.db_block_size=8192
 
*.db_cache_size=201326592
 
*.db_create_file_dest=""
 
*.db_domain=""
 
*.db_flashback_retention_target=2880
 
*.db_name="aux"
 
*.db_recovery_file_dest_size=2147483648
 
*.db_recovery_file_dest="/11g/app/flashback_aux"
 
*.db_writer_processes=2
 
*.diagnostic_dest="/11g/app/oracle"
 
*.java_pool_size=4194304
 
*.large_pool_size=4194304
 
*.log_archive_format="%t_%s_%r.arc"
 
*.memory_target=0
 
*.open_cursors=300
 
*.pga_aggregate_target=293601280
 
*.processes=300
 
*.remote_login_passwordfile="EXCLUSIVE"
 
*.sga_target=0
 
*.shared_pool_size=318767104
 
*.streams_pool_size=8388608
 
*.undo_tablespace="UNDOTBS1"
 
*.db_file_name_convert="/11g/app/oracle/oradata/enmoedu/","/11g/app/oracle/oradata/aux/"
 
*.log_file_name_convert="/11g/app/oracle/oradata/enmoedu/","/11g/app/oracle/oradata/aux/"更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-07/104640p2.htm

1 2 下一页

Redhat 6 Oracle 11g RAC安装注意事项汇总Linux下如何将数据库脚本文件从sh格式变为sql格式相关资讯      RMAN 

RMAN故障一例（归档的备份，从不  （今 20:42） RMAN的FORMATA格式说明  （03月10日） Oracle 11g RMAN复制数据库的测试  （01月19日）

RMAN数据库迁移  （05月22日） 使用RMAN复制恢复开发库环境  （02月17日） Oracle 11g RMAN跨平台传输表空间  （01月19日）

本文评论 查看全部评论 （0）

表情： 姓名： 匿名字数 <div id="footbar"> 版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a> </div> </div> <script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/cm.js"></script> <script> var _mtj = _mtj || []; (function () { var mtj = document.createElement("script"); mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(mtj, s); })(); </script> </body> </html>