oracle归档开启与归档日志位置设置

雅惠470

-归档开启与归档日志位置设置
SQL> shutdown immediate; Database closed.
Database dismounted.
ORACLE instance shut down. SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 125831812 bytes Database Buffers 155189248 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.
SQL> archive log list;
Database log mode No Archive Mode Automatic archival Disabled
Archive destination /u01/app/oracle/product/10.2.0/db_1/dbs/arch Oldest online log sequence 110 Current log sequence 113 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started.
Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 125831812 bytes Database Buffers 155189248 bytes Redo Buffers 2924544 bytes Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/product/10.2.0/db_1/dbs/arch Oldest online log sequence 110 Next log sequence to archive 113
Current log sequence 113 SQL> shutdown immediate;
Database closed.
Database dismounted. ORACLE instance shut down. SQL> startup mount;
ORACLE instance started.
Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 125831812 bytes Database Buffers 155189248 bytes Redo Buffers 2924544 bytes Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> show parameter archiv
NAME TYPE VALUE
archive_lag_target integer 0 log_archive_config string log_archive_dest string log_archive_dest_1 string log_archive_dest_10 string log_archive_dest_2 string log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string
NAME TYPE VALUE
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_2 string enable
2/3
log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable
NAME TYPE VALUE
log_archive_dest_state_9 string enable log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf log_archive_local_firstboolean TRUE
log_archive_max_processes integer 2 log_archive_min_succeed_dest integer 1 log_archive_startboolean FALSE
log_archive_trace integer 0 remote_archive_enable string true
standby_archive_dest string ?/dbs/arch SQL> archive log list;
Database log mode Archive Mode Automatic archival Enabled'
Archive destination /u01/app/oracle/product/10.2.0/db_1/dbs/arch Oldest online log sequence 110 Next log sequence to archive 113
Current log sequence 113
SQL> alter system set log_archive_dest='/home/oracle';
System altered.
SQL> archive log list;
Database log mode Archive Mode Automatic archival Enabled
Archive destination /home/oracle Oldest online log sequence 110 Next log sequence to archive 113 Current log sequence 113 SQL>