ORA-16072: a minimum of one standby database destination is required; ORA-03113: end-of-file on communication channel

 

 

اگر در بازیابی RMAN  با خطای زیر مواجه شدید و دیتابیس شاملStandby  و در مد Maximize Availability بود مراحل زیر را جهت رفع خطا دنبال کنید :

ORA-16072: a minimum of one standby database destination is required;

ORA-03113: end-of-file on communication channel

 

 

 

خطای بالا پس از تلاش برای OPEN کردن پایگاه ‌داده پس از Restore وRecover  RMAN رخ داده ‌است.

 

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 3689

Session ID: 5644 Serial number: 5

 

در  RMAN بعد از open resetlogs:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 17 and starting SCN of 822561

 

---

در فایل Alert.log :

Mon May 16 16:29:17 2016

alter database open

Mon May 16 16:29: 2016

LGWR: STARTING ARCH PROCESSES

Mon May 16 16:29: 2016

ARC0 started with pid=21, OS id=3196 

ARC0: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

ARC0: STARTING ARCH PROCESSES

LGWR: Primary database is in MAXIMUM AVAILABILITY mode

LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR

LGWR: Minimum of 1 LGWR standby database required

Errors in file /soft/app/oracle/diag/rdbms/remitdb/remitdb/trace/remitdb_lgwr_3144.trc:

ORA-16072: a minimum of one standby database destination is required

Mon May 16 16:29:19 2016

ARC1 started with pid=22, OS id=3198 

LGWR (ospid: 3144): terminating the instance due to error 16072

Mon May 16 16:29:20 2016

System state dump requested by (instance=1, osid=3144 (LGWR)), summary=[abnormal instance termination].

System State dumped to trace file /soft/app/oracle/diag/rdbms/remitdb/remitdb/trace/remitdb_diag_3134_20160516162920.trc

Dumping diagnostic data in directory=[cdmp_20160516162920], requested by (instance=1, osid=3144 (LGWR)), summary=[abnormal instance termination].

Instance terminated by LGWR, pid = 3144

Mon May 16 16:31: 2016

راه حل :

مرحله 1 : Startup  دیتابیس در حالت mount .

SQL> startup mount;

ORACLE instance started.

 

Total System Global Area 7482626048 bytes

Fixed Size                  2267792 bytes

Variable Size            58049128 bytes

Database Buffers         1660944384 bytes

Redo Buffers               14495744 bytes

Database mounted.

SQL>  select open_mode, DATABASE_ROLE, guard_status, SWITCHOVER_STATUS from v$database;

 

OPEN_MODE            DATABASE_ROLE    GUARD_S SWITCHOVER_STATUS

-------------------- ---------------- ------- --------------------

MOUNTED              PRIMARY          NONE    NOT ALLOWED

 

مرحله 2 : انتقال دیتابیس به مد maximize performance .

 

SQL> alter database set standby database to maximize performance;

 

Database altered.

 

مرحله 3 : خاموش کردن دیتابیس.

 

SQL> shutdown immediate

ORA-01109: database not open

 

 

Database dismounted.

ORACLE instance shut down.

 

مرحله 4 : Startup  دیتابیس در حالت mount .

 

SQL> startup mount;

ORACLE instance started.

 

Total System Global Area 7482626048 bytes

Fixed Size                  2267792 bytes

Variable Size            58049128 bytes

Database Buffers         1660944384 bytes

Redo Buffers               14495744 bytes

Database mounted.

مرحله 5 : open  کردن دیتابیس.

SQL> alter database open;

Database altered.

 

SQL> select open_mode from v$database;

 

OPEN_MODE

--------------------

READ WRITE

 

source : http://bishwanathdas.blogspot.com/2016/05/ora-16072-minimum-of-one-standby.html