Re: Online-Backup Crash

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 12 Oct 1999 18:32:54 +0800
Message-ID: <38030E56.577B@yahoo.com>

Du Van-Tham (K3/EES1) wrote:
>
> Hi,
> can someone help me ?
>
> The Online Backup of Database crashes. Startup open fails with the
> following errors
>
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: 'E:\ORANT\DATABASE\DBFILE\SYS1ORCL.ORA'
>
> There are two possibilities to recover database.
>
> 1. recover database
> 2. alter database datafile "filename" end backup;
>
> now, my questions are:
>
> if all of data files, control file, redo log files etc. are ok, can
> i always
> apply the methode 2 ?
>
> must the archive disk be mirrored ?
>
> which action must the system additionally do during online-backup ?
>
> Thanks in advance for any help.

You can also just issue 'alter database datafile ... end backup;' which will then allow you to open the database...

No recovery needed.
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Oct 12 1999 - 05:32:54 CDT