PC單機最強魔人

plan-A:

1.check current status and setting.

SQL> select * from V$RECOVERY_FILE_DEST;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/ora10g/flash_recovery_area
 2147483648          0                 0               0

2.shutdown DB instance and edit init.ora

###########################################
# File Configuration
###########################################
control_files=("/web/control01.ctl", "/web/control02.ctl", "/web/control03
.ctl")
#db_recovery_file_dest=/ora10g/flash_recovery_area                  <-mark this line
#db_recovery_file_dest_size=2147483648                                    <-mark this line

3.re-start DB instance  and check again.

SQL> select * from V$RECOVERY_FILE_DEST;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------

          0          0                 0               0

4.

SQL> create spfile from pfile;

File created.

plan-B

alter system set db_recovery_file_dest=' ' scope=both;

result: i thing plan -A is better than plan-B.