There is a good backup and recovery tutorial on http://www.dbasupport.com/
check it out
-
Webmaster
http://www.dbasupport.com
Visit
http://www.dbasupport.com for the best oracle resource directory on
the web
Sanjay Narayanan <sanju_n_at_NOSPAMPLEASEhotbot.com> wrote in message
news:GzS53.1472$T24.111628_at_newshog.newsread.com...
> 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 - 16:35:34 CDT
