oracle更改mysql数据目录_oracle数据库更改归档路径

一、数据库启动到mount状态

SQL> shutdown abort;

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  281018368 bytes

Fixed Size                  2020192 bytes

Variable Size              92277920 bytes

Database Buffers          184549376 bytes

Redo Buffers                2170880 bytes

Database mounted.

二、把归档路径设置空，然后设置log_archive_dest_1路径

SQL> alter system set log_archive_dest=''scope=spfile;

System altered.

SQL> alter system set log_archive_dest_1='location=/u01/backup/back/'scope=spfile;

System altered.

三、重启数据库查看

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  281018368 bytes

Fixed Size                  2020192 bytes

Variable Size              92277920 bytes

Database Buffers          184549376 bytes

Redo Buffers                2170880 bytes

Database mounted.

Database opened.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/backup/back/

Oldest online log sequence     8

Next log sequence to archive   10

Current log sequence           10

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29618264/viewspace-2093966/，如需转载，请注明出处，否则将追究法律责任。