ORA-00600 [2662] [message #190915] |
Sat, 02 September 2006 07:31 |
hmechbal
Messages: 1 Registered: September 2006 Location: Morocco
|
Junior Member |
|
|
hello
every night we copy of database from production by FTP, this morning the DB is not up and i receive the ORA-00600 message with arguments :
[2662], [0], [478318873], [0], [478361535], [25165833] while opening the database.
Our metalink account had expired please help ..
we are on 9.2.0.3
thanks
|
|
|
|
Re: ORA-00600 [2662] [message #191389 is a reply to message #190915] |
Wed, 06 September 2006 01:56 |
wwllzpz
Messages: 11 Registered: December 2005 Location: shanghai china
|
Junior Member |
|
|
hi,
ORA-600 [2662] "Block SCN is ahead of Current SCN".
ORA-600 [2662] [a] [b] [c] [d] [e]
Arg [a] Current SCN WRAP
Arg [b] Current SCN BASE
Arg [c] dependent SCN WRAP
Arg [d] dependent SCN BASE
Arg [e] Where present this is the DBA where the dependent SCN came from.
because your db (current scn=478318873) < (dependent SCN=478361535),so you encounter the error.
have a try,issue the following command
1.connect /as sysdba;
2.alter session set events '10015 trace name adjust_scn level 1';
3.export full DB.
4.rebuild database and import.
any questions contact me .
|
|
|