修改oracle为归档模式

最新推荐文章于 2023-10-28 20:36:27 发布

choubei6141

最新推荐文章于 2023-10-28 20:36:27 发布

阅读量320

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/wangshengzhuang/blog/785046

版权

1、查看是否为归档模式

SQL> archive log list;
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     16
Current log sequence           18

2、关闭数据库

SQLl>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

3、启动数据库到mount模式

SQL> startup  mount;
ORACLE instance started.

Total System Global Area 3290345472 bytes
Fixed Size            2217832 bytes
Variable Size         1795164312 bytes
Database Buffers     1476395008 bytes
Redo Buffers           16568320 bytes
Database mounted.

4、修改数据库为归档模式

SQL>  alter database archivelog;

Database altered.

5、打开数据库库

SQL> alter database open;

Database altered.

6、查看是否为归档模式

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     16
Next log sequence to archive   18
Current log sequence           18

7、查看归档日志的路径和目录

SQL> show parameter db_recovery_file_dest;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /usr/oracle/app/flash_recovery_area
db_recovery_file_dest_size         big integer 3882M

转载于:https://my.oschina.net/wangshengzhuang/blog/785046