oracle 10 dataguard rman duplicate

说明：oracle 11g dataguard 可以直接用rman duplicate全盘复制，10g的rman duplicate 就just so so 了。
这里把步骤理一下：
主库生成口令文件，改下归档路径，生成pfile：

SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;

SQL> alter system set log_archive_dest_2='service=standby lgwr valid_for=(online_logfiles,primary_role) db_unique_name=standby';

SQL> alter system set log_archive_dest_1='location=/data/arch1' scope=spfile;

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

orapwd file=orapwwhty ignorecase=y password=oracle

备份数据库和控制文件

RMAN> backup database format '/home/oracle/%u';

SQL>alter database create standby controlfile as '/home/oracle/control.ctl';

增加standby redo log

ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;

启动duplicate
rman target / auxiliary sys/"oracle"@standby
duplicate target database for standby nofilename check;
备库：

修改pfile,如果打开好审计，注意关闭audit

*.audit_file_dest='/opt/admin/standby/adump'

*.audit_trail=NONE

*.background_dump_dest='/opt/admin/standby/bdump'

*.compatible='10.2.0.5.0'

*.control_files='/data/standby/control01.ctl'

*.core_dump_dest='/opt/admin/standby/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='whty'

*.db_unique_name='standby'

*.fal_client='standby'

*.fal_server='whty'

*.db_recovery_file_dest='/data/flash_recovery_area'

*.db_recovery_file_dest_size=4294967296

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

*.job_queue_processes=10

*.log_archive_dest_1='location=/data/arch1'

*.log_archive_dest_2='location=/data/arch2 valid_for=(standby_logfiles,standby_role) db_unique_name=standby'

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

*.open_cursors=300

*.pga_aggregate_target=67108864

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=203423744

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/opt/admin/standby/udump'

SQL> startup nomount
ORACLE instance started.

Total System Global Area 205520896 bytes
Fixed Size                  2095088 bytes
Variable Size              75499536 bytes
Database Buffers          121634816 bytes
Redo Buffers                6291456 bytes
SQL> alter database mount standby database;
还原数据库
启动应用进程
SQL> alter database recover managed standby database disconnect from session;
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;
检查应用情况
SQL> select process,status,sequence#,blocks,block# from v$managed_standby;
SQL>alter database recover managed standby database cancel
SQL>alter database open;
SQL> recover managed standby database using current logfile disconnect from session;

posted on 2013-07-30 11:51 snowhill 阅读(471) 评论(0) 编辑收藏引用所属分类: 数据库-oracle

只有注册用户登录后才能发表评论。


相关文章: sqlserver 2005自定义数据类型 ASM文件管理amdu/dd linux添加一个节点 (oracle 11.2.0.4) oracle中的行迁移 Oracle 11.2.0.3 RAC环境ORA-12012 oracle 11.2.0.3.8 rac升级 oracle 性能调整的另外一些方法 oracle 执行计划之v$sql_plan 对expdp诊断 oracle 10g asm 文件copy--dbms_file_transfer包

网站导航: 博客园 IT新闻 BlogJava 知识库博问管理

2024年4月

日

一

二

三

四

五

六

公告

又一年...........

留言簿(3)

随笔分类(13)

文章分类(131)

文章档案(124)

c++

java

linux

oracle

51cto
数据库居多，以后发文章都往51cto 上发了
oracle 11.2
oracle 12.1
oracle 9i reference
oracle白皮书
orcle 10.2
老熊的三分地