Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links

Configuring Archiving of database

Software Development

Thread Tools Search this Thread
Old 29-01-2010
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.
Reply With Quote
Old 29-01-2010
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.
Reply With Quote
Old 29-01-2010
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

2. Start your database in MOUNT stage,Type

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 :

4. Open your database now and type :

Make sure your database is running in configured mode :
The FIFA Manager 2009 PC Game

Last edited by opaper : 29-01-2010 at 12:06 PM.
Reply With Quote
Old 29-01-2010
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 -
3. Save it and close. Move to terminal and shut down database.
4. Type " Create spfile from pfile" and start the database again.
Reply With Quote

  TechArena Community > Software > Software Development
Tags: , , , , , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "Configuring Archiving of database"
Thread Thread Starter Forum Replies Last Post
GFI MailArchiver for Mail Archiving Cruzz Windows Software 5 12-01-2010 12:51 AM
What is e-mail archiving cornto Technology & Internet 3 05-10-2009 03:14 PM
How to enhance performance using Database Archiving Solutions Antrix Software Development 2 15-04-2009 11:24 AM

All times are GMT +5.5. The time now is 09:56 AM.