Admin/B&R

복구중에 ORA-01114 ORA-01110 ORA-27091

Qhtlr 2008. 2. 15. 09:01


SVRMGR> set autorecovery on
Autorecovery                    ON
SVRMGR> recover database until time '2008-02-01:17:30' using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01114: IO error writing block to file 6 (block # 1)
ORA-01110: data file 6: '/u12/oradata/CLOZ2/rbs01.dbf'
ORA-27091: skgfqio: unable to queue I/O
IBM AIX RISC System/6000 Error: 9: Bad file number
Additional information: 1

Datafile의 소유자를 바꾸지 않아 file permision문제로 발생함.
소유자 변경후 복구 재시작.

SVRMGR> recover database until time '2008-02-01:17:30' using backup controlfile;
ORA-00279: change 9782832845009 generated at 02/01/2008 00:12:18 needed for thread 1
ORA-00289: suggestion : /u14/oradata/ARCH/log30157.arc
ORA-00280: change 9782832845009 for thread 1 is in sequence #30157
Log applied.
ORA-00279: change 9782832892642 generated at 02/01/2008 00:43:26 needed for thread 1
ORA-00289: suggestion : /u14/oradata/ARCH/log30158.arc
ORA-00280: change 9782832892642 for thread 1 is in sequence #30158
ORA-00278: log file '/u14/oradata/ARCH/log30157.arc' no longer needed for this recovery
Log applied.