Re: Database backup when in readonly mode

David,
No,
since you are in Noarchive log you are limited to Cold backups only. I would suggest you strongly consider looking at putting your database into Archive log mode. It will save you many headaches when you need to do a recovery.

Refer to the Backup and Recevery Guide.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"David Yeung" <dyeung_at_ust.hk> wrote in message news:blnsr7$ii9$1_at_news.ust.hk...
> 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
>
Received on Sun Oct 05 2003 - 08:44:14 CDT