Error Description:
Database not mounted

Error Cause:
A command was attempted that requires the database to be mounted.

Action:
If you are using the ALTER DATABASE statement via the SQLDBA startup command, specify the MOUNT option to startup; else if you are directly doing an ALTER DATABASE DISMOUNT, do nothing; else specify the MOUNT option to ALTER DATABASE.

If you are doing a backup or copy, you must first mount the desired database. If you are doing a FLASHBACK DATABASE, you must first mount the desired database.

It's also possible that some other instance has the database mounted exclusive or shared. Shutdown the other instance or mount it in a compatible mode.

The abstract of the bug being "11G DB SYSTEM PARAMETER LOG_ARCHIVE_DEST_N: QUOTA_SIZE PREVENTS DB MOUNT"

This bug is currently being worked upon by the development interface.

Solution
Monitor the referenced bug via metalink for a permanent fix as the development interface is currently working on the same.

Meanwhile consider implementing the steps mentioned below as a workaround until the fix for the referenced bug is made available :

a. SQL> create pfile from spfile;

b. Edit the pfile with log_archive_dest_n set without specifying the quota_size

c. Save the pfile

d. SQL> create spfile from pfile

e. SQL> startup.

Add a comment

Name: Email: URL: Chars left:  1000  (1000 max) (No HTML, but newlines will be preserved)