Thanks for your interesting . Till now ,we have no partner in Korean . We sell PRM as as product , but we also provide recovery service for some case like yours . If system dbf is not lost ,but just corrupted ,
SVRMGR> select * from v$datafile where FILE#=11; 8) Bring the file online. SVRMGR> alter database datafile '/tmp/sample.dbf' online; 9) Recover the datafile. SVRMGR> Recover database; Note: During recovery, all archived redo logs written to since the original datafile was created must ...
SQL> select * from dba_extents where file_id = 2 and 49 between block_id and block_id+blocks-1;no rows selected•In addition to hcheck8i, one way is to evaluate the call stack for the ORA-600 error. In this example it is:ORA-00600: internal error code, arguments: [ktsircinfo_...
UNABLE TO OPEN DATABASE DUE TO ORA-600 [KRSCINT.NO_CUR_LOG] PROBLEM: --- Unable to open a 3 node RAC database. SQL> alter database open; alter database open * ERROR at line 1: ORA-600: internal error code, arguments: [krscint.no_cur_log], [], [], [], 2011-06-24 11:4...
SQL> alter database datafile '<missing name>' online; As of 10g, you can also do this in RMAN. 1) RMAN will create the datafile if there is no backups or copies of this datafile: RMAN> restore datafile <missing file id>; 2) Recover the newly created datafile: ...
11 OFFLINE FILE NOT FOUND 0 01/01/88 00:00:00 (Noting the file number that was reported in the error) 5) SVRMGR> select * from v$datafile where FILE#=11; SAMPLE: FILE# STATUS ENABLED CHECKPOINT BYTES CREATE_BYT NAME --- --- --- --- --- --- --- 11 RECOVER READ WRITE 4.9...
11 OFFLINE FILE NOT FOUND 0 01/01/88 00:00:00 (Noting the file number that was reported in the error) 5) SVRMGR> select * from v$datafile where FILE#=11; SAMPLE: FILE# STATUS ENABLED CHECKPOINT BYTES CREATE_BYT NAME --- --- --- --- --- --- --- 11 RECOVER READ WRITE 4.9...
11 OFFLINE FILE NOT FOUND 0 01/01/88 00:00:00 (Noting the file number that was reported in the error) 5) SVRMGR> select * from v$datafile where FILE#=11; SAMPLE: FILE# STATUS ENABLED CHECKPOINT BYTES CREATE_BYT NAME --- --- --- --- --- --- --- 11 RECOVER READ WRITE 4.9...
Thanks for your interesting . Till now ,we have no partner in Korean . We sell PRM as as product , but we also provide recovery service for some case like yours . If system dbf is not lost ,but just corrupted , we can fix problem and open database without PRM or DUL . The recover...
SQL> alter database datafile '<missing name>' online; As of 10g, you can also do this in RMAN. 1) RMAN will create the datafile if there is no backups or copies of this datafile: RMAN> restore datafile <missing file id>; 2) Recover the newly created datafile: ...