Re: Backup

There is no problem for using the backup, I did it last week, it was as easy as copying data directory backed up to fresh install, and it run like a charm...

In the accountability side, no problem...

I'm not just un MSCE monkey, if I nedd to learn something, I learn it, but this is not a case I need to learn Oracle, only for that job...

"TurkBear" <john.greco_at_dot.state.mn.us> escribió en el mensaje news:7mftgvcu8ofhtpc8duqgmbmjii56k66sj0_at_4ax.com...
>
> Maybe you do not fully understand..
> If the data is needed ( even if only until the end of the year) then
losing it can be a big problem..If you just back up the
> file system with no knowledge of Oracle, you may not be able to use that
backed up data if your oracle software should get
> corrupted, or you have a disk failure, etc..
>
> The use of EXP and IMP ( in addition to file system backup and knowing how
to install and configure a new Oracle instance) is
> a minimum need to be more sure of an ability to actually get any lost data
back.
> ( The batch file commands you were shown will work if ALL your Oracle data
files ( and what about the software files ?) are
> in c:\oracle\oradata\SID\*.* - In most installations that will not be the
case.).
>
> Be afraid, be very afraid ( especially if your employer is going to hold
you accountable for any data loss)
>
>
>
> "Loinex" <loinex_at_aserio.com> wrote:
>
> >I understand you, but you don't know all the story...
> >
> >The database is part of an ERP that is no longer used in production, and
> >will only be active until the end of this year...
> >
> >Very few data is going to be inserted, but I need to do a backup... I'm
not
> >going to change Oracle setup...
> >
> >It would be a waste of time/money to apply your suggestions only for this
> >case.
> >
> >
> >"Daniel Morgan" <damorgan_at_exxesolutions.com> escribió en el mensaje
> >news:3F0D8DBD.FFC41B9C_at_exxesolutions.com...
> >> Loinex wrote:
> >>
> >> > I have been asigned for a server maintenance, with Oracle 8
installed...
> >> >
> >> > I know that for making backup I need to do a sort of bat file that
stops
> >> > Oracle, copy relevant files to another location and restart Oracle...
> >> >
> >> > What are the commands ?
> >> >
> >> > TIA
> >>
> >> With apologies ... I find your request offensive. If you aren't
qualified
> >> for the job you shouldn't be doing it.
> >> Would you have accepted a job as a dentist with no knowledge of
dentistry?
> >> I, and others could give you
> >> the commands ... heck we could give you the working file ... but what
we
> >> can't give you is the knowledge
> >> required to get it all working properly and assure your employer that
> >their
> >> data is safe.
> >>
> >> My suggestions would be as follows:
> >> 1. Hire a consultant to train you
> >> 2. Take a class and learn how to perform your job
> >> 3. Read books
> >>
> >> Until then I can leave you with one, and only one, other bit of advice
> >....
> >> ReadTheFineManual.
> >>
> >> --
> >> Daniel Morgan
> >> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> >> damorgan_at_x.washington.edu
> >> (replace 'x' with a 'u' to reply)
> >>
> >>
> >
>
Received on Fri Jul 11 2003 - 10:16:36 CDT