Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle backup Problem.
Hi Thiru,
Thank you for the reply....
Presently we are now taking full backups of the database once a day.
And also i didn't understand exactly what archieved logs does.
that is if the redo logs doesn't get filled will it still empty itself to
the archieve logs and if so when?
actually i want the backup of redo logs every 2 hrs even if doesn't get
filled.
Is that possible..Please help me.
Again thank you for your reply.
Sanjay.
Thirumurugan vadivelu wrote in message
<3756F612.1A5CD577_at_infonautics.com>...
>Hi
>First of all You need to determine if the Database needs to be Up and
Running
>24 * 7 .
>If so, then you got two Backup Possibilities :
>1. Operate the Database in ARCHIVELOG mode and Take Hotbackups.In this Case
>Another Oracle process called ARCH is started which copies the Filled
Online
>Redolog Files to a Location Specified by LOG_ARCHIVE_DEST (in
init<sid>.ora).
>You need to Backup the Archived Redolog files also b'cos they will be
needed
>for Media Recovery. Do not Copy the Online Redolog files in this Case. You
need
>to monitor the LOG_ARCHIVE_DEST Filesystem via automated process bc'os if
it
>becomes full, then the DB hangs .-
>
>2. Logical DB Backups using Oracle Export Utility . DB needs to be Up
during
>the Backup preferably without much of User transactions. This method doesnt
>provide for File Recovery. Supports 3 modes viz Database Full Export, User
and
>Table level Exports.
>
>If you can afford to have Downtime, then Full Databse Cold Backups can be
>done.The Database can be operated either in Archivelog or NoArchivelog
modes.
>Generally I dont backup the Online Redolog files except when you want to
Shift
>the enitre DB onto a Different Host and bring it up without Recovery.
>
>-Thiru
>
>Ramgopal Madarapu wrote:
>
>> Hi.
>>
>> i'm new to oracle server dba. could anyone please help me with the backup
>> stratergy.
>> presently i am taking the daily full backup of the database.i also want
to
>> backup redo logs.
>> which is not possible i was told. as it dumps to the archieve logs .in
the
>> alert i can see
>> two log files alternating between themselves.is it bcoz of daily full
>> backup.
>>
>> please help...how to back up redo logs/archieve logs every two hours.
>>
>> its bit confusing from SQL server.
>> thanks in advance....
>>
>> would appreciate your kind help..
>>
>> Sanjay
>
Received on Fri Jun 04 1999 - 10:48:54 CDT