اگر در بازیابی 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:18 2016
LGWR: STARTING ARCH PROCESSES
Mon May 16 16:29:18 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:18 2016
راه حل :
مرحله 1 : Startup دیتابیس در حالت mount .
SQL> startup mount;
ORACLE instance started.
Total System Global Area 7482626048 bytes
Fixed Size 2267792 bytes
Variable Size 5804918128 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.
SQL>
مرحله 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 5804918128 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
درباره این سایت