Currently Being Moderated
Hello,
I couldn't start my database, this is the log:
Mon Jun 21 00:37:32 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile C:\ORACLE\CDS\PRODUCT\11.2.0\CLICK_DBHOME\DATABASE\SPFILECLICK11G.ORA
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "C:\ORACLE\CLICK11G\ORADATA\CLICK11G\CONTROL01.CTL"
control_files = "C:\ORACLE\CLICK11G\RECOVERY_AREA\CLICK11G\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "C:\Oracle\Click11g\recovery_area"
db_recovery_file_dest_size= 25G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=click11gXDB)"
audit_file_dest = "C:\ORACLE\CLICK11G\ADMIN\CLICK11G\ADUMP"
audit_trail = "DB"
db_name = "click11g"
open_cursors = 300
diagnostic_dest = "C:\ORACLE\CLICK11G"
Mon Jun 21 00:37:32 2010
PMON started with pid=2, OS id=736
Mon Jun 21 00:37:32 2010
VKTM started with pid=3, OS id=1484 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Jun 21 00:37:32 2010
GEN0 started with pid=4, OS id=2944
Mon Jun 21 00:37:32 2010
DIAG started with pid=5, OS id=1512
Mon Jun 21 00:37:32 2010
DBRM started with pid=6, OS id=2304
Mon Jun 21 00:37:33 2010
PSP0 started with pid=7, OS id=2892
Mon Jun 21 00:37:33 2010
DIA0 started with pid=8, OS id=2064
Mon Jun 21 00:37:33 2010
MMAN started with pid=9, OS id=3044
Mon Jun 21 00:37:33 2010
DBW0 started with pid=10, OS id=2340
Mon Jun 21 00:37:33 2010
LGWR started with pid=11, OS id=2668
Mon Jun 21 00:37:33 2010
CKPT started with pid=12, OS id=2844
Mon Jun 21 00:37:33 2010
SMON started with pid=13, OS id=2108
Mon Jun 21 00:37:33 2010
RECO started with pid=14, OS id=3052
Mon Jun 21 00:37:33 2010
MMON started with pid=15, OS id=2168
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 21 00:37:33 2010
MMNL started with pid=16, OS id=3056
starting up 1 shared server(s) ...
ORACLE_BASE from environment = C:\Oracle\Click11g
Mon Jun 21 00:37:33 2010
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 2405271053
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Mon Jun 21 00:37:38 2010
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Started redo scan
Completed redo scan
read 13627 KB redo, 0 data blocks need recovery
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc (incident=51767):
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
Incident details in: c:\oracle\click11g\diag\rdbms\click11g\click11g\incident\incdir_51767\click11g_ora_1992_i51767.trc
Aborting crash recovery due to error 600
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
Errors in file c:\oracle\click11g\diag\rdbms\click11g\click11g\trace\click11g_ora_1992.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [107], [57549], [57552], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Trace dumping is performing id=[cdmp_20100621003740]
Where is the problem ?
I performed recovery using EM, but the database couldn't start.
I just want single package from this database, how could I restore this tablespace or get any type of export?
thanks very much
