hook up with rman to construct standby .. i’ve related from the first server
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;
Standby aspect :
allow the flashback , shutdown the database and startup in mount then begin the MRP .
major :
On Standby Server
=================
alter database flashback on;
shut rapid;
startup mount;
alter database get well managed standby database disconnect;
choose course of, standing, sequence# from v$managed_standby;
choose sequence#, utilized, first_time, next_time, identify filename from v$archived_log order by sequence#;
major aspect :
SQL> choose identify,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
RPROD READ WRITE PRIMARY
SQL> choose course of, standing, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
——— ———— ———-
ARCH CLOSING 7
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CLOSING 8
ARCH CLOSING 9
LNS OPENING 7
DGRD ALLOCATED 0
LNS WRITING 10
9 rows chosen.
SQL> choose sequence#, utilized, first_time, next_time, identify filename from v$archived_log order by sequence#;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
———- ——— ——— ———
FILENAME
——————————————————————————–
5 NO 30-SEP-24 30-SEP-24
/u01/Backup/RPROD/archivelog/2024_09_30/o1_mf_1_5_mhoyfhz4_.arc
6 NO 30-SEP-24 30-SEP-24
/u01/Backup/RPROD/archivelog/2024_09_30/o1_mf_1_6_mhp0spjc_.arc
7 NO 30-SEP-24 30-SEP-24
/u01/app/oracle/fast_recovery_area/RPROD/archivelog/2024_09_30/o1_mf_1_7_mhp4r56
n_.arc
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
———- ——— ——— ———
FILENAME
——————————————————————————–
8 NO 30-SEP-24 30-SEP-24
/u01/app/oracle/fast_recovery_area/RPROD/archivelog/2024_09_30/o1_mf_1_8_mhp4s8w
1_.arc
9 NO 30-SEP-24 30-SEP-24
/u01/app/oracle/fast_recovery_area/RPROD/archivelog/2024_09_30/o1_mf_1_9_mhp4s92
1_.arc
SQL> alter system swap log;
alter system swap log
*
ERROR at line 1:
ORA-01900: LOGFILE key phrase anticipated
SQL> alter system swap logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> choose course of, standing, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
——— ———— ———-
ARCH CLOSING 7
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CLOSING 10
ARCH CLOSING 11
ARCH CLOSING 12
LNS WRITING 13
DGRD ALLOCATED 0
DGRD ALLOCATED 0
9 rows chosen.
SQL> alter system swap logfile;
System altered.
Standby Aspect :
——————–
SQL> alter database flashback on;
Database altered.
SQL> choose identify,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
RPROD MOUNTED PHYSICAL STANDBY
SQL> shut rapid;
startup mount;
ORA-01109: database not open
Database dismounted.
ORACLE occasion shut down.
SQL>
ORACLE occasion began.
Whole System International Space 1795159104 bytes
Mounted Dimension 8897600 bytes
Variable Dimension 419430400 bytes
Database Buffers 1358954496 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL> SQL>
SQL>
SQL> choose identify,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
RPROD MOUNTED PHYSICAL STANDBY
SQL> choose course of, standing, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
——— ———— ———-
ARCH CONNECTED 0
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
RFS IDLE 0
RFS IDLE 10
8 rows chosen.
SQL> alter database get well managed standby database disconnect;
Database altered.
SQL> choose course of, standing, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
——— ———— ———-
ARCH CONNECTED 0
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
RFS IDLE 0
RFS IDLE 10
MRP0 APPLYING_LOG 10
9 rows chosen.
SQL> choose course of, standing, sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
——— ———— ———-
ARCH CLOSING 11
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CLOSING 12
ARCH CLOSING 10
ARCH CONNECTED 0
RFS IDLE 0
RFS IDLE 13
MRP0 APPLYING_LOG 13
9 rows chosen.
SQL> /
PROCESS STATUS SEQUENCE#
——— ———— ———-
ARCH CLOSING 13
DGRD ALLOCATED 0
DGRD ALLOCATED 0
ARCH CLOSING 12
ARCH CLOSING 10
ARCH CONNECTED 0
RFS IDLE 0
RFS IDLE 14
MRP0 APPLYING_LOG 14
9 rows chosen.
