How To: Set Your Oracle 10g Database to ARCHIVELOG Mode
2008 August 22
Here’s a newbie quickpost:
Put your Oracle 10g Database in ARCHIVELOG Mode:
1. Fire up your SQL *PLUS and log in with SYSDBA priveledges.
START > RUN > sqlplusw
SQL > CONNECT theAdmin/passTheAdmin AS SYSDBA
2. Issue a Shutdown command
SQL > SHUTDOWN IMMEDIATE;
3. Mount yourDatabase
SQL > STARTUP MOUNT;
4. Set your database in ARCHIVELOG mode
SQL > ALTER DATABASE ARCHIVELOG;
5. Open your database
SQL > ALTER DATABASE OPEN;
That’s it.
-Marlon Ribunal
SQL> STARTUP MOUNT;
ORA-24324:
ORA-01041:
there are two errors..
Try to issue the STARTUP MOUNT in another session. Most of the time when you issue a STARTUP MOUNT right after a SHUTDOWN IMMEDIATE on the same session, you get the error codes you listed. You can double check if your database is already in ARCHIVE Mode by issuing:
SQL > ARCHIVE LOG LIST