暂无图片
Oracle 开启日志归档模式详细步骤
最近更新:2022-03-11 14:21:05

@[toc]

1. 查看 Oracle 归档状态

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle19/product/19.2.0.3/db_1/dbs/arch
Oldest online log sequence 14
Current log sequence 16

image

2. 关闭数据库

SQL> shutdown immediate;
Database closed.
Database dismounted.

ORACLE instance shut down.

image

3. 启动数据库至 mount 状态

SQL> startup mount;
ORACLE 例程已经启动。

Total System Global Area 1.0737E+10 bytes
Fixed Size 2038632 bytes
Variable Size 5486150808 bytes
Database Buffers 5234491392 bytes
Redo Buffers 14737408 bytes

image

4. 修改归档位置

[root@localhost ~]# su - oracle
......