本文共 1527 字，大约阅读时间需要 5 分钟。

Oracle?????????

1. Flashback On?Recovery????

????SQL????Flashback_on???

SQL> select flashback_on from v$database;

?????

FLASHBACK_ON
----------------
YES

????????????

SQL> show parameter recovery;

???????

2.?????????

SQL> shutdown immediate;

????????

• Database closed.
• Database dismounted.
• ORACLE instance shut down.

2. ?????????

SQL> startup mount;

????????

• ORACLE instance started.
• Total System Global Area: 159383552 bytes
• Database Buffers: 37748736 bytes
• Redo Buffers: 2973696 bytes
• Database mounted.
3. ??Flashback???

SQL> alter database flashback off;

????????

• Database altered.
4. ??????

SQL> alter database open;

????????

• Database altered.
5. ???????

SQL> show parameter recovery;

???????

NAME	TYPE	VALUE
db_recovery_file_dest	string	/u01/app/oracle/FRA
db_recovery_file_dest_size	big integer	0
recovery_parallelism	integer	0

3. ???????????

6. ??db_recovery_file_dest???

SQL> alter system reset db_recovery_file_dest scope=spfile sid='*';

???????

• System altered.
2. ??db_recovery_file_dest_size???

SQL> alter system reset db_recovery_file_dest_size scope=spfile sid='*';

???????

• System altered.
3. ??????

SQL> shutdown immediate;

????????

• Database closed.
• Database dismounted.
• ORACLE instance shut down.
4. ??????

SQL> startup;

????????

• ORACLE instance started.
• Total System Global Area: 159383552 bytes
• Database Buffers: 37748736 bytes
• Redo Buffers: 2973696 bytes
• Database mounted.
• Database opened.

转载地址：http://yopfk.baihongyu.com/