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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |