主库为 WENDING  

一．	主库

1、	设置为归档模式
SQL>alter database force logging

2、	强制归档

SQL> archive log list
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> archive log list

修改监听文件

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/10.2.0/)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (ORACLE_HOME = /u01/oracle/product/10.2.0/)
      (SID_NAME = WENDING)
    )
  )


3、	配置tns文件

WENDING =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = wending)
    )
  )

PHYSTDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = phystdby)
    )
    )
4、	执行rman备份

mkdir –p  /u01/oradata/WENDING/backup
rman nocatalog target sys/oracle@WENDING
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/u01/oradata/WENDING/backup/%F';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT 'sys/oracle@WENDING';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/u01/oradata/WENDING/backup/snapcf_PRIMARY.f';

BACKUP FORMAT '/u01/oradata/WENDING/backup/%d_D_%T_%u_s%s_p%p' DATABASE;

为standby数据库创建控制文件

BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT '/u01/oradata/WENDING/backup/%d_C_%U';
SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
BACKUP FILESPERSET 10 ARCHIVELOG ALL FORMAT '/u01/oradata/WENDING/backup/%d_A_%T_%u_s%s_p%p';

5、	修改核心参数

ALTER SYSTEM SET db_unique_name = WENDING SCOPE = SPFILE;
ALTER SYSTEM SET log_archive_dest_1 ='LOCATION=/u01/oradata/WENDING/arch' SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_2 = 'SERVICE=PHYSTDBY VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PHYSTDBY' SCOPE=SPFILE;
ALTER SYSTEM SET fal_client = WENDING SCOPE = SPFILE;
ALTER SYSTEM SET fal_server = PHYSTDBY SCOPE = SPFILE;
ALTER SYSTEM SET standby_file_management = AUTO SCOPE = SPFILE;

6、	重启实例


二．	备库

1、	创建目录
 mkdir -p $ORACLE_BASE/admin/ORCLDB
 mkdir -p $ORACLE_BASE/admin/ORCLDB/adump
 mkdir -p $ORACLE_BASE/admin/ORCLDB/bdump
 mkdir -p $ORACLE_BASE/admin/ORCLDB/cdump
 mkdir -p $ORACLE_BASE/admin/ORCLDB/dpdump
 mkdir -p $ORACLE_BASE/admin/ORCLDB/pfile
 mkdir -p $ORACLE_BASE/admin/ORCLDB/udump
 
  将主库备份的文件复制到 相应的目录
 
 mkdir -p /u01/oradata/WENDING
 mkdir -p /u01/oradata/WENDING/arch
 mkdir -p /u01/oradata/WENDING/backup;


2、	创建主库密码文件
  $ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwWENDING password=oracle 

3、	将spfile从主库复制到备库
  scp dg1:$ORACLE_HOME/dbs/spfileWENDING.ora dg2:$ORACLE_HOME/dbs

4、	配置tns文件

WENDING =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = wending)
    )
  )

PHYSTDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = phystdby)
    )
    )



5、	修改监听器
SID_LIST_LISTENER_SERVER4 =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
(SID_NAME = WENDING)
)
)

6、	重启监听
lsnrctl reload

重要：网络测试和密码文件测试：
首先要在两台机器上互相tnsping 对方 看看是否能ping通
在WENDING主机上执行：tnsping  PHYSTDBY   显示为OK表示正确
在PHYSTDBY 主机上执行 tnsping  WENDING

第二步 测试密码文件 在主机上 用tns里的名称登陆
sqlplus sys/oracle@PHYSTDBY as sysdba
在备机上测试登陆
sqlplus sys/oracle@WENDING as sysdba

能够互相登陆 则正确！


7、	启数据库为nomount
export ORACLE_SID=WENDING
$ sqlplus / as sysdba
SQL> startup nomount

8、	修改核心参数
ALTER SYSTEM SET db_unique_name = PHYSTDBY SCOPE = SPFILE;
ALTER SYSTEM SET log_archive_dest_1 ='LOCATION=/u01/oradata/WENDING/arch' SCOPE = SPFILE;
ALTER SYSTEM SET log_archive_dest_2 = 'SERVICE=WENDING VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=WENDING' SCOPE=SPFILE;
ALTER SYSTEM SET fal_client = PHYSTDBY SCOPE = SPFILE;
ALTER SYSTEM SET fal_server = WENDING SCOPE = SPFILE;
ALTER SYSTEM SET standby_file_management = AUTO SCOPE = SPFILE;

9、	重启数据库
SQL> startup nomount




在主库
执行rman 连接到备库
SQL> startup mount
$ORACLE_HOME/bin/rman NOCATALOG TARGET / AUXILIARY sys/oracle@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg2)(PORT=1521))(CONNECT_DATA=(SID=WENDING)))"

注意此时主库必须是关闭状态
RMAN-05001: auxiliary filename 
错误原因，主库和从库目录结构一致，为防止异常覆盖，出以上报错==============
可以用duplicate target database for standby nofilenamecheck;方法解决

克隆数据库到备库
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY DORECOVER nofilenamecheck ;

在备库
重启为nomount
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP NOMOUNT

Mount克隆数据库
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

启动恢复
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;


切换逻辑dg


关闭恢复
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;


在主库
修改logarchive_dest2参数
SQL> ALTER SYSTEM SET log_archive_dest_2 = 'SERVICE=READING VALID_FOR=(ONLINE_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=READING' SCOPE=SPFILE;
执行对象重建
SQL> EXECUTE LOGSTDBY.BUILD;

在备库上：
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY standby;
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> ALTER DATABASE START LOGICAL STANDBY APPLY;