topic Re: After ignite and vxrestore in Operating System - HP-UX

After ignite and vxrestore

Praveen Bezawada — Tue, 22 May 2001 09:12:15 GMT

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

Re: After ignite and vxrestore

Vincenzo Restuccia — Tue, 22 May 2001 09:17:13 GMT

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.

Re: After ignite and vxrestore

W. Sikkens — Tue, 22 May 2001 09:19:03 GMT

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.

Re: After ignite and vxrestore

Praveen Bezawada — Tue, 22 May 2001 09:30:39 GMT

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

Re: After ignite and vxrestore

W. Sikkens — Tue, 22 May 2001 10:27:44 GMT

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.

Re: After ignite and vxrestore

Geetam — Wed, 23 May 2001 08:21:08 GMT

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.