On Tue, 2 Mar 1999, Manish Modi wrote:
> I am taking an import of particular file and i have read that you can
> have a bakup .
> How to turn the archived redo logs on in case you might have disk
> failure and you can recover your data.
> Thanks,
> Manish

I am not sure what you mean in your first sentence. If you are using the
IMPORT and EXPORT utilities, then you cannot use redo logs to recover your
database to the point of failure. You may only use them to recover up to
the point that the EXPORT was started.

If you wish to turn on archiving, follow the steps below. With archiving
and a good backup scheme, you can recover your database up to the point of
the crash.

* Check the current archiving status of the database:

SQL> select * from v$database;
--------- -------------------- ------------ ------------------ ----------
MYDB01    10/14/98 10:58:16    NOARCHIVELOG 19041917           19040163

You can see that the database is not in archivelog mode.

* Change the database to archivelog mode:


Database altered.

* Now, shut down the database and modify the init.ora parameter file.
  Add the line:

  Also add the format of the log files and the destination directory.
  Sample lines are shown below:


  The above will put the files in the ~/dbs/arch directory, with the time
  and lognumber in the name of the archived redo log.

* Be sure to monitor and delete old archived redo logs, or the disk may
fill up. If it does, then your database will all but freeze.

Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
<-> For 265+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->

Back to Ari Kaplan's Home Page A HREF="../index.htm"> Back to Ari Kaplan's Home Page