For to accomplish moving flash recovery area:
- Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
- Shut down the instance.
- Start up the instance and mount the database.
- Execute the ALTER DATABASE FLASHBACK OFF command.
- Execute the ALTER DATABASE FLASHBACK ON command.
- Open the database.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST= '/u01/oradata/flash';
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE FLASHBACK OFF;
SQL> ALTER DATABASE FLASHBACK ON;
SQL> ALTER DATABASE OPEN;
Комментариев нет:
Отправить комментарий