oracle資料庫更改歸檔路徑

煙花丶易冷發表於2016-05-05
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章