日志文件管理
创建日志组
ALTER DATABASE
ADD LOGFILE ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 100M;
ALTER DATABASE
ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo')
SIZE 100M BLOCKSIZE 512;
创建日志成员
ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2b.rdo' TO GROUP 2;
重命名日志
1.shutdown immediate
2.重命名
3.启动到mount状态
4. ALTER DATABASE
RENAME FILE '/diska/logs/log1a.rdo', '/diska/logs/log2a.rdo'
TO '/diskc/logs/log1c.rdo', '/diskc/logs/log2c.rdo';
5. ALTER DATABASE OPEN;
删除日志组和日志文件
该日志组必须在inactive状态,确保该日志已经被归档。
查看是否已归档
SELECT GROUP#, ARCHIVED, STATUS FROM V$LOG;
GROUP# ARC STATUS
--------- --- ----------------
1 YES ACTIVE
2 NO CURRENT
3 YES INACTIVE
4 YES INACTIVE
删除
ALTER DATABASE DROP LOGFILE GROUP 3; 删除日志组
ALTER DATABASE DROP LOGFILE MEMBER '/oracle/dbs/log3c.rdo'; 删除日志文件
该文件只是从数据库中被删除,并没有被操作系统真正删除,依然存在磁盘上。
日志切换
ALTER SYSTEM SWITCH LOGFILE;
初始化日志文件
ALTER DATABASE CLEAR LOGFILE GROUP 3;
归档管理
开启自动归档模式
1. STARTUP MOUNT 启动到mount模式
2. ALTER DATABASE ARCHIVELOG;
3. ALTER DATABASE OPEN;
开启手动归档
1. STARTUP MOUNT 启动到mount模式
2. ALTER DATABASE ARCHIVELOG MANUAL;开启手动归档
3. ALTER DATABASE OPEN;
4. ALTER SYSTEM ARCHIVE LOG ALL;手动归档已满的日志文件
设置归档路径
配置LOG_ARCHIVE_DEST_n参数(n的取值为1-31),可以配置多个位置。
alter system set log_archive_dest_1='location=/u01/app/oracle/arch1';
alter system set log_archive_dest_2='location=/u01/app/oracle/arch2';
查看归档信息
ARCHIVE LOG LIST
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination D:\oracle\oradata\IDDB2\archive
Oldest online log sequence 11160
Next log sequence to archive 11163
Current log sequence 11163
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25427762/viewspace-1062993/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25427762/viewspace-1062993/