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


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-01-2010
Member
 
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 12:30 PM.
Reply With Quote
  #2  
Old 29-01-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
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
  #3  
Old 29-01-2010
Member
 
Join Date: May 2008
Posts: 2,383
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;
__________________
The FIFA Manager 2009 PC Game

Last edited by opaper : 29-01-2010 at 01:06 PM.
Reply With Quote
  #4  
Old 29-01-2010
Member
 
Join Date: Feb 2008
Posts: 1,845
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.
Reply With Quote
Reply

  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 01:51 AM
What is e-mail archiving cornto Technology & Internet 3 05-10-2009 04:14 PM
How to enhance performance using Database Archiving Solutions Antrix Software Development 2 15-04-2009 12:24 PM


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