ITPub博客

首页 > 应用开发 > IT综合 > turn Archiving ON or OFF

turn Archiving ON or OFF

原创 IT综合 作者:jinava 时间:2005-01-11 13:41:37 0 删除 编辑
turn on:

1. Enabling Automatic Archiving
1a. alter system archive log start;
1b. alter system set log_archive_start = true scope=spfile; => restart db
2. Changing the Database Archiving Mode
LOG_ARCHIVE_START => manual or auto
LOG_ARCHIVE_DEST
LOG_ARCHIVE_FORMAT => arch%S.%T.arc
sql> startup mount
sql> alter database archivelog;
sql> alter database open;
3. Archive commands
sql> archive log list
sql> archive log all,
sql> alter system switch log;

trun off:

1a. alter system archive log stop;
1b. alter system set log_archive_start = false scope=spfile; => restart db
2a. alter database noarchielog;

LOG_ARCHIVE_FORMAT parameter:
%T  Thread number, left-zero-padded      arch0000000001 
%t  Thread number, not padded          arch1 
%S  Log sequence number, left-zero-padded  arch0000000251 
%s  Log sequence number, not padded      arch251 
10g:
%r, identifies the logical incarnation of the database and changes each time the resetlogs command is issued.

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/205087/viewspace-786824/,如需转载,请注明出处,否则将追究法律责任。

上一篇: LogMiner
请登录后发表评论 登录
全部评论
  • 博文量
    32
  • 访问量
    40424