Results 1 to 4 of 4

Thread: Configuring Archiving of database

  1. #1
    Join Date
    Jan 2010
    Posts
    48

    Configuring Archiving of database

    We are just shifting our database server that was running with these specifications
    - HP DL380 G6
    - Intel Xeon E5520 2.27 GHz
    - 8 GB RAM
    - 2 HDD * 146 GB RAID 0
    - 3 HDD * 300 GB RAID 5
    - Windows 2008 server Enterprise 32 bit
    - Oracle 9i
    The old server was poor, So we were using oracle without (Archive log mode).Do you recommend to work with (Archive log mode) for the new server ? My database server occurring some error when I went to change the archiving mode. What the problem may be?
    Last edited by Norse; 29-01-2010 at 11:30 AM.

  2. #2
    Join Date
    Oct 2005
    Posts
    2,394

    Configuring Archiving of database

    Why not ! Absolutely you can run with archiving mode. It will be beneficial for you in future when you need to recovery of your database.

    The archive mode enables you to generate a file which contain some valuable transactions applies. Suppose you have taken a backup and after that you made a lot of transaction and member of log group don't have so much space to contain the generated entries. you have lost all data when going to recovery.

  3. #3
    Join Date
    May 2008
    Posts
    2,393

    Configuring Archiving of database

    Enabling Archiving mode:

    When you create your database and open it first time, it will be open in NOARCHIVE MODE by default and you have to change this configuration according to your need.

    To change the archiving mode you have to follow these instructions :

    1. Shut down your database if your database is already open,Using
    SQL> SHUT DOWN;

    2. Start your database in MOUNT stage,Type
    SQL> STARTUP MOUNT;

    NOTE: If you are going directly to open your database,It will be open successfully but you can't configure archiving mode because it requires to be in mount stage.

    3. Type the command below :
    SQL> ALTER DATABASE ARCHIVE MODE;

    4. Open your database now and type :
    SQL> ALTER DATABASE OPEN;

    Make sure your database is running in configured mode :
    SQL> ARCHIVE LOG LIST;
    Last edited by opaper; 29-01-2010 at 12:06 PM.

  4. #4
    Join Date
    Feb 2008
    Posts
    1,856

    Configuring Archiving of database

    Starting archive process:

    You are running with archive mode but archiving process is still disable.You have to enable it other wise archive log files would not be generate.

    To enable the archiving process,you have to change the parameter:

    1. Open the parameter file from $ORACLE_HOME /dbs/ .
    2. Change the parameter if already specified into -
    log_archive_start=TRUE
    3. Save it and close. Move to terminal and shut down database.
    4. Type " Create spfile from pfile" and start the database again.

Similar Threads

  1. GFI MailArchiver for Mail Archiving
    By Cruzz in forum Windows Software
    Replies: 5
    Last Post: 12-01-2010, 12:51 AM
  2. What is e-mail archiving
    By cornto in forum Technology & Internet
    Replies: 3
    Last Post: 05-10-2009, 03:14 PM
  3. How to enhance performance using Database Archiving Solutions
    By Antrix in forum Software Development
    Replies: 2
    Last Post: 15-04-2009, 11:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •