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
댓글 없음:
댓글 쓰기