ORA-01092: ORACLE instance terminated.
hi,
i have clone a database from test to newDB created pfile,moved all log files,dbf files (except one dbf file) to clone location.created a controlfile and opened in resetlog it forced to disconnection.
Again i logged as sysdba mounted then opened it asked for recovery then recoved successfully.when i tried to open it again disconnected.
Code:
SQL> startup mount pfile=/opt/ora9/admin/clone/pfile/initnew.ora
ORACLE instance started.
Total System Global Area 135337420 bytes
Fixed Size 452044 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/ora9/admin/clone/sys01.dbf'
SQL> recover database;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
This is my alert log Message.
Mon Mar 17 12:10:34 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = /opt/ora9/admin/clone/control01.ctl, /opt/ora9/admin/clone/control02.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = new
dispatchers = (PROTOCOL=TCP) (SERVICE=newXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/ora9/admin/bdump
user_dump_dest = /opt/ora9/admin/udump
core_dump_dest = /opt/ora9/admin/cdump
sort_area_size = 524288
db_name = new
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
LGWR started with pid=4
DBW0 started with pid=3
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Mon Mar 17 12:10:35 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Mar 17 12:10:35 2008
ALTER DATABASE MOUNT
Mon Mar 17 12:10:39 2008
Successful mount of redo thread 1, with mount id 2131011835.
Mon Mar 17 12:10:39 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Mar 17 12:10:47 2008
ALTER DATABASE RECOVER database
Mon Mar 17 12:11:10 2008
Media Recovery Start
Starting datafile 1 recovery in thread 1 sequence 5
Datafile 1: '/opt/ora9/admin/clone/sys01.dbf'
Starting datafile 2 recovery in thread 1 sequence 5
Datafile 2: '/opt/ora9/admin/clone/undo01.dbf'
Starting datafile 4 recovery in thread 1 sequence 5
Datafile 4: '/opt/ora9/admin/clone/rman01.dbf'
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
Mem# 0 errs 0: /opt/ora9/admin/clone/redo01.log
Media Recovery Complete
Completed: ALTER DATABASE RECOVER database
alter database open
Mon Mar 17 12:27:48 2008
Beginning crash recovery of 1 threads
Mon Mar 17 12:27:48 2008
Started first pass scan
Mon Mar 17 12:27:48 2008
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Mon Mar 17 12:27:48 2008
Started recovery at
Thread 1: logseq 5, block 2, scn 0.456941
Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0
Mem# 0 errs 0: /opt/ora9/admin/clone/redo01.log
Mon Mar 17 12:27:48 2008
Completed redo application
Mon Mar 17 12:27:48 2008
Ended recovery at
Thread 1: logseq 5, block 3, scn 0.476942
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Mon Mar 17 12:27:48 2008
Thread 1 advanced to log sequence 6
Thread 1 opened at log sequence 6
Current log# 2 seq# 6 mem# 0: /opt/ora9/admin/clone/redo02.log
Successful open of redo thread 1.
Mon Mar 17 12:27:48 2008
SMON: enabling cache recovery
Mon Mar 17 12:27:48 2008
Errors in file /opt/ora9/admin/udump/new_ora_22889.trc:
ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
Mon Mar 17 12:27:49 2008
Errors in file /opt/ora9/admin/udump/new_ora_22889.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
Mon Mar 17 12:27:49 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 22889
ORA-1092 signalled during: alter database open...
any clue to proceed further..,
Thanks.,