-归档开启与归档日志位置设置
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>
分享到:
相关推荐
ORACLE归档日志设置,CDC数据库设置
如何正确删除Oracle归档日志,oralce归档日志清理.
#功能:自动删除ORACLE归档日志文件 #删除方式:rman ,deletearchivelog #调用方式:可单独调用,或在job_clean_archivlog.sh脚本中根据需要调用见另外的附件) ##############################################
oracle归档日志笔记,oracle归档日志笔记
oracle 归档日志 管理
oracle归档日志开启之后,会产生大量的日志,需要定时清理以及不重要的数据库可以不开启归档模式,下面介绍一下oracle归档开启、关闭以及日志的删除。
很实用的操作手册,对于oracle不是很熟的人也可以进行oracle数据库归档日志挖掘。
Oracle清除归档日志
Oracle归档日志非常重要,对归档日志的管理更加重要,本文主要讲解Oracle归档日志方面的各种管理,值得收藏。
oracle 归档日志详解,包括允许模式,分类等。
oracle的重做日志文件,会记录数据库的任何操作,包括DML和DDL语句,数据结构的更改等. 当数据被以外的修改删除,或者instance,disk失败,也可以用重做日志文件进行恢复.所以有必要把数据文件和重做日志文件放在两块不同...
#功能:当空间占用率高于60%时自动删除ORACLE归档日志文件 # #删除方式:高于60%时使用rman+deletearchivelog,高于79%时使用武力删除 #调用方式:可单独调用,或配置定时任务自动执行脚本(会调用clean_archivelog....
oracle RAC集群开启归档日志,需修改集群参数文件,重启数据库
Oracle归档日志空间不足引发的问题及归档日志的检测与删除
oracle归档日志步骤+RMAN步骤 . set ORACLE_SID=EKP sqlplus /nolog conn / as sysdba SQL> archive log list; show parameter db_reco show parameter log_archive alter system set db_recovery_file_...
Centos7.6下Oracle开启归档日志和Rman恢复.docx
当oracle设置为归档模式时,由于归档日志默认空间设置为2G,所以数据库运行一段时间后由于归档日志空间被用完而导致数据库归档日志错误,所以必须删除过期的归档日志,释放闪回空间,这样才能保证数据库正常运行。...
–连接恢复管理器 C:\Documents and Settings\mengzhaoliang>rman target/ –归档日志列表 RMAN> list archivelog all; –删除物理文件不存在的归档日志 RMAN> delete expired archivelog all; –删除7天前的归档...
oracle dg监控程序、归档日志监控程序,里面有详细的代码,可以自动运行,配置化参数,来判断oracle是否正常运行dg和归档日志的rac