Pages

Monday, January 11, 2010

Enable ARCHIVELOG and FLASHBACK mode on ASM

To enable ARCHIVELOG on ASM and configure FLASHBACK (without enabling it) you need to set up the appropriate initialization parameters (db_recovery_file_dest_size, db_recovery_file_dest, db_flashback_retention_target).

SQL>alter system set db_recovery_file_dest_size = '400G' scope=both sid='*';
SQL>alter system set db_recovery_file_dest = '+DATA_RAC3' scope=both sid='*';
SQL> alter system set db_flashback_retention_target =





ALTER DATABASE FLASHBACK

5 comments:

  1. I went to the meeting this mid year and I am anxious to execute it! I trust it goes well! buy facebook rating

    ReplyDelete