اگر در بازیابی 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.
مرحله 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
