Re: Online-Backup Crash

"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 ?

Always is such a strong word, I'll say no.

>
> must the archive disk be mirrored ?

Not a bad idea, but no, it does not 'have' to be mirrored. That is a system design issue that money usually plays a large part in, a good and frequent backup is an option. In an optimal system you would probably want more than just the archives mirrored, I'd mirror the whole server and set it for standby.

>
> which action must the system additionally do during online-backup ?

This question sounds like a homework problem and to answer it you need to find out what the first action they are talking about is before you can name additional actions.

>
> Thanks in advance for any help.

Darren

Received on Tue Oct 12 1999 - 09:37:50 CDT