When RMAN FULL backup was fired, it gave below error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of shutdown command at 10/03/2016 00:28:29
ORA-01013: user requested cancel of current operation
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of shutdown command at 10/03/2016 00:28:29
ORA-01013: user requested cancel of current operation
On manual shutdown it became unresponsive and a message was found in alert log "shutdown waiting for active calls to complete"
Through other sources it was found that this problem come when PMON process is unable to clear any uncommitted transaction.
SOLUTION I FOUND
1. Connect to SYS user with new terminal window
2. Shutdown database with ABORT option
SQL> shutdown abort;
3. Open database for normal shutdown with RESTRICT option
SQL> startup restrict
4. Now shutdown database with NORMAL option
SQL> shutdown normal;
BUT WHAT I DID?
This problem came in Windows Platform with standby database, so Oracle Service was just restarted and then it was found that Database was in idle state so it was just started in mount stage and it worked.
If you are having some other solution please comment.
Comments
Post a Comment