Enabling Archive Log mode in Oracle
1. Login as sysdba
2. Configure the archive dest.
db_recovery_file_dest
db_recovery_file_dest_size
3. Shutdown instance.
4. Start the instance in mount mode.
startup mount;
5. Alter database archivelog;
6. Opent the database.
alter database open;
7. Check archivelog status
archive log list;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/638844/viewspace-774164/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 什麼叫archive log expired?Hive
- Archive log mining steps(logminer to html)HiveHTML
- log_archive_dest與log_archive_dest_n與USE_DB_RECOVERY_FILE_DESTHive
- ORACLE LOCK MODE 1.2.3.4.5.6Oracle
- 17 LOG_ARCHIVE_DEST_n 引數屬性Hive
- 【FLASHBACK】Oracle flashback data archive 介紹OracleHive
- [20200114]關於log_archive_dest_1設定.txtHive
- [20200219]log_archive_dest_1定義問題.txtHive
- ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsedHive
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- Enabling Flexible SAP Workflow in Purchase RequisitionFlexUI
- bug solved | This experimental syntax requires enabling xxxUI
- Oracle listener log配置與管理Oracle
- Oracle listener log 日誌分析方法Oracle
- Swift iOS : ArchiveSwiftiOSHive
- Oracle redo解析之-1、oracle redo log結構計算Oracle Redo
- Oracle 19C Data Guard基礎運維-06 PROTECTION MODEOracle運維
- Ten examples of git-archiveGitHive
- Oracle清理trace、alert、aud、listener.log檔案Oracle
- Oracle RAC+DG 調整redo/standby log fileOracle
- oracle ORA-01102: cannot mount database in EXCLUSIVE mode(無法起到獨佔模式)OracleDatabase模式
- ORACLE 閃回檢視v$flashback_database_log/statOracleDatabase
- Log And Trc Location n In Oracle 19c RAC-20220118Oracle
- 【TUNE_ORACLE】等待事件之日誌等待“log file sync”Oracle事件
- Flashback Data Archive原理詳解Hive
- javascript strict modeJavaScript
- IDBTransaction.mode
- Docker Swarm modeDockerSwarm
- 運用Log和Trace檔案排除Oracle Net問題Oracle
- Oracle設定日誌引數-ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;OracleDatabase
- 【TUNE_ORACLE】等待事件之日誌等待“log file parallel write”Oracle事件Parallel
- 【Hudi】原始碼解讀——Archive 流程原始碼Hive
- Temporary failure resolving ‘archive.ubuntu.com‘AIHiveUbuntu
- UFS之Power Mode
- chmod命令(change mode)
- MySQL Strict SQL MODEMySql
- emacs go-modeMacGo
- 【Java】The Java Headless ModeJava
- 【LOG】Oracle資料庫清理日誌、跟蹤檔案利器Oracle資料庫