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
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;
NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#
--------- -------------------- ------------ ------------------ ----------
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:
SQL> ALTER DATABASE ARCHIVELOG;
Database altered.
* Now, shut down the database and modify the init.ora parameter file.
Add the line:
log_archive_start=TRUE
Also add the format of the log files and the destination directory.
Sample lines are shown below:
log_archive_dest=?/dbs/arch
log_archive_format=%t_%s.dbf
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