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博客

turn Archiving ON or OFF

最新文章