|
BayaiM__oracle切换归档模式(步骤)：
------------------oracle11g设置归档模式和非归档模式--------------------------
[[email?protected] ~]#mkdir /u01/arch
[[email?protected] ~]#chown -R oracle:oinstall /u01/arch
[[email?protected] ~]#sqlplus / as sysdba
SQL> archive log list;
SQL> select name,log_mode from v$database;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> alter system set log_archive_dest_1=‘location=/u01/arch‘ scope=spfile;
SQL> shutdown immediate;
SQL> startup;
SQL> show parameter dest;
log_archive_dest_1 string location=/u01/arch
SQL> alter system switch logfile; -- 是强制日志切换，不一定就归档当前的重做日志文件（若自动归档打开，就归档前的重做日志，若自动归档没有打开，就不归档当前重做日志。）
SQL> /
[[email?protected] arch]# pwd
/u01/arch
[[email?protected] arch]# ll
-rw-r----- 1 oracle oinstall 8863744 11月 2 14:53 1_12_991067760.dbf
-rw-r----- 1 oracle oinstall 1024 11月 2 14:53 1_13_991067760.dbf
[[email?protected] ~]$ lsnrctl
LSNRCTL> stop
LSNRCTL> start
Services Summary...
Service "prodb" has 1 instance(s).
Instance "prodb",status UNKNOWN,has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
修改日志文件命名格式
alter system set log_archive_max_processes = 5;
alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
?
-------------------------------------------------------------------------------------------------------------------
对于小白人，无脑操作，完全按照我的步骤就好，不要问，记住不懂得不要问，只要做就好了。
2018年11月2日15:00:24
bayaim
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
