oracle 闪回关闭,关闭闪回即disable flashback的操作步骤

1.现有的环境：

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

YES

SQL> show parameter recovery

NAME         TYPE  VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest       string  /u01/app/oracle/FRA

db_recovery_file_dest_size      big integer 8G

recovery_parallelism       integer  0

SQL> archive log list;

Database log mode        Archive Mode

Automatic archival        Enabled

Archive destination        /u01/app/oracle/bak/arch2

Oldest online log sequence     21

Next log sequence to archive   23

Current log sequence        23

2. 改变一下环境

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  159383552 bytes

Fixed Size      1218268 bytes

Variable Size    117442852 bytes

Database Buffers    37748736 bytes

Redo Buffers      2973696 bytes

Database mounted.

SQL> alter database flashback off;

Database altered.

SQL> alter database open;

Database altered.

SQL> show parameter recovery

NAME         TYPE  VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest       string

db_recovery_file_dest_size      big integer 8G

recovery_parallelism       integer  0

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

System altered.

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

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  159383552 bytes

Fixed Size      1218268 bytes

Variable Size    117442852 bytes

Database Buffers    37748736 bytes

Redo Buffers      2973696 bytes

Database mounted.

Database opened.

SQL> show parameter recovery

NAME         TYPE  VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest       string

db_recovery_file_dest_size      big integer 0

recovery_parallelism       integer  0

###这里最关键的是用alter system reset的操作来还原参数的默认值的。