1. Create ASM diskgroup: SQL>create diskgroup DATA External REDUNDANCY DISK '/dev/rhdisk2' 2. Error reported. Cause The cause is 2 terabyte is the maximum storage for each ASM disk (the unpublished Bug 6453944 allowed larger sizes, but that led to problems). The following note provides add...
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_...
No backup or copy of the datafile is required. We only need the redo logs starting from the time of the datafile creation to the current point in time. Note: plugged-in datafiles do not apply in this scenario and needs to be plugged-in again from its source. SOLUTION When a datafile ...
there is a oracle database with archivelog mode, and no backup. A tablespace is dropped, and how to recover? Is there any old copy of the datafiles from the dropped tablespace. For example from a system backup or image? If so, you may possibly be able to extract some of the data ...
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...
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...
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...