纸上得来终觉浅，绝知此事要躬行

进一步认识dataguard-(2)

上一篇 / 下一篇  2008-05-24 11:23:40 / 个人分类：oracle管理

查看( 29 ) / 评论( 0 ) / 评分( 0 / 0 )

1.    用rman创建dataguard(最大性能模式）

1.1    强制启用日志

SQL> ALTER DATABASE FORCE LOGGING;

1.2   备份控制文件

在primary上执行如下命令，创建standby的控制文件。

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/control01.ctl';

 

1.3   修改standby上的初始化参数文件。加入如下参数：

log_archive_start=TRUE
standby_archive_dest='/oradata/backup_data/archivelog’
db_file_name_convert=('/disk1/oracle/oradata/payroll/', 
'/disk1/oracle/oradata/payroll/standby/')
log_file_name_convert=('/disk1/oracle/oradata/payroll/',
'/disk1/oracle/oradata/payroll/standby/')
log_archive_dest_1=('LOCATION=/oradata/backup_data/archivelog/')
standby_file_management=AUTO
remote_archive_enable=TRUE

 

1.4    配置primary和standby上监听服务和tnsname

 

 

1.5   在standby上启动standby实例

SQL> STARTUP NOMOUNT

 

1.6   启动rman，连接到主数据库和standby数据库。

rman target /AUXILIARY SYS/oracle@stdby

1.7   创建standby数据库

[oracle@ora-as4 rman_bk]$ rman target / AUXILIARY SYS/oracle@stdby

 

Recovery Manager: Release9.2.0.4.0 - Production

 

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

 

connected to target database: PROD (DBID=66999320)

connected to auxiliary database: prod (not mounted)

 

RMAN> LIST BACKUP OF CONTROLFILE;

LIST COPY OF CONTROLFILE;

RUN

{

 SET NEWNAME FOR DATAFILE 1 TO '/oracle/oradata/stdby/system01.dbf';

 SET NEWNAME FOR DATAFILE 2 TO '/oracle/oradata/stdby/undo01.dbf';

 DUPLICATE TARGET DATABASE FOR STANDBY

   DORECOVER;

}

1.8      启动standby数据库，并启动到恢复状态

SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASEMOUNTSTANDBYDATABASE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
 

 

1.9  修改primary数据库参数

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=ebank2' SCOPE=BOTH;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

1.10      在standby数据库上验证

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
  FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

 

1.11      验证归档日志是否被应用

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG
  ORDER BY SEQUENCE#;

 

using target database controlfile instead of recovery catalog

                                          

List of Backup Sets

===================

 

BS Key TypeLVSize      Device Type Elapsed Time Completion Time

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

2      Full   6M        DISK       00:02:24    20-MAY-08     

 Controlfile Included: Ckp SCN: 128103      Ckp time: 20-MAY-08

 

 Backup Set Copy #1 of backup set 2

 Device Type Elapsed Time Completion Time Tag

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

 DISK       00:02:24    20-MAY-08      TAG20080520T093245

 

   List of Backup Pieces for backup set 2 Copy #1

   BP Key Pc# Status     Piece Name

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

   6      1  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_1

   7      2  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_2

   8      3  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_3

   9      4  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_4

   10     5  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_5

   11     6  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_6

   12     7  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_7

   13     8  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_8

   14     9  AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_9

   15     10 AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_10

   16     11 AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_11

   17     12 AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_12

   18     13 AVAILABLE  /oracle/rman_bk/2/b2c20_02jgr95t_2_13

 

RMAN>

 

List of Controlfile Copies

Key    S Completion Time Ckp SCN   Ckp Time       Name

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

2      A20-MAY-08      107394    20-MAY-08      /tmp/control01.ctl

1      A19-MAY-08      8415      19-MAY-08      /oracle/control01.ctl

 

RMAN> 2> 3> 4> 5> 6> 7>

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

Starting Duplicate Db at 20-MAY-08

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: sid=13 devtype=DISK

 

printing stored script. Memory Script

{

  restore clone standby controlfile to clone_cf;

  replicate clone controlfile from clone_cf;

  sql clone 'alter database mount standby database';

}

executing script. Memory Script

 

Starting restore at 20-MAY-08

 

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: restoring controlfile

output filename=/oracle/oradata/stdby/control01.ctl

channel ORA_AUX_DISK_1: copied controlfile copy

input filename=/tmp/control01.ctl

output filename=/oracle/oradata/stdby/control01.ctl recid=0 stamp=0

Finished restore at 20-MAY-08

 

replicating controlfile

input filename=/oracle/oradata/stdby/control01.ctl

output filename=/oracle/oradata/stdby/control02.ctl

 

sql statement: alter database mount standby database

 

printing stored script. Memory Script

{

  set until scn 128159;

  set newname for datafile 1 to

 "/oracle/oradata/stdby/system01.dbf";

  set newname for datafile 2 to

 "/oracle/oradata/stdby/undo01.dbf";

  restore

  check readonly

  clone database

  ;

}

executing script. Memory Script

 

executing command: SET until clause

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

Starting restore at 20-MAY-08

 

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00002 to /oracle/oradata/stdby/undo01.dbf

channel ORA_AUX_DISK_1: restored backup piece 1

piece handle=/oracle/rman_bk/1/b2c20_01jgr95t_1_1 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 2

piece handle=/oracle/rman_bk/1/b2c20_01jgr95t_1_2 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 3

piece handle=/oracle/rman_bk/1/b2c20_01jgr95t_1_3 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 4

piece handle=/oracle/rman_bk/1/b2c20_01jgr95t_1_4 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 5

piece handle=/oracle/rman_bk/1/b2c20_01jgr95t_1_5 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restore complete

channel ORA_AUX_DISK_1: starting datafile backupset restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /oracle/oradata/stdby/system01.dbf

channel ORA_AUX_DISK_1: restored backup piece 1

piece handle=/oracle/rman_bk/2/b2c20_02jgr95t_2_1 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 2

piece handle=/oracle/rman_bk/2/b2c20_02jgr95t_2_2 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 3

piece handle=/oracle/rman_bk/2/b2c20_02jgr95t_2_3 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 4

piece handle=/oracle/rman_bk/2/b2c20_02jgr95t_2_4 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 5

piece handle=/oracle/rman_bk/2/b2c20_02jgr95t_2_5 tag=TAG20080520T093245 params=NULL

channel ORA_AUX_DISK_1: restored backup piece 6

piece handle=/oracle/rman_bk/2/b2c20_02jgr95t_2_6 tag=TAG20080520T093245 params=NULL

导入论坛 引用链接 收藏 分享给好友 推荐到圈子 管理 举报

TAG:

 

评分：0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-10-14  
日 一 二 三 四 五 六
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 2276
  • 日志数: 78
  • 图片数: 2
  • 影音数: 1
  • 建立时间: 2008-02-29
  • 更新时间: 2008-10-13

RSS订阅

Open Toolbar