Monday, 10 August 2015

ORA-00600 on ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

Error:

Standby database was stuck with ORA-600 with below error.

Media Recovery Log /SID/oradata/arch/Arch_SID_3982_1_884477344.arc
Errors in file /SID/admin/diag/rdbms/sidstd/SID/trace/SIDSTD_pr00_4525.trc  (incident=36243):
ORA-00600: internal error code, arguments: [2619], [3982], [], [], [], [], [], [], [], [], [], []
Incident details in: /SID/admin/diag/rdbms/sidstd/SID/incident/incdir_36243/SIDSTD_pr00_4525_i36243.trc
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors with log /SID/oradata/arch/Arch_SID_3982_1_884477344.arc
MRP0: Background Media Recovery terminated with error 600

Solution:

copy the stuck archive log from production database to standby database then do manual recovery with the file and then  start the recovery manager.

++ Scp the archive log from prod to temp location in standby.

SQL> shut immediate
SQL> startup mount;

SQL> recover standby database;
ORA-00279: change 5803237707 generated at 08/07/2015 16:50:34 needed for thread 1
ORA-00289: suggestion : /SID/oradata/arch/Arch_SIDPROD_3982_1_884477344.arc
ORA-00280: change 5803237707 for thread 1 is in sequence #3982

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/tmp/Arch_SIDPROD_3982_1_884477344.arc
ORA-00279: change 5803272404 generated at 08/07/2015 17:01:47 needed for thread
1
ORA-00289: suggestion : /SID/oradata/arch/Arch_SIDPROD_3983_1_884477344.arc
ORA-00280: change 5803272404 for thread 1 is in sequence #3983
ORA-00278: log file '/tmp/Arch_SIDPROD_3982_1_884477344.arc' no longer needed
for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> select max(sequence#) from v$log_history;

No comments: