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.
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.