ASKER
ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
ASKER
Below is the output after querying for redo log files. The database is in mounted and not opened. Iam not able to open the database.
1 1 523 NO INACTIVE D:\APP\ADMIN\ORADATA\ORCL\
2 1 524 NO INACTIVE D:\APP\ADMIN\ORADATA\ORCL\
3 1 525 NO CURRENT D:\APP\ADMIN\ORADATA\ORCL\
Iam not able to switch the log files as the database is not opened. The below command fails with the error
ALTER SYSTEM SWITCH LOGFILE;
Error starting at line 13 in command:
ALTER SYSTEM SWITCH LOGFILE
Error report:
SQL Error: ORA-01109: database not open
01109. 00000 - "database not open"
*Cause: A command was attempted that requires the database to be open.
*Action: Open the database and try the command again
Iam trying to drop the redolog file and recreate the group. Any help is really appreciated.