A) Archive 모드 전환
운영 모드 현황 조사
archive log list;
SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/db_1/dbs/arch Oldest online log sequence 18 Current log sequence 20
{}
아카이브 경로 파라미터 조사
select NAME, DISPLAY_VALUE from V$PARAMETER where NAME like 'db_recovery_file_dest%';
SQL> col NAME form a30 SQL> col DISPLAY_VALUE form a15 SQL> select NAME, DISPLAY_VALUE from V$PARAMETER where NAME like 'db_recovery_file_dest%'; NAME DISPLAY_VALUE ------------------------------ --------------- db_recovery_file_dest db_recovery_file_dest_size 0
Archive 경로 관련 파라미터 변경
alter system set db_recovery_file_dest_size=4G sid='*'; alter system set db_recovery_file_dest='/FRA' sid='*';
SQL> alter system set db_recovery_file_dest_size=4G sid='*'; System altered. SQL> alter system set db_recovery_file_dest='/FRA' sid='*'; System altered.
데이터베이스 중지 및 재기동
host srvctl stop database -d racdb -o immediate conn / as sysdba startup mount
SQL> host srvctl stop database -d racdb -o immediate SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 721423760 bytes Database Buffers 2466250752 bytes Redo Buffers 16904192 bytes Database mounted.
Archive 모드 전환 및 Database Open
alter database archivelog; archive log list; shutdown abort
SQL> alter database archivelog; 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 18 Next log sequence to archive 20 Current log sequence 20 SQL> shutdown abort Database altered.
srvctl start database -d racdb
