Skip to content

How To: Set Your Oracle 10g Database to ARCHIVELOG Mode

August 22, 2008

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

kick it on DotNetKicks.com

About these ads
3 Comments leave one →
  1. A.gareeballah permalink
    September 26, 2011 10:26 PM

    dear Marlon .

    thanks a lot , it’s very breif and very usefull .

  2. david permalink
    August 26, 2008 1:53 AM

    SQL> STARTUP MOUNT;
    ORA-24324:
    ORA-01041:

    there are two errors..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

  • Archives



  • RSS SQLServerPedia

  • RSS SQL Crunch – Hot SQL Links

  • My Bookmarks

  • Business Career DBA Tool Events free ebook Humor IT News Members Only Microsoft MySQL Operating System Oracle Personal Reporting Services SQL Server SQLServerPedia Syndication SSC SSIS TSQL Tutorial Uncategorized Video


  • Software Blogs - BlogCatalog Blog Directory
  • Follow

    Get every new post delivered to your Inbox.

    Join 28 other followers

    %d bloggers like this: