![]() ![]() This way, when the database starts, it will use the current control files, rather than paths to obsolete or nonexistent control files Copy this value into the init.ora and match the syntax of the init file. Open the spfile in notepad to get the current value of control_files. Make sure that the control_files parameter in init.ora matches that of the spfile.Make sure that the db_recovery_file_dest parameter in the pfile is the same as in the active flash_recovery_area! The pfile may have an old value for that parameter.Edit the copy so that db_recovery_file_dest_size is double the current value. Normally it is not present, but you can create it with "create pfile from spfile" at the prompt, or from a backup copy in Drive:\oracle\product\11.2.0\admin\sdms\pfile. Look for the init.ora file on the database.It gives the path for that area, the parameter name, and the value. The error message notes that the flash recovery area is full.Reproduce the startup error so that Oracle recreates the alertlog.Rename the alert log if it is too large to open in Notepad.Look in the alert_sdms.log file for the error message.Modify the database init parameter to give it twice the size of the flash recovery area.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |