-
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.,
-
Check trace file /opt/ora9/admin/udump/new_ora_22889.trc
Physical corruption is possible.
I would open a TAR with Oracle.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
if i open that trace file new_ora_22889.trc.it runs nearly five screens then at last it shows as
..........
....
AD9B720 00000000 00000000 00000000 00000000 [................]
Repeat 30 times
AD9B910 00000000 00000000 00000000 [............]
qmxdplsuga * qmxdplsuga_p [AD9B91C, AD9B920) = 00000000
qmpauga * qmpauga_p [AD9B920, AD9B924) = 00000000
qmxtcug * qmxtcuga_p [AD9B924, AD9B928) = 00000000
qsmguga * qsmgu_p [AD9B928, AD9B92C) = 00000000
struct _xsawuga * xsawuga_p [AD9B92C, AD9B930) = 00000000
struct _xsoquga * xsoquga_p [AD9B930, AD9B934) = 00000000
ub4 ksmugmg2 [AD9B934, AD9B938) = 0000CDCD
KSTDUMP: In-memory trace dump
TIME:SEQ# ORAPID SID EVENT OP DATA
========================================================================
A2473824:00000000 149 0 10280 1 0x00000095
A2479A4F:00000001 2 0 10280 1 0x00000002
A2480A4C:00000002 3 0 10280 1 0x00000003
A2486070:00000003 4 0 10280 1 0x00000004
A248D0A8:00000004 5 0 10280 1 0x00000005
A249356C:00000005 6 0 10280 1 0x00000006
A2499A03:00000006 7 0 10280 1 0x00000007
A249F16C:00000007 8 0 10280 1 0x00000008
A24A5593:00000008 9 0 10280 1 0x00000009
A5CCDB77:0000000D 9 0 10280 1 0x00000009
B75241E7:0000000E 9 0 10280 1 0x00000009
C8D7AA75:0000000F 9 0 10280 1 0x00000009
DA5D1160:00000010 9 0 10280 1 0x00000009
DD75C537:00000011 9 0 10280 1 0x00000009
A24AC6FE:00000009 10 0 10280 1 0x0000000A
A24B1D97:0000000A 11 0 10280 1 0x0000000B
A24B921A:0000000B 12 0 10280 1 0x0000000C
A28918EA:0000000C 12 0 10280 1 0x0000000C
KSTDUMP: End of in-memory trace dump
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
i tried for the next time the same process repeats..
-
Code:
ORA-00600: internal error code, arguments: [25012], [0], [3], [], [], [], [], []
...means you have a problem on tablespace #0, datafile #3
Since tablespace #0 is usually SYSTEM tablespace I would say you might be in serious troubles.
Physical corruption is possible.
I would open a TAR with Oracle.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Thanks Pavb,
but i have moved all the .dbf files after clean shutdown and then created trace control file (restrict mode) edited then created, and that testDB also working fine now.only clone is making problem. whether there could be a problem that i have removed one datafile in clone DB(newDB).
-
How big is your database?
If you are just cloning a test database you may want to start from scratch.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
its less than 2G only 4 datafiles.
I have started twice from scratch but same error repeats.
-
I assume you have put source database tablespaces in backup mode before making a copy of them, am I correct?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
No,exactly not
I had shutdown --> copied .log and .dbf (except one file)-->opened in restrict -->created a trace file -->edited recreated controlfile -->then tried to open with resetlogs.
-
it should work.
may I ask why are you skipping one datafile?
wouldn't be nicer to move the whole database?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|