How long do you need to keep your backups?.
#Alter system db recovery file dest size windows#
Flash Recovery Area needsīefore you start configuring your FRA sizing, you need to define your own needs for the recovery windows and retention time. The FRA size is set with only one parameter for all file types together, but we can do some calculations on the size needed for individual file types. Main file types are archivelog, flashback log, backups, as well as mirrors for your control files and redo log files.Īll files in the FRA are Oracle-managed files. Using a Flash Recovery Area simplifies the administration of your database by automatically retaining them for as long as they are needed for restore and recovery activities, and deleting them when they are no longer needed, because the space is needed for another backup and recovery-related purpose. Since you are already at a MOUNT state, you should be able to just issue the ALTER from there - maybe with SCOPE=BOTH, and continue with ALTER DATABASE OPEN.In the Oracle database, the Flash Recovery Area or FRA is a location on disk where the database can create and manage several kinds of backup and recovery-related files. SQL>And no need to mess with an init.ora file.Īnd just to clarify, when I said all you need to do is STARTUP NOMOUNT, what I meant was that that is the minimum requirement for being able to ALTER SYSTEM. SQL> alter system set db_recovery_file_dest_size=20g scope=spfile With the Partitioning, OLAP, Data Mining and Real Application Testing options Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production Issue your ALTER SYSTEM to resize the recovery file dest size, then ALTER DATABASE System parameters with non-default values:ĭb_recovery_file_dest_size= 200GSo perhaps it's not reading my init.ora file? Or overriding it with the spfile?Ĭan someone help me alter the recovery_file size?ĭanNotice that the error is occuring after the database is mounted (control file has been opened and processed, data files still not opened). Using parameter settings in server-side spfile /oracle/11gr2/app/oracle/product/11.2.0/dbhome_2/dbs/spfilemimic2.ora
With the Partitioning, OLAP, Data Mining and Real Application Testing options. Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production I've changed my init.ora to contain the line:ĭb_recovery_file_dest_size=400GBut when I try to startup, I get the same error, and the log showing the initialization params shows: The problem is that I'm unable to start the database to run the 'alter system set db_recovery_file_dest_size=.' command.īut I should be able to at least temporarily alter this in the init.ora file, right? Is there a way to determine how much space would be required? Or should I just go for 300G? 400G? The disk itself has 500G free. ORA-19815: WARNING: db_recovery_file_dest_size of 214748364800 bytes is 100.00% used, and has 0 remaining bytes available.I would like to fix this by increasing the size of the recovery area. ORA-03113: end-of-file on communication channelWhich lead me to the alert log: Total System Global Area 1.9241E+10 bytes ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
I have a 11.2.0.2.0 installation which suffered a power failure and I'm trying to restart.
0 kommentar(er)
