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: Release 9.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;

}

SQL> STARTUP NOMOUNT;

SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

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

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME

   FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

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  Type LV Size       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       A 20-MAY-08       107394     20-MAY-08       /tmp/control01.ctl

1       A 19-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

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