Re: Database backup when in readonly mode

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