RMAN-03002: failure of shutdown command, ORA-01013: user requested cancel of current operation

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

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