Re: Online backup alternatives

import/export is not used for online backup. use Oracle hot backup procedures:
  database must be in archivelog mode
  archive log list
  alter tablespace begin backup
  o/s backup tablespace datafile
  alter tablespace end backup
  repeat the above three steps for all tablespaces in concern   archive log list
  backup archivelogs in list
  alter database backup controlfile to trace   backup trace file

It is advised to read some books/manual before implementing backup/recovery procedures.

HTH John Chiu

CT <c.traupe_at_dr-staedtler.de> wrote in message news:80r9j2$10a$1_at_news.ecrc.de...
> Hallo,
>
> I'm relatively new to administrating ORACLE serversm and hadn't had the
> privilege of attending a course. I had to implement an online backup,
which
> in my case means the database must be running during backup. Because of
> being an development server (no important production data) it's sufficent
to
> do a full database backup every night. I (maybe because of my rudimentary
> knowlegde not the best way, but it works; already a few months :-) )
choose
> the ORACLE export tool exp80. (RDBMS-Version 8.0.4)
>
> But what should I do in case of administrating a production server with
> important data coming in all day. It can't be afforded to slow down the
> database by doing a full backup via exp80 every, say, 3 hours.
>
> What would YOU experienced ORACLE administrators do then?
>
> Bye and thanx, Carsten.
>
>
Received on Tue Nov 16 1999 - 05:43:35 CST