Re: ORA-00279, ORA-00278 and Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:kq5201pbn2j23teqcqlqo35a334j4quatu_at_4ax.com...
> On 2 Feb 2005 09:27:59 -0800, "HARI OM" <hari_om_at_hotmail.com> wrote:
>
>>CAN anyone help me or give some hints/pointers to this ERROR.
>>Any related information would be appreciated...
>
> Errors are on http://tahiti.oracle.com
>
> Actually I don't know why you relocated the online redologs using this
> procedure.
> You can just drop a logfile group and create a new one. The procedure
> to do this is described in the Server Administrators Manual.

Suppose this is a cold backup of a database taken on a system with different file layout.

> For now, I think the only chance you have is to cancel the recovery.
>
> Is there any chance you will follow a course to establish some
> fundamental knowledge? Or do you expect this forum is going to teach
> you how to become a DBA for free?

:-)
Anyway - what Mr. Hari Om performed was legal and documented. Apart from the fact that there's no need to "RECOVER AUTOMATIC DATABASE ..." if he did shutdown immediate (normal). But attempt to recover database that doesn't need recovery is also legal and can do no damage, all have to be done is to cancel recovery when asked for non-existing arch.log.

Regards.. Received on Thu Feb 03 2005 - 09:13:10 CST