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

-归档开启与归档日志位置设置
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>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值