Oracle Database 归档管理

发布时间：2020-12-12 13:33:06 所属栏目：百科来源：网络整理

导读：SQL?shutdown?immediate SQL?startup?mount 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?archiv

SQL>?shutdown?immediate SQL>?startup?mount 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?????39 Next?log?sequence?to?archive???41 Current?log?sequence???????????41 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>?alter?system?archive?log?current;
System?altered.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!