修改Oracle归档终点

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/xiegh2014/article/details/44020027

1、开始归档终点是否开启

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

2、创建新的归档终点目录

[oracle@database9 u01]$ mkdir arch
[oracle@database9 u01]$ ll
总计 8
drwxrwxr-x 4 oracle oinstall 4096 2014-04-28 app
drwxr-xr-x 2 oracle oinstall 4096 03-02 07:55 arch
[oracle@database9 u01]$ pwd
/u01
[oracle@database9 u01]$ cd arch/
[oracle@database9 arch]$ pwd
/u01/arch

3、修改新归档终点

SQL> alter system set log_archive_dest_1='location=/u01/arch';

System altered.

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/arch
Oldest online log sequence     1593
Next log sequence to archive   1595
Current log sequence           1595

4、重启数据库

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size            2230072 bytes
Variable Size         1660946632 bytes
Database Buffers      469762048 bytes
Redo Buffers            4947968 bytes
Database mounted.
Database opened.

阅读更多
换一批

没有更多推荐了,返回首页