Recovery Area Config

http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/backup.102/B19193-02/rpfbdb.htm#2933

alter system set db_recovery_file_dest_size=2G scope=both;
alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' scope=both;

alter system set db_flashback_retention_target=1440 scope=both;

select * from v$recovery_file_dest;
select * from v$flash_recovery_area_usage;

select current_scn from v$database;
select * from v$flashback_database_log;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License