standby database rebuild

disable fast_start failover;
disable configuration;

EDIT CONFIGURATION SET PROTECTION MODE AS MaxPerformance;

--duplicate database : for standby database
/home/oracle/DBA/dgrmanconfig.sql

enable configuration;

startup mount;
alter database flashback on;

EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;

enable fast_start failover;

$ rman target sys/oraclego@tomatosb catalog rman/rmann@suica

RMAN> run {

startup nomount;

restore database;

restore controlfile;

alter database mount;

recover database;

alter database flashback on;

}

SQL> alter database open;

SQL> RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

DGMGRL> enable fast_start failover;

--tomatosbを STANDBY 再構築

PRIMARY

alter database create standby controlfile as '/oracle/oradata/stby.ctl';

scp stby.ctl suica-2:/oracle/oradata/SUICASB/control01.ctl

scp stby.ctl suica-2:/oracle/oradata/SUICASB/control02.ctl

STBY

SQL> startup nomount -> rman에서하지말것

rman target sys/oraclego@suicapr catalog rman/rmann@tomato

connect auxiliary sys/oraclego@suicasb

run {

duplicate target database for standby from active database;

}

SQL> alter database flasthback on

SQL> alter database open;

SQL> RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

DGMGRL> enable fast_start failover;

Database