1 active standby and flash back

    先关2节点：
    ssh dr-db-cal2
    export ORACLE_SID=yyzf2
    dba
    shut immediate;


    确认备库 flashback on 
    select flashback_on from v$database;
        如为NO
        recover managed standby database cancel;
        ALTER DATABASE FLASHBACK ON;
        重新应用：
        alter database recover managed standby database using current logfile disconnect from session;

    备库确认：
    set linesize 1000;
    SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, DELAY_MINS FROM V$MANAGED_STANDBY;
    MRP0 为applying_log


    select flashback_on from v$database;

    recover managed standby database cancel;
    创建快照点：
    CREATE RESTORE POINT back_to_here GUARANTEE FLASHBACK database;

    激活standby数据库：
    ALTER DATABASE ACTIVATE STANDBY DATABASE;
    STARTUP  FORCE;
    或者
    alter database recover managed standby database finish force;
    alter database commit to switchover to primary;

    验证:
    select open_mode from V$database;
    提供读写服务：
    OOOOXXXX

    重新置为standby数据库：
    STARTUP MOUNT FORCE;
    FLASHBACK DATABASE TO RESTORE POINT back_to_here;
    ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
    STARTUP MOUNT FORCE;

    删掉restore point：
    drop restore point back_to_here;
    alter database open
    同时开启2节点
    startup

当物理备库standby open打开报错要求恢复时，用下面recover语句
recover automatic standby database;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION parallel 2; 
确认DG状态：
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, DELAY_MINS FROM V$MANAGED_STANDBY;

2 rebuild

备库
export ORACLE_SID=yyzf1
dba
startup nomount pfile='/home/oracle/p' force;


主库：
rman target / auxiliary sys/xxxxxx@yyzfbk


duplicate target database
for standby
from active database
DORECOVER
spfile
set db_unique_name='yyzfbk'
set log_archive_dest_1='location=/arch/yyzf1 valid_for=(all_logfiles,all_roles) db_unique_name=yyzfbk'
set log_archive_dest_2='service=yyzf  async valid_for=(online_logfiles,primary_role) db_unique_name=yyzf'
set standby_file_management='AUTO'
set fal_client='yyzfbk'
set audit_file_dest='/opt/oracle/admin/yyzf/adump'
set log_file_name_convert='+YYZF_REDODG/yyzf','+REDODG/yyzfbk/'
set db_recovery_file_dest='+FLASHDG'
set db_recovery_file_dest_size='157286400000'
set db_file_name_convert='+YYZF_DATADG/yyzf','+FLASHDG/yyzfbk/'
set remote_listener='qdata-scan:1521'
set diagnostic_dest='/opt/oracle'
nofilenamecheck;


备库：

alter system set log_archive_dest_1='location=/arch/yyzf1 valid_for=(all_logfiles,all_roles) db_unique_name=yyzfbk' scope=spfile sid='yyzf1';
alter system set log_archive_dest_1='location=/arch/yyzf2 valid_for=(all_logfiles,all_roles) db_unique_name=yyzfbk' scope=spfile sid='yyzf2';

shu immediate;
startup;
1节点：
recover automatic standby database ;
recover managed standby database using current logfile disconnect;

SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, DELAY_MINS FROM V$MANAGED_STANDBY;

版权声明：本文为博主原创文章，未经博主允许不得转载。