Re: Backup/Recover datafile doubts..Please help
Date: 1999/11/22
Message-ID: <383961df.753034_at_read.news.globalnet.co.uk>#1/1
On Mon, 22 Nov 1999 16:00:13 +0530, Vidya
<india1_at_bv3c4.austin.ibm.com> wrote:
>Hi ,
Oracle detects the fact that the recoved data file is older than
expected from the control file and presumably gave you an error
message like: ORA-01113: file 6 needs media recovery
Issuing alter database recover datafile instructs the database to
re-apply changes from the online/archived redo-logs as required to
bring the datafile into line with the rest of the database. I imagine
you were simply experimenting so no actual recovery was required, so
the datafile header is simply synchronised with the control file as
stated by your dba friend.
>I did "alter database <database name>
>
>I had backed a Oracle dbf file using backup / restore commands of Unix
>and restored from tape with unix command.
>Then from the Oracle Server Manager I put the file into the database
>but
>it resulted in Media failure.
> recover datafile <path where the datafile has been copied"
>On doing this the database got connected.
>Since I am not a DBA I have these set of doubts :
>Now , my doubts are how has this "alter database ..." command helped in
>correcting the restored dbf file.
>But, my DBA friend told me that "alter database ..." command has helped
>the newer
>restored file in getting seq with Ctrl and database file , is it right ?
>
Received on Mon Nov 22 1999 - 00:00:00 CET