Explanation/Reference:

查看數據庫是否為歸檔模式:

SYS@ENMOEDU>archive?log?list

Database?log?mode??????????????No?Archive?Mode

Automatic?archivalDisabled

Archive?destination????????????USE_DB_RECOVERY_FILE_DEST

Oldest?online?log?sequence1

Current?log?sequence???????????2

關閉數據庫:

SYS@ENMOEDU>shutdown?immediate

Database?closed.

Database?dismounted.

ORACLE?instance?shut?down.

數據庫啟動到mount:

SYS@ENMOEDU>?startup?mount

ORACLE?instance?started.

Total?System?Global?Area??421724160?bytes

Fixed?Size??????????????????2253864?bytes

Variable?Size?????????????322964440?bytes

Database?Buffers???????????88080384?bytes

Redo?Buffers????????????????8425472?bytes

Database?mounted.

修改數據庫為歸檔模式:

SYS@ENMOEDU>?alter?database?archivelog;

Database?altered.

打開數據庫:

SYS@ENMOEDU>?alter?database?open;

Database?altered.

再次查看歸檔模式:

SYS@ENMOEDU>archive?log?list

Database?log?mode?????????????Archive?Mode

Automatic?archival?????????????Enabled

Archive?destination????????????USE_DB_RECOVERY_FILE_DEST

Oldest?online?log?sequence1

Next?log?sequence?to?archive2

Current?log?sequence2

總結

以上是生活随笔為你收集整理的oracle 052考试,Oracle OCP认证考试题库解析052-5的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。