Re: help with Oracle - new administrator

Dear Manny,

An administrators biggest nightmare is when the database crashes and there is no valid backup for restoration. There are some simple steps which you can follow to ensure the smooth running of the database.

1. Make sure that the database is running in archivelog mode, if the loss of data in case of any disaster cannot be tolerated. You can view this information by querying the database view

SELECT * FROM v$database.

2. If your database is already in archivelog mode than you are in safe waters. If any thing happens to your database then you will be able to restore it by simply using the automatic revoery. You just have to open the database in Mount Mode i.e.

STARTUP MOUNT; then after mounting the database

RECOVER DATABASE; now the oracle will automatically recover the database upto the point of failure.
Once the database is recovered, you will be open it by using

ALTER DATABASE OPEN; 3. A good DBA always verifies the authenticity of the Backup by simulating the disaster on a standby database and then initiating the recovery process.

I hope this will be of help. Dont hesitate to contact me, in case of further queries.

Aamir Siddiqi

MannyMac <mannymac_at_aol.com> wrote in message news:19991105092731.01653.00002571_at_ng-ch1.aol.com...
> Hello, we are running oracle 7.3.3 on AIX 4.3.2. However we have an
application
> that runs on top of oracle so we do not interface with oracle at all, at
the
> most we start and shut it down for backups and that's as far as our
involment
> goes.
>
> I already have the Oracle backup and recovery handbook from oracle press,
> great book I used it to understand the backup process, however I don't
have nor
> do I understand how to maintain and check the integrety of my database. If
> someone could give me some insight on what to buy and/or what commands I
could
> use I would be eternally thankfull..
> yours truly
> Manny
Received on Sun Nov 07 1999 - 02:36:43 CST