Oracle Database 归档日志管理
切换到归档模式$ sqlplus / as sysdba
SQL> select dbid,name,log_mode from v$database;
DBID NAME LOG_MODE
---------- --------------------------- ------------------------------------
1081616855 KING NOARCHIVELOG
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination ?/dbs/arch
Oldest online log sequence 42
Current log sequence 44
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 289410904 bytes
Database Buffers 771751936 bytes
Redo Buffers 5554176 bytes
Database mounted.
SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archive/ mandatory';
SQL> alter system set log_archive_dest_2='LOCATION=/u02/app/oracle/archive/ optional';
SQL> alter database archivelog;
SQL> alter database open;
SQL> select dbid,name,log_mode from v$database;
DBID NAME LOG_MODE
---------- --------------------------- ------------------------------------
1081616855 KING ARCHIVELOG
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/app/oracle/archive/
Oldest online log sequence 42
Next log sequence to archive 44
Current log sequence 44
SQL> show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_dest_1 string LOCATION=/u01/app/oracle/archi
ve/ mandatory
SQL> show parameter log_archive_dest_2;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_dest_2 string LOCATION=/u02/app/oracle/archi
ve/ optional
SQL> show parameter log_archive_max
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_max_processes integer 4
SQL> show parameter log_archive_min_succeed_dest
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_min_succeed_dest integer 1
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_format string %t_%s_%r.dbf
页:
[1]