|
Oracle 10g Redo Logs and Flash Recovery Area
How to enable archiving of redo log files (ARCHIVELOG mode).
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
How to view the Flash Recovery Area (FRA) size and location.
SQL> show parameter db_recovery_file_dest_size;
SQL> show parameter db_recovery_file_dest;
How to change the size of the Flash Recovery Area (FRA).
SQL> alter system set
SQL> db_recovery_file_dest_size = 8G scope=both;
How to view the space usage of the Flash Recovery Area (FRA).
SQL> select * from v$recovery_file_dest;
SQL> select * from v$flash_recovery_area_usage;
- Scotech
| 
