Re: Backup problem

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 26 Dec 2002 23:10:41 +1000
Message-ID: <x5CO9.10138$jM5.29542@newsfeeds.bigpond.com>

Hi Shravana,

You can't perform a hot backup unless the database is in archivelog mode. This makes sense as the hot backup is potentially worthless you have all the redo logs generated between the start of the backup (the point in which the file was begin backuped) and the point of failure.

Therefore you must covert the database from noarchivelog mode to archivelog mode for this error to go away.

Cheers

Richard
"Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> wrote in message news:3E0A4559.1C748D8D_at_blr.spcnl.co.in...
> Hi All,
>
> We are using oracle 9.2.0 on Solaris 8.
>
> I try to execute the following at SQL> prompt
>
> SQL> alter tablespace <tablespace name> begin backup;
>
> ERROR at line 1:
> ORA-01123: cannot start online backup; media recovery not enabled
>
>
> can some one tell me what is the remedy for this problem? thanks a lot,
>
> Best Regards,
> ShravanaKumar.
>
Received on Thu Dec 26 2002 - 07:10:41 CST