Re: Database backup when in readonly mode

Hi Kenneth,

If you switch your database to read-only you wouldn´t use your temporary tablespace to make ordering queries.

I advice to switch your database to archivelog mode ir order to make online backups, switch your static tablespaces to readonly, so your database will not generate lots of archivelog files.

Regards.

<Kenneth Koenraadt> escribió en el mensaje news:3f7fcab4.1531462_at_news.inet.tele.dk...
> On Sun, 05 Oct 2003 09:47:40 +0800, David Yeung <dyeung_at_ust.hk> wrote:
>
> >I want to do a full backup while there is no
> >update activities but I want users to be able
> >to read data from the db. Can I switch the database
> >to 'read-only' mode:
> >
> > alter database open read only;
> >
> >and then do a full backup (by backing up all the
> >data files).
> >
> >Is this a proper backup approach.
> >
> >My database is not running on archive mode and I
> >am running Oracle 8i (8.1.7).
> >
> >Thanks for any advice.
> >
> >David Yeung
> >
>
> Hi David,
>
> No archive log => no online backup. It's that simple.
>
> - Kenneth Koenraadt
Received on Sun Oct 05 2003 - 06:11:16 CDT