cancel
Showing results for 
Search instead for 
Did you mean: 

After ignite and vxrestore

Praveen Bezawada
Respected Contributor

After ignite and vxrestore

Hi
We have a system with 1 root disk and 2 oracle disks.
We have restored the system from ignite and the oracle disks from vxdumps. But now when I want to start the databases I get the error
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oraswr/databasedbmp1/db1/system01.dbf'
Is there any order in which the vxdumps and make_recovery needs to be done.

Thanks in advance
Praveen
5 REPLIES
Vincenzo Restuccia
Honored Contributor

Re: After ignite and vxrestore

ORA-01110: datafile name: str
Cause: This message reports the filename involved with other messages.

Action: See the associated messages for a description of the problem.


ORA-01113: file name needs media recovery
Cause: An attempt was made to open a datafile that is in need of media recovery.

Action: First apply media recovery to the datafile identified in the message, then retry the operation.


W. Sikkens
Advisor

Re: After ignite and vxrestore

You did it the right way.
You will need a recovery for the specified datafile. For this to work you have te have access to your (archived)-redo log files. If you have just connect internal to svrmgrl and type recover database.
Wietze.
Praveen Bezawada
Respected Contributor

Re: After ignite and vxrestore

Hi
when i try to recover the database i get the error
ORA-00279: change 5701151 generated at 05/11/01 01:37:56 needed for thread 1
ORA-00289: suggestion : /opt/oraswr/app/oracle/product/8.0.5/dbs/arch1_12145.dbf
ORA-00280: change 5701151 for thread 1 is in sequence #12145
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/opt/oraswr/app/oracle/product/8.0.5/dbs/arch1_12145.dbf'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
W. Sikkens
Advisor

Re: After ignite and vxrestore

The files mentioned there are your archived redolog files. If you don't have them you'll have to restore them to the locatiuon mentioned in the path.
Geetam
Frequent Advisor

Re: After ignite and vxrestore

It sounds like Oracle had the datafiles open during the backup. Oracle refuses to recover from a backup which was made while Oracle was running.
Either you need to shut the database down for the duration of the backup (cold backup - easy backup/recovery and most reliable method). Or you need to implement a hot backup method (which would create consistent copies of the Oracle datafiles, which you would backup and use for recovery). Hot backups are not simple, you need Oracle expertise.