Configuring Archiving of database

[Norse]

Sponsored Links

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?

[Reegan]

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.

[opaper]

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;

[MindSpace]

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.