This discussion is archived
2 Replies Latest reply: Jan 8, 2013 7:05 AM by user9085814 RSS

Physical Standby Not shutting down

user9085814 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 ......

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points