thedbRAVIew

My DB Configuration : Proddb : Source GoldenGate Database Testdb : Target GoldenGate Database DB Backups : None SPFILE/PFILE Backup : None What Happened: The SPFILE in the source database (Proddb) got corrupted. I attempted to increase sga_max_size and streams_pool_size . After making these changes and issuing a STARTUP FORCE command to bounce the database, my Proddb (source) database failed to start. Unfortunately, there were no backups of the database, SPFILE, or PFILE. Solution (What I Did): Since the target server (Testdb) had valid parameter values and was similar to Proddb: I generated a PFILE from the SPFILE on the Testdb server. Transferred the PFILE to the Proddb server. Edited the PFILE with proddb values and Started the Proddb database using the PFILE. Created a new SPFILE from the PFILE. Shut down the database and started it again using the newly created SPFILE. The database is now up and running with the newly created SPFILE. STEPS AND COMMANDS USED :  Source Server ...

Hey Guys!! I have provided some important and useful commands that is used during monitoring and troubleshooting Oracle Data Guard related Issues. PFB. TO CHECK THE STATUS OF THE DATABASE - PRIMARY AND STANDBY: ========================================================== SET LINESIZE 189 PAGES 2000 COL NAME FOR A10 COL HOST_NAME FOR A30 SELECT NAME, INSTANCE_NAME, DB_UNIQUE_NAME, HOST_NAME, STATUS, OPEN_MODE, DATABASE_ROLE AS DB_ROLE, LOGINS FROM V$DATABASE, GV$INSTANCE; TO CHECK STANDBY INFO : ======================= SET LINESIZE 189 PAGES 2000 COL NAME FOR A10 COL HOST_NAME FOR A20 COL DB_UNIQUE_NAME FOR A20 COL OPEN_MODE FOR A10 COL DG_BROKER FOR A15 SELECT NAME, DB_UNIQUE_NAME, HOST_NAME, DATABASE_ROLE AS DB_ROLE, OPEN_MODE, PROTECTION_MODE AS PROTECT_MODE, PROTECTION_LEVEL AS PROTECT_LEVEL, DATAGUARD_BROKER AS DG_BROKER, SWITCHOVER_STATUS FROM V$DATABASE, GV$INSTANCE; TO CHECK CURRENT DG CONFIGURATION : =================================== SHOW PARAMETER LOG_ARCHIVE_CONFIG; SHOW PARA...