改变闪回日志位置的步骤:
A.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
B.Shutdown the instance.
C.Start the instance and mount the database.
D.Execute the ALTER DATABASE FLASHBACK OFF command.
E.Execute the ALTER DATABASE FLASHBACK ON command.
F.Open the database.
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
orcl2
SQL> show parameter recover
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest string I:\ORCL2\flash_recovery_area
db_recovery_file_dest_size big integer 3912M
recovery_parallelism integer 0
SQL> alter system set db_recovery_file_dest='I:\flash_recovery_area\ORCL2';
系统已更改。
SQL> show parameter recover
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest string I:\flash_recovery_area\ORCL2
db_recovery_file_dest_size big integer 3912M
recovery_parallelism integer 0
SQL>
SQL> conn / as sysdba;
已连接。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 1586708480 bytes
Fixed Size 2176128 bytes
Variable Size 1090521984 bytes
Database Buffers 486539264 bytes
Redo Buffers 7471104 bytes
数据库装载完毕。
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------------------------
NO
SQL> alter database flashback off;
数据库已更改。
SQL> alter database flashback on;
数据库已更改。
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------------------------
YES
SQL> alter database open;
数据库已更改。
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------------------------
YES
SQL>