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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to config (no)archivelog mode and manage archive log files by RMANHive
- 更改Archive ModeHive
- Oracle 12c Rac Set Archive ModeOracleHive
- oracle archive log 歸檔日誌OracleHive
- 使用LOGMNR工具分析Oracle Redo Log和Archive Log教程Oracle RedoHive
- Oracle archive log 歸檔日誌管理OracleHive
- oracle 引數LOG_ARCHIVE_FORMAT 的格式OracleHiveORM
- log_archive_dest與log_archive_dest_n區別Hive
- Checking for Oracle archive log corruption [ID 1268590.1]OracleHive
- Archivelog & Noarchivelog mode in RMANHive
- Oracle 10G的log_archive_format引數Oracle 10gHiveORM
- 【轉】詳解log_archive_dest與log_archive_dest_n區別Hive
- 關於 log_archive_dest與log_archive_dest_n a的區別Hive
- Oracle8.1.7.0 LOG_ARCHIVE_MIN_SUCCEED_DEST 不起作用 ?OracleHive
- [oracle]log_archive_dest_n與DB_RECOVERY_FILE_DESTOracleHive
- Oracle OCP 1Z0 053 Q64(RESETLOGS&LOG_ARCHIVE_FORMAT)OracleHiveORM
- Windows 下備份 archive logWindowsHive
- archive log 歸檔日誌Hive
- alter system archive log current noswitch!!Hive
- alter system archive log current / all / switch logfileHive
- Archive Log模式下Redo Log、Check Point和Switch LogHive模式
- logminer工具對redo log或archive log的挖掘Hive
- ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DESTHive
- standby_archive_dest和log_archive_dest_n區別Hive
- oracle dataguard standby log_archive_dest_state_n 中defer 含義OracleHive
- oracle time modeOracle
- LOG_ARCHIVE_DEST_n詳解Hive
- Oracle Flashback Data ArchiveOracleHive
- ????Oracle dataguard enabling real time applyOracleAPP
- oracle 817 archive err,oracle hangOracleHive
- Archive log mining steps(logminer to html)HiveHTML
- alter system archive log current和alter system switch logfileHive
- Oracle Data Guard LOG_ARCHIVE_DEST_n引數的可選屬性OracleHive
- ORACLE LOCK MODE 1.2.3.4.5.6Oracle
- db_writer_processes-log_archive_max_processesHive
- oracle archive歸檔初步OracleHive
- alter system switch log file 與 archive log current/all 區別Hive
- Oracle ocp 1Z0 053 Q563(archive-log destination)OracleHive