Oracle10gPhysicalDataGuard搭建详细过程(五)

2014-11-24 16:55:49 · 作者: · 浏览: 2
alter system set log_archive_config='dg_config=(dbserver,standby)';


System altered.


SQL> alter system set log_archive_dest_state_1=enable;


System altered.


SQL> alter system set log_archive_dest_state_2=enable;


System altered.


SQL> alter system set log_archive_max_processes=10;


System altered.


SQL> alter system set fal_server=standby;


System altered.


SQL> alter system set fal_client=dbserver;


System altered.


SQL> alter system set standby_file_management=auto;


System altered.


SQL> alter system set db_unique_name='dbserver' scope=spfile;


System altered.


SQL> alter system set db_file_name_convert='/u01/app/oracle/oradata/standby','/u01/app/oracle/oradata/dbserver' scope=spfile;


System altered.


SQL> alter system set log_file_name_convert='/u01/app/oracle/oradata/standby','/u01/app/oracle/oradata/dbserver' scope=spfile;


System altered.


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 612368384 bytes
Fixed Size 2085872 bytes
Variable Size 167775248 bytes
Database Buffers 436207616 bytes
Redo Buffers 6299648 bytes
Database mounted.
Database opened.
SQL>


--备份primary db,并且传到standby服务器/bak下
[oracle@vzwc ~]$ rman target /


Recovery Manager: Release 10.2.0.4.0 - Production on Thu Feb 13 23:18:21 2014


Copyright (c) 1982, 2007, Oracle. All rights reserved.


connected to target database: DBSERVER (DBID=66428446)


RMAN> run{
2> allocate channel c1 type disk;
3> backup database format '/bak/%U';
4> release channel c1;
5> }


using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=519 devtype=DISK


Starting backup at 13-FEB-14
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/dbserver/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/dbserver/sysaux01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/dbserver/zwc.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/dbserver/example01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/dbserver/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/dbserver/users01.dbf
channel c1: starting piece 1 at 13-FEB-14
channel c1: finished piece 1 at 13-FEB-14
piece handle=/bak/0lp0i94b_1_1 tag=TAG20140213T231939 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:36
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 13-FEB-14
channel c1: finished piece 1 at 13-FEB-14
piece handle=/bak/0mp0i95f_1_1 tag=TAG20140213T231939 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 13-FEB-14


released channel: c1


RMAN>


Recovery Manager complete.
[oracle@vzwc ~]$ scp -rp /bak/* oracle@192.168.1.6:/bak
oracle@192.168.1.6's password:
0lp0i94b_1_1 100% 635MB 39.7MB/s 00:16
0mp0i95f_1_1 100% 7232KB 7.1MB/s 00:00
[oracle@vzwc ~]$




--克隆duplicate standby db
[oracle@vzwc ~]$ rman target / auxiliary sys/oracle@standby


Recovery Manager: Release 10.2.0.4.