Shutdown the database.
shutdown immediate;
Exclusive start.
startup mount;
Turn on archivelog.
SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered.
Check archive log mode.
SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG
Similar Posts:
- ORA-01113: file n needs media recovery – ORA-01110: data file n: \SYSTEM01.dbf′
- How to Enable / Disable Restricted Session in Oracle Database
- How To Delete Specific Archivelogs and Backups Using RMAN
- RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE
- ORA-00020 maximum number of processes exceeded
864