![]() ![]() ![]() ![]() After you have enabled logging for Flashback Database and set a flashback retention target, allow the database to run under a normal workload for a while, to generate a representative sample of flashback logs. What do you guys suggest?Įdited by: Kunwar on 5:45 AMThere is no fixed calculation for sizing flashback logfile generation, it can vary considerably depending on specific workload of yours database activity.You can measure the size estimation for flashback log during couple of peak load hours, oracle deemed determined that 1G is not enough for yours flashback logs due to capturing peak hours database activity, this could be determined by V$FLASHBACK_DATABASE_LOG view, it let you estimate how much space to add to your flash recovery area for flashback logs. How can i do the calculation for any given DB in general? Are there any formulae/guidenlines i need to follow:īut no luck so far. To avoid that i want to know what should be the minimum size of db_recovery_file_dest_size required. What i want to do is try out flashback database command. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database alter system set dbrecoveryfiledest'e:\fra' Would probably change this too : ( At the same time ) alter system set dbrecoveryfiledestsizeG scopeboth The check is easy SQL>show parameter dbrecovery Do NOT move old files.To make archivelog destination same as FRA execute below command.Īlter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' scope=both sid='*' STEP 3: Stop database and start in mount ~]$ srvctl status database -d ~]$ srvctl stop database -d ~]$ srvctl start database -d orahow2c -o ~]$ srvctl status database -d orahow2c STEP 4: Enable Archiving of RAC Database. NOTE: You can also set db_recovery_file_dest path to local file system or Linux directory. SQL> alter system set db_recovery_file_dest=' RE_QTR4' scope=both sid='*' SQL> alter system set db_recovery_file_dest_size=80G scope=both sid='*' Here we can see it is already set, if not then set it using below command. db_recovery_file_dest is the location and db_recovery_file_dest_size is the quota/size for FRAĭb_recovery_file_dest_size big integer 80G So first we need to configure FRA as archiving destination if it is not set.ĭb_recovery_file_dest and db_recovery_file_dest_size parameter need to be set for FRA. #ALTER SYSTEM DB RECOVERY FILE DEST SIZE ARCHIVE#SQL> show parameter DB_RECOVERY_FILE_DESTĭb_recovery_file_dest_size big integer 80G STEP 2: Configure archive destination for archiving redo logs.įrom the above output we can see that database is using Flash recovery area – FRA (DB_RECOVERY_FILE_DEST) for archive destination which is the default Oracle managed location for centralized backup and recovery files. STEP 1: Check archivelog mode SQL> select log_mode,name from v$database Īrchive destination USE_DB_RECOVERY_FILE_DEST Steps to Enable / Disable Archivelog Mode in 19c ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |