After ignite and vxrestore

[Praveen Bezawada]

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

[Vincenzo Restuccia]

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]

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]

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]

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]

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.