Stage-4 Performing a Oracle Data Guard Switchover Using DGMGRL Step1:-Check the Primary Database Check both side select name,open_mode,database_role,protection_level from v$database; Standby side SELECT ARCH.THREAD# “Thread”, ARCH.SEQUENCE# “Last Sequence Received”, APPL.SEQUENCE# “Last Sequence Applied”, (ARCH.SEQUENCE# – APPL.SEQUENCE#) “Difference”FROM(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,(SELECT THREAD# ,SEQUENCE# […]
Read MoreStage-1 How to Create a Physical Standby Database using Backup PiecesHigh Level Steps Goal : How to Create Physical Standby Database using RMAN Backup With Duplicate Command SQL> startupORACLE instance started.Total System Global Area 2432696320 bytesFixed Size 8623592 bytesVariable Size 654314008 bytesDatabase Buffers 1761607680 bytesRedo Buffers 8151040 bytesDatabase mounted.Database opened. SQL> alter database force logging; […]
Read MoreStage-3 How To Create An Oracle 12c Data Guard Active Standby Database Primary Database Name indiaStandby Database name China Step:1 Enable Archive log mode and Flashback on Flashback database is highly recommended because in case of failover, you need not re-create primary database from scratch shut immediatestartup mountalter database archive log;alter database flashback on; Step:2 […]
Read MoreRMAN BACKUP STATUS set linesize 500 pagesize 2000 col Hours format 9999.99 col input_type for a20 col STATUS format a10 col RMAN_Bkup_start_time for a20 col RMAN_Bkup_end_time for a20 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_start_time, to_char(END_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_end_time, elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS order by session_key; Database backups RMAN> BACKUP DATABASE; RMAN> BACKUP DATABASE […]
Read MoreWe are aspiring technology services company, specializing in Software Development, Database Consulting, and Digital Solutions. With a passion for innovation, We empower businesses to thrive in the digital age, providing tailored solutions that drive growth and efficiency.”
Read More