ORA-03113 ORA-16072 Error

Fault description:

A two-node single-instance Linux + oracle11.2.0.3 + dataguard maximize availability environment was set up a few days ago.

Perform the following steps to remove the dataguard environment on the master node:

1. Create a pfile SQL> Create pfile = '/opt/Oracle/initorcl. ora' from spfile;

2. Edit the initorcl. ora file and delete the configuration related to dataguard.

3. Start Database SQL> startup pfile = '/opt/Oracle/initorcl. ora' from the new pfile file initorcl. ora'

This time error ora-03113:

SQL> startup pfile = '/opt/Oracle/initorcl. ora'
Oracle instance started.

Total system global area 1970864128 bytes
Fixed size 2229664 bytes
Variable Size 1442843232 bytes
Database buffers 520093696 bytes
Redo buffers 5697536 bytes
Database mounted.
ORA-03113: End-of-file on communication channel
Process ID: 7682
The session ID is 125 serial number: 5.

 

View trace logs with ora-16072 errors

* ** 14:13:32. 621
* ** Session ID: (130.1) 14:13:32. 621
* ** Client ID: () 14:13:32. 621
* ** Service name :() 14:13:32. 621
* ** Module name :() 14:13:32. 621
* ** Action name :() 14:13:32. 621
 
Destination log_archive_dest_1 is not serviced by lgwr
Standby database Verification Failed: 16072
Error 16072 detected in background process
ORA-16072 :???????????????
Kjzduptcctx: policying diag for crash event

 

 

Solution:

1. Statup starts the database normally

2. Change the database protection mode to "maximum performance" SQL> alter database set standby to maximize; performance;

3. Start Database SQL> startup pfile = '/opt/Oracle/initorcl. ora' from the new pfile'

4. Create spfile SQL> Create spfile from pfile = '/opt/Oracle/initorcl. ora ';

    

Fault Cause:It is suggested that the database is in "Max available" maximize availability mode, but the related "protection configuration parameters" cannot be found"

 

 

 

This article is from the "morning song muniu" blog, please be sure to keep this http://168ok8.blog.51cto.com/73394/1559043

ORA-03113 ORA-16072 Error