пятница, 9 марта 2012 г.

Move Flash Recovery Area to a new location

For to accomplish moving flash recovery area:
  1. Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
  2. Shut down the instance.
  3. Start up the instance and mount the database.
  4. Execute the ALTER DATABASE FLASHBACK OFF command.
  5. Execute the ALTER DATABASE FLASHBACK ON command.
  6. 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;

Комментариев нет:

Отправить комментарий