一個ocp考試題的驗證

本題的答案是E,最要是因為使用了FRA，這樣FRA裡面的檔案是OMF檔案，所以oracle會刪除過期的備份集。

57. Your database is open in ARCHIVELOG mode.

LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place. No alternative or optional archive destinations are defined.

What is the outcome?

 
A) All active sessions hang until the database administrator (DBA) makes space available in the FRA

B)  No archivelogs are generated.

C) The archivelog entries are made in the diagnostic destination and when space is available, new archivelog are generated.

D) All active sessions are disconnected and their transactions rolled back.

E) Obsolete backups are automatically deleted and new archivelogs are generated.

--==============================

測試之後alert中的日誌：

Thread 1 advanced to log sequence 8 (LGWR switch)
  Current log# 2 seq# 8 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Fri Mar 16 14:03:33 2018
Archived Log entry 2 added for thread 1 sequence 7 ID 0x59539e3c dest 1:
Fri Mar 16 14:03:41 2018
Thread 1 cannot allocate new log, sequence 9
Checkpoint not complete
  Current log# 2 seq# 8 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 9 (LGWR switch)
  Current log# 3 seq# 9 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Fri Mar 16 14:03:46 2018
Archived Log entry 3 added for thread 1 sequence 8 ID 0x59539e3c dest 1:
Fri Mar 16 14:04:04 2018
Thread 1 cannot allocate new log, sequence 10
Checkpoint not complete
  Current log# 3 seq# 9 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Thread 1 advanced to log sequence 10 (LGWR switch)
  Current log# 1 seq# 10 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Fri Mar 16 14:04:05 2018
Deleted Oracle managed file C:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2018_03_16\O1_MF_NNNDF_TAG20180316T135825_FBPQ821N_.BKP
Archived Log entry 4 added for thread 1 sequence 9 ID 0x59539e3c dest 1:
Thread 1 cannot allocate new log, sequence 11
Checkpoint not complete
  Current log# 1 seq# 10 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 11 (LGWR switch)
  Current log# 2 seq# 11 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Fri Mar 16 14:04:17 2018
Archived Log entry 5 added for thread 1 sequence 10 ID 0x59539e3c dest 1:
Fri Mar 16 14:04:19 2018
Thread 1 cannot allocate new log, sequence 12
Checkpoint not complete
  Current log# 2 seq# 11 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 12 (LGWR switch)
  Current log# 3 seq# 12 mem# 0: C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOG
Fri Mar 16 14:04:24 2018
Archived Log entry 6 added for thread 1 sequence 11 ID 0x59539e3c dest 1: