-
SQL> select * from v$log (status: current/active/inactive/unused)
SQL> select * from v$logfile (status: blank(in use)/stale(incomplete)/delete)
- Force log switch and CKPT
SQL> alter system checkpoint
SQL> alter system switch logfile
FAST_START_MTTR_TARGET (MTTR: meantime to recovery) (9i) 包含下面参数
FAST_START_IO_TARGET (8i)
LOG_CHECKPOINT_INTERVAL
LOG_CHECKPOINT_TIMEOUT - Adding (drop) Online Redo Log Groups
SQL> alter database add logfile group 6 ('xxx1','xxx2') size 1m;
SQL> alter database drop logfile group 6;
不能删除:当前日志组,活动日志组,没有归档的日志组 - Adding Online Redo Log Members
SQL> alter database add logfile member 'xxx1' to group 6;
SQL> alter database drop logfile member 'xxx1';
不能删除:最后一个 - Clearing, Renaming and Relocation Online Redo Log
SQL> alter database clear logfile 'xxx' (reinit)
SQL> alter database clear unarchived logfile 'xxx' (reinit) need fullbackup databaseSQL> alter database rename file 'xxx' to 'xxx1'
- Archived Redo Log File (Recovery and online backup)
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog/noarchivelog; 切换日志模式
SQL> alter database open;
database full backup
SQL> archive log list
SQL> select * from v$archived_log;
SQL> alter system set log_archive_start=TRUE scope=spfile; 自动存档 - LOG Minor
(1) set directory (UTL_FILE_DIR)
(2) create file
dbms_logmnr_d.build('aaa.ora','D:\oracle\admin\orcl9i\cdump');
(3) add/remove log file
dbms_logmnr.add_logfile(remove_logfile)('D:\oracle\oradata\orcl9i\REDO02.LOG',dbms_logmnr.new);
(4) start logmnr
dbms_logmnr.start_logmnr(dictfilename=>'D:\oracle\admin\orcl9i\cdump\aaa.ora');
(5) select * from v$logmnr_contents (sql_redo/sql_undo)