'log_archive'에 해당하는 글 1건

[oracle@oracle ~]$ sqlplus /nolog

SQL*Plus: Release Production on Wed Jan 26 10:17:10 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> connect /as sysdba

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

vi initorcl.ora

아래 추가

*.log_archive_dest_1  = "location=/arch/"
*.log_archive_format  = RACDB%t_%s_%r.arc

SQL> startup mount pfile='~/~/~.ora'
ORACLE instance started.

Total System Global Area  238530560 bytes
Fixed Size    1335724 bytes
Variable Size   92278356 bytes
Database Buffers  142606336 bytes
Redo Buffers    2310144 bytes
Database mounted.
Database opened.

SQL> archive log list
Database log mode       No Archive Mode
Automatic archival       Disabled
Archive destination       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Current log sequence       5

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;
Database log mode       Archive Mode
Automatic archival       Enabled
Archive destination       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence       5

저작자 표시 비영리 변경 금지

유용했던 자료를 기록해 두었습니다. 도움이 되시길~~~ Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you fun

받은 트랙백이 없고 , 댓글이 없습니다.