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:

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose

الرائع said...


شركة تنظيف بجدة
شركة تنظيف منازل بجدة
شركة تنظيف خزانات بجدة
شركة تنظيف شقق بجدة
شركة نقل اثاث بجدة
شركة كشف تسربات بجدة
شركة مكافحة حشرات بجدة
شركة رش مبيدات بجدة

شركة تنظيف بمكة
شركة تنظيف منازل بمكة
شركة تنظيف خزانات بمكة
شركة نقل اثاث بمكة
شركة مكافحة حشرات بمكة

Unknown said...

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

seneeh said...

replica nappy bags replica bags gucci replica bags paypal