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
코드 블럭
title
Archive 경로 관련 파라미터 변경
linenumbers
true
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.
코드 블럭
title
데이터베이스 중지 및 재기동
linenumbers
true
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.
코드 블럭
title
Archive 모드 전환 및 Database Open
linenumbers
true
alter database archivelog;
archive log list;
shutdown abort
