Oracle开启归档模式及其相关参数
Oracle开启归档模式及其相关参数,涉及以下几个参数:log_archive_min_succeed_dest动态参数 log_archive_dest_state_ 参数log_a
Oracle开启归档模式及其相关参数,涉及以下几个参数:log_archive_min_succeed_dest动态参数 log_archive_dest_state_ 参数
log_archive_format log_archive_dest_1
1.开启归档模式SQL> show user
USER 为 "SYS"
SQL> archive loglist
数据库日志模式 非存档模式
自动存档 禁用
存档终点 USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列 32
当前日志序列 36
SQL> shutdown immediate;
SQL> startup mount; 开启归档模式 需要在MOUNT状态下进行。
ORACLE 例程已经启动。
Total System Global Area 431038464 bytes
Fixed Size 1375088 bytes
Variable Size 327156880 bytes
Database Buffers 96468992 bytes
Redo Buffers 6037504 bytes
数据库装载完毕。
SQL> alter database archivelog;
数据库已更改。
SQL> alter database open;
数据库已更改。
SQL> archive loglist;
数据库日志模式 存档模式
自动存档 启用
存档终点 USE_DB_RECOVERY_FILE_DEST ---开启归档后默认归档位置是闪回区
最早的联机日志序列 32
下一个存档日志序列 36
当前日志序列 36
SQL> show parameter log_archive_max_process
NAME TYPE VALUE
----------------------------------------------- ------------------------------
log_archive_max_processes integer 4
SQL> show parameter log_archive_dest_
NAME TYPE VALUE
----------------------------------------------- ------------------
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_state_13 string enable
2.指定归档日志存放目录
SQL> alter system set log_archive_dest_1="location=d:\disk1\offlinelog\ mandatory"; 这里如果是RAC的话,,可以指定为闪回区并具体到实例alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST' sid='*'
系统已更改。
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
----------------------------------------------- ------------------------------
log_archive_dest_1 string location=d:\disk1\offlinelog\ mandatory
SQL> alter system set log_archive_dest_2="location=d:\disk2\offlinelog\ ";
系统已更改。
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
----------------------------------------------- -----------------------------
log_archive_dest_2 string location=d:\disk2\offlinelog\
SQL> alter system set log_archive_dest_3="location=d:\disk3\offlinelog\ optional";
系统已更改。
SQL> alter system setlog_archive_dest_4="location=d:\disk4\offlinelog\ optional";
系统已更改。
SQL> alter system setlog_archive_dest_5="location=d:\disk5\offlinelog\ mandatory";
系统已更改。
设置归档目录时的几个参数:
SQL> showparameter log_archive_dest_
NAME TYPE VALUE
----------------------------------------------- ------------------------------
log_archive_dest_1 string location=d:\disk1\offlinelog\ mandatory
log_archive_dest_2 string location=d:\disk2\offlinelog\
log_archive_dest_3 string location=d:\disk3\offlinelog\ optional
log_archive_dest_4 string location=d:\disk4\offlinelog\ optional
log_archive_dest_5 string location=d:\disk5\offlinelog\ mandatory
log_archive_dest_6 string
SQL> col destination for a30
SQL> select destination,binding,target,status from v$archive_dest;
DESTINATION BINDING TARGET STATUS
------------------------------ ---------------- ---------
d:\disk1\offlinelog\ MANDATORY PRIMARY VALID
d:\disk2\offlinelog\ OPTIONAL PRIMARY VALID 设置参数时未指定OPTIONAL,ORACLE默认即是此参数值。
d:\disk3\offlinelog\ OPTIONAL PRIMARY VALID
d:\disk4\offlinelog\ OPTIONAL PRIMARY VALID
d:\disk5\offlinelog\ MANDATORY PRIMARY VALID
OPTIONAL PRIMARY INACTIVE
OPTIONAL PRIMARY INACTIVE
查询已经产生的归档日志名--系统默认的命令格式
SQL> select name,blocks from v$archived_log;
NAME BLOCKS
------------------------------------------------------------------------------------------
/u01/app/oracle/flash_recovery_area/BYS001/archivelog/2013_06_08/o1_mf_1_12_8v63 762
########################################################################################
更多详情见请继续阅读下一页的精彩内容:
相关阅读:
Oracle 11G RAC 修改归档模式
Oracle手工完全恢复案例(归档模式)
Oracle手工恢复案例(非归档模式)
Oracle归档模式设置的相关指令与简要说明
Oracle 10g 归档模式下备份脚本

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]
