Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Media recovery, after rename
Linda Hagedorn wrote:
> Hello,
>
> Thanks for the help so far. The database is up, but I'm receiving an error
> message saying media recovery is necessary on one of the files:
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1:
> '/opt/oracle/app/oracle/oradata/PETS/data/system01.dbf'
>
> This instance was build with data files from production, so I don't expect
> any error in the data, and don't have backups to speak of. I can copy from
> production, but since the archive and online logs are present, can I just
> RECOVER DATABASE?
>
You can if you absolutely sure having cold backup online logs and controlfiles. Other datafiles should be consistent with controlfiles or taken BEFORE cold backup. Another speaking - complete recovery is possible.
hth
Vadim Gorbunov
Oracle DBA
>
> Any information is appreciated.
>
> Thanks,
>
> Linda
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 06 2000 - 07:48:15 CDT