This article describes the setup of the DataGuard and Observer, in Maxavailability mode and with Fail Over about to be activated.<\/p>\n
<\/p>\n
If there’s going to be a Standby setup in a operational Data Guard environment then the standby logs need to be checked<\/span><\/p>\n <\/p>\n For large databases it is recommended starting up before opening the backup settings.<\/p>\n Adding the following aliases to \/home\/oracle\/.bash_profile<\/span><\/strong> makes the installation process easier.<\/span> alias admin=’cd \/u01\/app\/oracle\/admin\/’<\/p>\n alias dbs=’cd \/u01\/app\/oracle\/product\/10g\/dbs’<\/p>\n alias sql=’sqlplus “\/ as sysdba”‘<\/p>\n alias network=’cd \/u01\/app\/oracle\/product\/10g\/network\/admin’<\/p>\n alias alert=’tail -200f \/u01\/app\/oracle\/admin\/FSM\/bdump\/alert_FSM.log ‘[\/crayon]<\/p>\n The Primary DB should be in Archive Log mode. alter system set LOG_ARCHIVE_FORMAT=’%t_%s_%r.arc’ scope=spfile;<\/p>\n shutdown immediate<\/p>\n startup mount<\/p>\n alter database archivelog<\/p>\n [\/crayon]<\/p>\n Primary DB should have Flashback active. startup mount;<\/p>\n alter database flashback on;<\/p>\n alter database open;<\/p>\n SELECT flashback_on, log_mode FROM v$database;<\/p>\n SELECT flashback_on, log_mode FROM v$database;<\/p>\n FLASHBACK_ON LOG_MODE<\/p>\n —————— ———————<\/p>\n YES ARCHIVELOG<\/p>\n [\/crayon]<\/p>\n [crayon]Force Logging should be active.<\/p>\n ALTER DATABASE FORCE LOGGING;<\/p>\n SELECT force_logging FROM v$database;<\/p>\n FOR<\/p>\n —<\/p>\n YES<\/p>\n [\/crayon]<\/p>\n Standby DB.<\/p>\n Load only the RDBMS and patches. The standby db has the same rights and folder ownership as the Primary, however it hasn’t been created yet.<\/p>\n Primary<\/strong><\/p>\n Oracle_Unique_Name FSM_DG1<\/p>\n Standby<\/strong><\/p>\n Oracle_Unique_Name FSM_DG2<\/p>\n <\/p>\n Create the Standby Redologs in the Primary. (Whatever has been added to the Primary should also be added to the Standby.) ALTER DATABASE DROP STANDBY LOGFILE GROUP 5;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 6;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 7;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 8;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 9;<\/p>\n — adding a single standby log<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log01_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log02_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log03_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log04_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log05_1.log’) SIZE 100M reuse;<\/p>\n — adding a multi-user standby log<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log01_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log01_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log02_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log02_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log03_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log03_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log04_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log04_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log05_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log05_2.log’) SIZE 100M reuse;<\/p>\n [\/crayon]<\/p>\n The following changes need to be made in the Primary DB’s pfile. These changes should then be copied to a spfile and the database opened with the spfile. ALTER SYSTEM SET FAL_CLIENT=’FSM_DG1′ SCOPE=SPFILE;<\/p>\n ALTER SYSTEM SET FAL_SERVER=’FSM_DG2′ SCOPE=SPFILE;<\/p>\n ALTER SYSTEM SET Log_archive_config=’DG_CONFIG=(FSM_DG1,FSM_DG2)’ SCOPE=SPFILE;<\/p>\n Alter system set Log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/archive\/FSM<\/p>\n VALID_FOR=(ALL_LOGFILES,ALL_ROLES)<\/p>\n db_unique_name=FSM_DG1′<\/p>\n Alter system set Log_archive_dest_2=’Service=FSM_DG2 lgwr async<\/p>\n VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)<\/p>\n db_unique_name=FSM_DG2′<\/p>\n Alter system set Standby_File_Management=’AUTO’ scope=spfile;<\/p>\n Alter system set LOG_ARCHIVE_MAX_PROCESSES=30 scope=spfile;<\/p>\n shutdown immediate<\/p>\n startup<\/p>\n [\/crayon] *.db_unique_name=’FSM_DG1′<\/p>\n *.FAL_Client=’FSM_DG1′ —–>Primary DB unique name<\/p>\n *.FAL_Server=’FSM_DG2′ —–>StandBY DB unique name<\/p>\n *.Log_archive_config=’DG_CONFIG=(FSM_DG1,FSM_DG2)’ —–> (Primary DB unique name,StandBY DB unique name)<\/p>\n *.Log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/archive\/FSM<\/p>\n VALID_FOR=(ALL_LOGFILES,ALL_ROLES)<\/p>\n db_unique_name=FSM_DG1′ —–> (Primary DB unique name,StandBY DB unique name)<\/p>\n *.Log_archive_dest_2=’Service=FSM_DG2 lgwr async —–>(StandBY DB unique name)<\/p>\n VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)<\/p>\n db_unique_name=FSM_DG2′ —–>(StandBY DB unique name)<\/p>\n *.Log_archive_dest_state_1=’ENABLE’<\/p>\n *.Log_archive_dest_state_2=’ENABLE’<\/p>\n *.Standby_File_Management=’AUTO’<\/p>\n *.LOG_ARCHIVE_MAX_PROCESSES=30[\/crayon]<\/p>\n Make the necessary folders in the Standby DB. Any missing folders would result in this error message “ORA-07446: sdnfy: bad value ” for parameter”. mkdir -p \/u01\/app\/oracle\/admin\/FSM\/bdump<\/p>\n mkdir -p \/u01\/app\/oracle\/admin\/FSM\/cdump<\/p>\n mkdir -p \/u01\/app\/oracle\/admin\/FSM\/udump<\/p>\n mkdir -p \/u01\/app\/oracle\/archive\/FSM<\/p>\n [\/crayon]<\/p>\n Creating the following pfile for the StandBy. Make it in the Primary and send it to $ORACLE_HOME\/dbs<\/strong> in the Standby. scp initFSM.ora sdb:\/u01\/app\/oracle\/product\/10g\/dbs\/<\/p>\n [\/crayon]<\/p>\n Make the following changes in initFSM.ora<\/strong> in the Standby server. *.db_unique_name=’FSM_DG2′<\/p>\n *.FAL_Client=’FSM_DG2′ —–>StandBY DB unique name<\/p>\n *.FAL_Server=’FSM_DG1′ —–>Primary DB unique name<\/p>\n [\/crayon]<\/p>\n [crayon]*.Log_archive_config=’DG_CONFIG=(FSM_DG1,FSM_DG2)’ —–> (Primary DB unique name,StandBY DB unique name)<\/p>\n *.Log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/archive\/FSM<\/p>\n VALID_FOR=(ALL_LOGFILES,ALL_ROLES)<\/p>\n db_unique_name=FSM_DG2′ —–> (Primary DB unique name,StandBY DB unique name)<\/p>\n [\/crayon]<\/p>\n [crayon]*.Log_archive_dest_2=’Service=FSM_DG1 lgwr async —–>StandBY DB unique name<\/p>\n VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)<\/p>\n db_unique_name=FSM_DG1′ —–>StandBY DB unique name<\/p>\n [\/crayon]<\/p>\n [crayon]*.Log_archive_dest_state_1=’ENABLE’<\/p>\n *.Log_archive_dest_state_2=’ENABLE’<\/p>\n *.Standby_File_Management=’AUTO’<\/p>\n *.LOG_ARCHIVE_MAX_PROCESSES=30<\/p>\n [\/crayon]<\/p>\n Opening the Standby DB in nomount mode. create spfile from pfile;<\/p>\n startup nomount<\/p>\n [\/crayon]<\/p>\n Make a password file in the standby (the sys password should be the same as in the Primary). [\/crayon]<\/p>\n Making a backup of the Primary using RMAN. The RMAN backup should be sent to the Standby (in the same location as it is in the Primary). run {<\/p>\n BACKUP CURRENT CONTROLFILE FOR STANDBY format ‘\/u02\/backup\/standbyctl’ ;<\/p>\n ALLOCATE CHANNEL C1 TYPE DISK MAXPIECESIZE 15G;<\/p>\n BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT ‘\/u02\/BACKUP\/DBF_%D_%U_%S_%P.RMAN’ TAG=’RMAN_FULLYEDEK_FOR_STANDBY’;<\/p>\n BACKUP DATABASE PLUS ARCHIVELOG;<\/p>\n RELEASE CHANNEL C1;<\/p>\n }<\/p>\n [\/crayon] {<\/p>\n BACKUP CURRENT CONTROLFILE FOR STANDBY format ‘\/u02\/backup\/standbyctl’ ;<\/p>\n ALLOCATE CHANNEL C1 DEVICE TYPE DISK MAXPIECESIZE 15G;<\/p>\n BACKUP DATABASE FORMAT ‘\/u02\/BACKUP\/DBF_%U_%D_%S_%P’TAG=’RMAN_FULLYEDEK_FOR_STANDBY’;;<\/p>\n BACKUP DATABASE PLUS ARCHIVELOG;<\/p>\n RELEASE CHANNEL C1;<\/p>\n } The backup should be copied to the \/u02\/backup<\/strong> path in the Standby. If copying the backup is going to take a long time, start the NFS (Network File System) service and then mount, this will save the trouble of copying.<\/p>\n <\/p>\n [crayon]<\/p>\n mount -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp PrimaryDB_IP:\/u02\/backup \/u02\/backup<\/p>\n [\/crayon]<\/p>\n <\/p>\n The RMAN backup should be restored in the standby. To do this, in the Primary DB :<\/p>\n <\/p>\n [crayon] DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;<\/p>\n [\/crayon] Creating the redo logs in the Standby (be careful with the file sizes).<\/p>\n select bytes\/1048576 as MB from v$log;<\/p>\n select group#, member from v$logfile ;<\/p>\n col member format a70<\/p>\n set lines 132<\/p>\n set trims on<\/p>\n select group#,type,member from v$logfile order by type;<\/p>\n [\/crayon] <\/p>\n <\/p>\n Drop StandBy Log ALTER DATABASE DROP STANDBY LOGFILE GROUP 6;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 7;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 8;<\/p>\n ALTER DATABASE DROP STANDBY LOGFILE GROUP 9; [crayon] ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log02_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log03_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log04_1.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log05_1.log’) SIZE 100M reuse; <\/p>\n — adding a multi-user standby log<\/p>\n [crayon] ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log02_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log02_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log03_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log03_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log04_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log04_2.log’) SIZE 100M reuse;<\/p>\n ALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log05_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log05_2.log’) SIZE 100M reuse; <\/p>\n <\/p>\n To apply the redos, created in the Primary, to the Standby:<\/p>\n <\/p>\n To check, in the Primary:<\/p>\n <\/p>\n In the Standby:<\/p>\n <\/p>\n [crayon]select thread#,max(sequence#) from v$archived_log where applied =’YES’ group by thread#; <\/p>\n REDO APPLY<\/strong><\/p>\n <\/p>\n [crayon] <\/p>\n This can done manually without making an RMAN duplicate. Put the Primary DB into Mount mode, create a control file for the Standby and copy to the original paths using the same names.<\/p>\n The same procedure should be applied for both the datafiles and log files.<\/p>\n [crayon]SELECT SWITCHOVER_STATUS,PROTECTION_MODE,DATABASE_ROLE from v$database;[\/crayon] [crayon]SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;[\/crayon] [crayon]SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;[\/crayon]<\/p>\n [crayon]<\/p>\n column “First Time” format A40column applied format A10<\/p>\n column “Next Time” format A40<\/p>\n set linesize 120<\/p>\n set pagesize 1000<\/p>\n select thread#, sequence#, applied,<\/p>\n to_char(first_time,’DD-MON-YY:HH24:MI:SS’) “First Time”,<\/p>\n to_char(next_time,’DD-MON-YY:HH24:MI:SS’) “Next Time”<\/p>\n from v$archived_log<\/p>\n UNION<\/p>\n select NULL,NULL,’ ‘,NULL,null FROM DUAL<\/p>\n UNION<\/p>\n select null,null,<\/p>\n db_unique_name,<\/p>\n database_role,<\/p>\n open_mode<\/p>\n from v$database<\/p>\n \/<\/p>\n [\/crayon] [crayon]<\/p>\n Select Status, Errorfrom v$Archive_dest<\/p>\n where dest_id=2; [crayon]<\/p>\n COL DAY FORMAT a15;COL HOUR FORMAT a4;<\/p>\n COL TOTAL FORMAT 999;<\/p>\n SELECT TO_CHAR(FIRST_TIME,’YYYY-MM-DD’) DAY,<\/p>\n TO_CHAR(FIRST_TIME,’HH24′) HOUR,<\/p>\n COUNT(*) TOTAL<\/p>\n FROM V$LOG_HISTORY<\/p>\n GROUP BY TO_CHAR(FIRST_TIME,’YYYY-MM-DD’),TO_CHAR(FIRST_TIME,’HH24′)<\/p>\n ORDER BY TO_CHAR(FIRST_TIME,’YYYY-MM-DD’),TO_CHAR(FIRST_TIME,’HH24′)<\/p>\n ASC;<\/p>\n [\/crayon] [crayon]select * from v$archive_gap;[\/crayon] SELECT nameFROM v$archived_log<\/p>\n WHERE thread# = 1<\/p>\n AND dest_id = 1<\/p>\n AND sequence# BETWEEN Low_Sequence and High_Sequence;<\/p>\n [\/crayon] [crayon]<\/p>\n ALTER DATABASE REGISTER LOGFILE ‘\/u02\/app\/oracle\/archive\/FSM\/arc_38792_5711453.log’;ALTER DATABASE REGISTER LOGFILE ‘\/u02\/app\/oracle\/archive\/FSM\/arc_38793_5711453.log’;<\/p>\n ALTER DATABASE REGISTER LOGFILE ‘\/u02\/app\/oracle\/archive\/FSM\/arc_38794_5711453.log’;<\/p>\n [\/crayon] [crayon]<\/p>\n SELECT flashback_on, log_mode FROM v$database;whilst in mount mode<\/p>\n alter database flashback on;<\/p>\n [\/crayon] [crayon]Alter system set dg_broker_start=True scope=both;[\/crayon] [crayon]select FS_FAILOVER_OBSERVER_HOST from v$database;[\/crayon]<\/p>\n [crayon]Check that machine is running the observer process[\/crayon]<\/p>\n [crayon]<\/p>\n show configuration verboseSHOW DATABASE ‘FSM_DG2’;<\/p>\n SHOW DATABASE ‘FSM_DG1’;<\/p>\n SHOW DATABASE VERBOSE ‘FSM_DG1’;<\/p>\n SHOW DATABASE VERBOSE ‘FSM_DG2’;<\/p>\n SHOW INSTANCE FSM_DG1;<\/p>\n SHOW INSTANCE VERBOSE FSM_DG1;<\/p>\n SHOW INSTANCE FSM_DG1 ‘TopWaitEvents’;<\/p>\n [\/crayon]<\/p>\n db_name————->FSM<\/p>\n db_unique_name——>FSM_DG1<\/p>\n <\/p>\n db_name————->FSM<\/p>\n db_unique_name——>FSM_DG2<\/p>\n <\/p>\n tail -300f \/u01\/app\/oracle\/admin\/FSM\/bdump\/drcFSM.log |more<\/p>\n <\/p>\n Connecting to the Primary<\/p>\n [crayon]<\/p>\n connect sys\/sys@FSM_DG1><\/p>\n show configuration verbose<\/p>\n CREATE CONFIGURATION FSM_BROKER as PRIMARY DATABASE IS “FSM_DG1” CONNECT IDENTIFIER IS “FSM_DG1”;<\/p>\n ADD DATABASE “FSM_DG2” AS CONNECT IDENTIFIER IS “FSM_DG2” MAINTAINED AS PHYSICAL ;<\/p>\n show configuration<\/p>\n EDIT DATABASE “FSM_DG1” SET PROPERTY ‘LogXptMode’=’SYNC’;<\/p>\n EDIT DATABASE “FSM_DG2” SET PROPERTY ‘LogXptMode’=’SYNC’;<\/p>\n set property FastStartFailoverThreshold = 15;<\/p>\n EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;<\/p>\n Succeeded.<\/p>\n EDIT DATABASE ‘FSM_DG1′ SET PROPERTY FastStartFailoverTarget=’FSM_DG2’;<\/p>\n Property “faststartfailovertarget” updated<\/p>\n EDIT DATABASE ‘FSM_DG2′ SET PROPERTY FastStartFailoverTarget=’FSM_DG1’;<\/p>\n [\/crayon] There should be a system alert when enabling configuration, however the DBMS doesnt give one.<\/p>\n [crayon]<\/p>\n ********************SHUTSDOWN THE DATABASE !!!!!!********************;SHUTSDOWN THE DATABASE !!!!!!<\/p>\n enable configuration;<\/p>\n ********************SHUTSDOWN THE DATABASE !!!!!!<\/p>\n ********************SHUTSDOWN THE DATABASE !!!!!!<\/p>\n [\/crayon] [crayon]sqlplus sys\/sys@FSM_DG1; <\/p>\n Alternatives:<\/p>\n In Standby<\/p>\n [crayon]<\/p>\n Alter System set Log_archive_dest_2=’Service=FSMLGWR AFFIRM SYNC<\/p>\n VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)<\/p>\n db_unique_name=FSM_DG1′;<\/p>\n [\/crayon] <\/p>\n ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY;<\/p>\n <\/p>\n [crayon]<\/p>\n To disable<\/p>\n disable fast_start failover;<\/p>\n disable fast_start failover force<\/p>\n [\/crayon] (Switches roles, primary to standby and standby to primary)<\/p>\n <\/p>\n REINSTATE DATABASE ‘FSM_DG2’;<\/p>\n <\/p>\n standby archive location<\/p>\n [crayon]<\/p>\n how database ‘FSM_DG1’ standbyarchivelocation ;show database ‘FSM_DG2’ standbyarchivelocation ;<\/p>\n edit database FSM_DG2 set property StandbyArchiveLocation = ‘\/u01\/app\/oracle\/archive\/FSM’;<\/p>\n [\/crayon] <\/p>\n Steps to close the databases<\/strong><\/span><\/p>\n [crayon]connect sys\/sys@FSM_DG1; [crayon]<\/p>\n alter system set log_archive_dest_state_2=defer; shutdown immediate<\/p>\n [\/crayon] [crayon]<\/p>\n alter database recover managed standby database cancel; [\/crayon] Standby<\/p>\n [crayon]<\/p>\n startup nomount; alter database recover managed standby database disconnect from session;<\/p>\n [\/crayon] [crayon]<\/p>\n startup; alter system switch logfile;<\/p>\n [\/crayon]<\/p>\n","protected":false},"excerpt":{"rendered":" This article describes the setup of the DataGuard and Observer, in Maxavailability mode and with Fail Over about to be activated.<\/p>\n","protected":false},"author":1,"featured_media":3637,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352,338],"tags":[345],"class_list":["post-2753","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-high-availability","category-oracle-tr","tag-oracle"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2753"}],"version-history":[{"count":0,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2753\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n[crayon]alias oh=’cd \/u01\/app\/oracle\/product\/10g’<\/p>\nStep 1.<\/h2>\n
\n[crayon]alter system set log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/archive\/FSM’ SCOPE=spfile;<\/p>\nStep 2.<\/strong><\/h2>\n
\n[crayon]shutdown immediate;<\/p>\nStep 3.<\/strong><\/h2>\n
Step 4.<\/strong><\/h2>\n
Step 5.<\/strong><\/h2>\n
\n[crayon]Drop StandBy Log<\/p>\nStep 6.<\/h2>\n
\n[crayon]SALTER SYSTEM SET DB_UNIQUE_NAME=’FSM_DG1′ SCOPE=SPFILE; +<\/p>\n
\nThe same, but creating a new pfile instead.
\n[crayon]*.db_name=’FSM’<\/p>\nStep 7.<\/h2>\n
\n[crayon]mkdir -p \/u01\/app\/oracle\/admin\/FSM\/adump<\/p>\nStep 8.<\/h2>\n
\n[crayon]create pfile from spfile ;<\/p>\nStep 9.<\/h2>\n
\n[crayon]*.db_name=’FSM’<\/p>\nStep 10.<\/h2>\n
\n[crayon]$sqlplus \/ as sysdba<\/p>\nStep 11.<\/h2>\n
\n[crayon]\/u01\/app\/oracle\/product\/10g\/bin\/orapwd file=$ORACLE_HOME\/dbs\/orapwFSM password=sys<\/p>\nStep 12.<\/h2>\n
\n[crayon]$rman target \/<\/p>\n
\nAlternatively<\/p>\n
\n[crayon]
\nrun<\/p>\n
\n[\/crayon]
\n <\/p>\nStep 13.<\/h2>\n
\nrman target \/ auxiliary sys\/sys@FSM_DG2<\/p>\n
\ntail -f<\/strong> outputs the alertlog dump.<\/p>\nStep 14.<\/h2>\n
\n[crayon]
\nselect bytes from v$log;<\/p>\n
\n <\/p>\n
\n[crayon]
\nALTER DATABASE DROP STANDBY LOGFILE GROUP 5;<\/p>\n
\n[\/crayon]
\n— adding a single standby log<\/p>\n
\nALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log01_1.log’) SIZE 100M reuse;<\/p>\n
\n[\/crayon]<\/p>\n
\nALTER DATABASE ADD STANDBY LOGFILE (‘\/u02\/app\/oracle\/oradata\/FSM\/stdby_log01_1.log’,’\/u02\/app\/oracle\/oradata\/FSM\/stdby_log01_2.log’) SIZE 100M reuse;<\/p>\n
\n[\/crayon]<\/p>\nStep 15.<\/h2>\n
\n[crayon]
\nalter database recover managed standby database disconnect from session;
\n[\/crayon]<\/p>\n
\n[crayon]
\nselect thread#,max(sequence#) from v$archived_log where archived=’YES’ group by thread#;
\n[\/crayon]<\/p>\n
\n[\/crayon]<\/p>\n
\nalter database recover managed standby database disconnect;
\n[\/crayon]<\/p>\n
\nREDO APPLY USING REAL-TIME APPLY<\/strong><\/p>\n
\n[crayon]
\nalter database recover managed standby database using current logfile disconnect;
\n[\/crayon]
\n <\/p>\n
\nPRIMARY<\/p>\n
\nSTANDBY<\/p>\n
\nChecking the Standby’s Archive destination from the Primary DB<\/p>\n
\n[\/crayon]
\nThe Redo Switch frequency<\/p>\n
\nIf there are any idle archivelogs<\/p>\n
\n[crayon]<\/p>\n
\nCopy missing archivelogs from the Primary to the Standby<\/p>\n
\nFlashback needs to be active for MAXAVAILABILITY.<\/p>\n
\nBoth in the Primary and the Standby run<\/p>\n
\nCheck that machine is running the observer process<\/span><\/p>\nPrimary<\/h3>\n
StandBy<\/h3>\n
log<\/h3>\n
\nNOTE: Enabling configuration shuts down and restarts the database!!!!<\/strong><\/p>\n
\n[crayon]ENABLE FAST_START FAILOVER;[\/crayon]
\nIn both databases<\/p>\n
\nsqlplus sys\/sys@FSM_DG2[\/crayon]
\nThis should allow connection to both the databases, however in a failover it wouldn’t allow opening the database.<\/p>\n
\nPutting the Primary in mount mode<\/p>\n
\n[crayon]switchover to ‘FSM_DG1’ ;[\/crayon]
\n(Writes to the current Standby DB)<\/p>\n
\nClosing and restarting the databases in the Data Guard environment.<\/p>\n
\nstop observer
\n[\/crayon]
\nPrimary<\/p>\n
\nalter system switch logfile ;<\/p>\n
\nStandby<\/p>\n
\nshutdown immediate;<\/p>\n
\nSteps to restart<\/strong><\/span><\/p>\n
\nalter database mount standby database;<\/p>\n
\nPrimary<\/p>\n
\nalter system set log_archive_dest_state_2=enable;<\/p>\n