2014년 11월 6일 목요일

[Database] Change Archive Mode

SQL> ARCHIVE LOG LIST
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +RECO
Oldest online log sequence     1
Current log sequence           1

SQL> STARTUP NOMOUNT

SQL> ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE=SPFILE;

SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' SCOPE=SPFILE;

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP MOUNT

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ALTER DATABASE OPEN;

SQL> ARCHIVE LOG LIST
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +RECO
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1

SQL> ALTER SYSTEM SWITCH LOGFILE;

ASMCMD [+RECO/PRD/ARCHIVELOG/2014_07_16] > ls -l
Type        Redund  Striped  Time             Sys  Name
ARCHIVELOG  MIRROR  COARSE   JUL 16 10:00:00  Y    thread_1_seq_1.258.853066651

댓글 없음:

댓글 쓰기