实战controlfile修复一例

--1: controlfile problem
Completed: alter database mount
Thu May 15 06:43:37 2008
alter database open
This instance was first to open
Thu May 15 06:43:37 2008
Errors in file /oracle/app/oracle/admin/ucis/bdump/ucis1_dbw0_15287.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/dev/ora_tzvg1/rtzlv_system'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
--2：
alter database backup controlfile to '/oracle/***';
--3:
startup with above controlfile
--4:
alter database open
This instance was first to open
ORA-1589 signalled during: alter database open...
Thu May 15 07:08:34 2008
alter database open resetlogs
Signalling error 1152 for datafile 1!
 Incmplt recovery scn: 0x0433.1de6b9f5ORA-1152 signalled during: alter database open resetlogs...
Thu May 15 07:08:58 2008
--5:
ALTER DATABASE RECOVER  database until cancel
Thu May 15 07:08:58 2008
Media Recovery Start
Thu May 15 07:08:58 2008
Media Recovery failed with error 1610
ORA-283 signalled during: ALTER DATABASE RECOVER  database until cancel  ...
--6:
alter database recover using backup controlfile until cancel
Thu May 15 07:09:29 2008
Media Recovery Start
ORA-279 signalled during: alter database recover using backup controlfile un...
Thu May 15 07:10:12 2008
--7:
shutdown immediate
--8:
startup nomount
alter database mount;
alter database open resetlogs;