Re: os backup

Hi,

Sorry for the confusion.Let me summarize what i do:

this is my system:

redhat linux 2.1 advanced server
4 itanium processors.
oracle 9.2.0.5 rac with 2 nodes
ocfs
emc disk array raid 10
and this is a datawarehouse system.
data size is > 1.5TB.

1. stop the dbservers.(i use rac on redhat linux ia64 and have 2 nodes)
2. copy all the datafiles to tape.
3. start the dbserver.

my redo logs are archived periodically and db is in archivelog mode.

 It takes 12 hours to copy all the data files.

Kind Regards,
hope

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news:<bCnQd.2994$df.109470_at_tor-nn1.netcom.ca>...
> Since not enough info was given by the OP, nobody here can provide adequate
> advice.
>
> If the OP is still following this thread, pls provide more info on what you
> exactly do.
>
> It's not clear if :
> you use ALTER TABLESPACE BEGIN/END BACKUP
> and that the db is in archivelog mode
> and that the redo log files that you backup are the archived, or the online
> ones.
>
> And remember that while it's a good thing to have a backup strategy, it's
> much better to have a recovery strategy, and better again to have proven
> that it works.
>
> Regards,
>
> --
> Syltrem
>
> OpenVMS 7.3-1 + Oracle 8.1.7.4
> http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
> ---zulu is not in my email address---
> "Ed Stevens" <nospam_at_noway.nohow> a écrit dans le message de
> news:102211daammhc3imvrpndl841cnu1oue6b_at_4ax.com...
> > On 14 Feb 2005 05:00:49 -0800, hopehope_123_at_yahoo.com (utkanbir)
> > wrote:
> >
> > >Hi ,
> > >
> > >I have a question related to the backup strageties. For some reasons i
> > >cant get rman backups but instead i backup data at os level , and
> > >archive redo logs periodically. I wonder whether it is possible to use
> > >my redo log backups for recovery purpose. Is it possible to restore
> > >some of the archived files from the backup set than apply redo logs ?
> > >
> > >Kind Regards,
> > >tolga
> >
> > When you say you're backing up or data at the os level ... are you
> > simply copying the files without telling Oracle? Without ALTER
> > TABLESPACE ... BEGIN BACKUP? Because if so, your backups are pretty
> > much worthless. If I were in your boots, I'd be solving WHY I can't
> > get rman backups . . . .
> > Thanks.
> >
> > - Ed Stevens
> >
> > Cohn's Law: The more time you spend in reporting on what you are doing,
> the less time you have to do anything. Stability is achieved when you spend
> all your time doing nothing but reporting on the nothing you are doing.
Received on Tue Feb 15 2005 - 15:14:25 CST