2 Replies Latest reply: Jan 8, 2013 9:05 AM by user9085814 RSS

    Physical Standby Not shutting down

    user9085814
      Hello ,

      First of all Happy New Year to all.................

      I am having an issue with shutting the Standby database (DR database ) . Please help me on this ... Detail info i am explaining below .

      We have a Physical Standby database ,which is in synchronization mode with production database .
      Once in a week ,we used to cancel the standby mode of DR database , then shut it down and taking a cold backup .

      for canceling Standby mode we use 'alter database recover managed standby database cancel;'
      then for shutting down the db 'shutdown immediate'
      But this time "'shutdown immediate' hangs for a long time . So i have to kill the oracle process to shutdown the database .

      I checked the CPU utilization and vmstat ,but they are fine means there not much load on the server ...

      Even alter log file is not showing any thing .....

      Waiting for reply ..............

      Thanks
        • 1. Re: Physical Standby Not shutting down
          CKPT
          Hi Friend,

          Thanks for your wishes and wish you the same :)

          To go through with this problem, Please provide alert log information after whenever you executed shutdown immediate.

          Apart from it, Just a note. If you connected to SQL* Plus session and then switched to OS without giving execute and then if you again start new SQL* Plus session, Then the two sessions will be active as below.
          oracle@CKPT> ps
            PID TTY          TIME CMD
           5943 pts/0    00:00:00 ksh
           7590 pts/0    00:00:00 ksh
           *7680 pts/0    00:00:00 sqlplus*
           *8813 pts/0    00:00:00 sqlplus*
           8873 pts/0    00:00:00 ksh
           9048 pts/0    00:00:00 ps
          oracle@CKPT>
          If you give shutdown immediate from the new session, Of course it will wait until you kill those sessions, And you can see informational messages from Alert log as below.
          Active process 3741 user 'oracle' program 'oracle@ckpt (xxxxx)'
          Active process 3741 user 'oracle' program 'oracle@ckpt (xxxxx)'
          Then based on the process id *3741* you have to kill the session from OS and then shutdown will go smooth.

          And are you using Active Data Guard? Usually if you unable to perform shutdown you can go with abnormal termination.
          and then start up standby then perform recovery. Once it is completely synchronized then you can cancel the recovery and proceed with the backup.

          Whatever the commands you are following, They are good and no changes required. :)

          Hope This Helps.
          • 2. Re: Physical Standby Not shutting down
            user9085814
            Hello Friend ,


            Thanks for the reply ..............

            As you asked i am sharing the alert log......(THIS IS ALERT LOG BELONG TO STANDBY DATABASE)

            RFS[10]: No standby redo logfiles created
            Mon Jan 07 07:41:30 GMT 2010
            Media Recovery Log /u05/oradata/prd/archivelogs/ARC_716992406_1_11580.dbf
            Media Recovery Waiting for thread 1 sequence 11581 (in transit)
            Mon Jan 07 07:48:22 GMT 2010
            alter database recover managed standby database cancel
            Mon Jan 07 07:48:26 GMT 2010
            MRP0: Background Media Recovery cancelled with status 16037
            Mon Jan 07 07:48:26 GMT 2010
            Errors in file /apps/oracle/admin/prd/bdump/prd_mrp0_15001.trc:
            ORA-16037: user requested cancel of managed recovery operation
            Recovery interrupted!
            Mon Jan 07 07:48:29 GMT 2010
            Errors in file /apps/oracle/admin/prd/bdump/prd_mrp0_15001.trc:
            ORA-16037: user requested cancel of managed recovery operation
            Mon Jan 07 07:48:29 GMT 2010
            MRP0: Background Media Recovery process shutdown (prd)
            Mon Jan 07 07:48:29 GMT 2010
            Waiting for MRP0 pid 15001 to terminate
            Mon Jan 07 07:48:30 GMT 2010
            Managed Standby Recovery Canceled (prd)
            Completed: alter database recover managed standby database cancel
            Mon Jan 07 07:48:30 GMT 2010
            Shutting down instance (immediate)
            Mon Jan 07 07:48:30 GMT 2010
            Shutting down instance: further logons disabled
            Mon Jan 07 07:48:30 GMT 2010
            Stopping background process MMNL
            Mon Jan 07 07:48:30 GMT 2010
            Stopping background process CJQ0
            Mon Jan 07 07:48:31 GMT 2010
            Stopping background process MMON
            License high water mark = 25
            Mon Jan 07 07:48:32 GMT 2010
            Job queue slave processes stopped
            Mon Jan 07 07:49:01 GMT 2010
            ARC1: Archival disabled due to shutdown: 1089
            Shutting down archive processes
            Archiving is disabled
            Mon Jan 07 07:49:11 GMT 2010
            ARCH shutting down
            ARC0: Archival stopped
            Mon Jan 07 07:49:16 GMT 2010
            ARCH shutting down

            ######################################################(HERE THE SHUTDOWN HANGS) (THEN WE HAVE TO KILL THE PMON)



            ARC1: Archival stopped
            Mon Jan 07 08:11:04 GMT 2010
            Errors in file /apps/oracle/admin/prd/bdump/prd_pmon_14970.trc:
            ORA-00474: SMON process terminated with error
            Mon Jan 07 08:11:04 GMT 2010
            PMON: terminating instance due to error 474
            Termination issued to instance processes. Waiting for the processes to exit
            Mon Jan 07 08:11:14 GMT 2010
            Instance termination failed to kill one or more processes
            Mon Jan 07 08:11:35 GMT 2010
            Instance terminated by PMON, pid = 14970
            Mon Jan 07 08:40:00 GMT 2010
            Starting ORACLE instance (normal)
            LICENSE_MAX_SESSION = 0
            LICENSE_SESSIONS_WARNING = 0
            Picked latch-free SCN scheme 3
            ILAT =43
            LICENSE_MAX_USERS = 0
            SYS auditing is disabled
            ksdpec: called for event 13740 prior to event group initialization
            Starting up ORACLE RDBMS Version: 10.2.0.5.0.



            Thanks ......