|
|
|
|
|
|
|
|
|
|
Re: target db not open after create AUXiliary instance [message #319357 is a reply to message #319355] |
Sat, 10 May 2008 01:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
I really don't understand your answer, I understand you don't know how to read the file but maybe WE can but if you don't post it we can't help.
Post the last part since the startup command until the error ORA-01102: cannot mount database in EXCLUSIVE mode.
Of course, if you don't want to be helped you can stay in this behaviour, offending the one that try to help you.
Regards
Michel
[Updated on: Sat, 10 May 2008 01:17] Report message to a moderator
|
|
|
Re: target db not open after create AUXiliary instance [message #319359 is a reply to message #319357] |
Sat, 10 May 2008 01:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
malvika
Messages: 55 Registered: May 2008 Location: india
|
Member |
![mistry_malvika056%40yahoo.com](/forum/theme/orafaq/images/yahoo.png) ![malvika.mistry@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
thaks bro........,
and sorry for my this odd behaviour ...bro.........
here i send you my alert.log file if you find the problem of my database started then please help me and aslo, tell me how to implement it.
SQL> startup pfile=$ORACLE_HOME/dbs/initEASTLEG.ora
ORACLE instance started.
Total System Global Area 1140397296 bytes
Fixed Size 451824 bytes
Variable Size 352321536 bytes
Database Buffers 786432000 bytes
Redo Buffers 1191936 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
[Updated on: Sat, 10 May 2008 01:42] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: loss all controlefile want to restart database [message #319513 is a reply to message #319508] |
Mon, 12 May 2008 01:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
malvika
Messages: 55 Registered: May 2008 Location: india
|
Member |
![mistry_malvika056%40yahoo.com](/forum/theme/orafaq/images/yahoo.png) ![malvika.mistry@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE GROUP 1 ('/newdata/app/oracle/oradata/EASTLEG/redo01.log') SIZE 100M,
GROUP 2 ('/newdata/app/oracle/oradata/EASTLEG/redo02.log') SIZE 100M,
GROUP 3 ('/newdata/app/oracle/oradata/EASTLEG/redo03.log') SIZE 100M
DATAFILE '/newdata/app/oracle/oradata/EASTLEG/system01.dbf' SIZE 300M,
'/newdata/app/oracle/oradata/EASTLEG/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/EASTLEG/indx01.dbf' SIZE 300M;
SQL> @$ORACLE_HOME/dbs/createEASTLEGctl.sql
CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 38400 (blocks), but should match header 128000
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG/system01.dbf'
i change the system01.dbf size using this equations..
Expected size = Expected # of blocks * db_block_size / 1024
= 38400 * 8192/1024
= 307200
--------------
change code
----------
CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE GROUP 1 ('/newdata/app/oracle/oradata/EASTLEG/redo01.log') SIZE 100M,
GROUP 2 ('/newdata/app/oracle/oradata/EASTLEG/redo02.log') SIZE 100M,
GROUP 3 ('/newdata/app/oracle/oradata/EASTLEG/redo03.log') SIZE 100M
DATAFILE '/newdata/app/oracle/oradata/EASTLEG/system01.dbf' SIZE 307200K,
'/newdata/app/oracle/oradata/EASTLEG/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/EASTLEG/indx01.dbf' SIZE 300M;
but this error display...
CREATE CONTROLFILE REUSE DATABASE "EASTLEG" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 38400 (blocks), but should match header 128000
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG/system01.dbf'
|
|
|
|
Re: loss all controlefile want to restart database [message #319528 is a reply to message #319516] |
Mon, 12 May 2008 02:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
malvika
Messages: 55 Registered: May 2008 Location: india
|
Member |
![mistry_malvika056%40yahoo.com](/forum/theme/orafaq/images/yahoo.png) ![malvika.mistry@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
thanks
controlfile is created.
but database not open b'cus it need media recovery .
and i haven't any backup .
so what i do next.
and if i connect to EASTLEG database then it gives this error.
SQL> connect sys/mataji@eastleg;
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
Warning: You are no longer connected to ORACLE.
[Updated on: Mon, 12 May 2008 02:04] Report message to a moderator
|
|
|
|
Re: loss all controlefile want to restart database [message #319545 is a reply to message #319544] |
Mon, 12 May 2008 02:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
malvika
Messages: 55 Registered: May 2008 Location: india
|
Member |
![mistry_malvika056%40yahoo.com](/forum/theme/orafaq/images/yahoo.png) ![malvika.mistry@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
thanks.
------------------------------
this is the alertCATDB.log file can you tell me what is the error for CATDB DATABASE not start.
---------------------------
Fri May 9 10:27:14 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 = 300
timed_statistics = TRUE
shared_pool_size = 536870912
sga_max_size = 1615403728
shared_pool_reserved_size= 52428800
large_pool_size = 16777216
java_pool_size = 83886080
control_files = /u02/app/oracle/admin/CATDB/catdb1.ctl
db_block_size = 8192
db_writer_processes = 4
db_cache_size = 805306368
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest_1 = location=/u02/app/oracle/admin/CATDB/arch
log_archive_max_processes= 6
log_archive_format = arch_catdb_%s.log
log_buffer = 104857600
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
log_checkpoints_to_alert = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = CATDB
dispatchers = (PROTOCOL=TCP) (SERVICE=atuldbXDB)
session_cached_cursors = 200
utl_file_dir = /home/oracle9i
job_queue_processes = 20
_job_queue_interval = 60
cursor_sharing = EXACT
hash_join_enabled = TRUE
background_dump_dest = /u02/app/oracle/admin/CATDB/bdump
user_dump_dest = /u02/app/oracle/admin/CATDB/udump
core_dump_dest = /u02/app/oracle/admin/CATDB/cdump
sort_area_size = 524288
db_name = CATDB
open_cursors = 999
star_transformation_enabled= FALSE
query_rewrite_enabled = TRUE
query_rewrite_integrity = TRUSTED
pga_aggregate_target = 786432000
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
DBW2 started with pid=5
DBW3 started with pid=6
LGWR started with pid=7
CKPT started with pid=8
SMON started with pid=9
RECO started with pid=10
CJQ0 started with pid=11
QMN0 started with pid=12
Fri May 9 10:27:25 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=15
ARC0: Archival started
ARC1 started with pid=16
ARC1: Archival started
ARC2 started with pid=17
ARC2: Archival started
ARC3 started with pid=18
ARC3: Archival started
ARC4 started with pid=19
ARC4: Archival started
ARC5 started with pid=20
Fri May 9 10:27:28 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri May 9 10:27:28 2008
ARC1: Thread not mounted
Fri May 9 10:27:28 2008
ARC5: Archival started
Fri May 9 10:27:28 2008
ARC5: Thread not mounted
Fri May 9 10:27:28 2008
ARC2: Thread not mounted
Fri May 9 10:27:28 2008
Fri May 9 10:27:28 2008
ARC3: Thread not mounted
ARC0: Thread not mounted
Fri May 9 10:27:28 2008
ARC4: Thread not mounted
Fri May 9 10:28:21 2008
CREATE DATABASE CATDB
USER SYS IDENTIFIED BY
USER SYSTEM IDENTIFIED BY **** MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE GROUP 1 ('/newdata/app/oracle/oradata/CATDB/redo01.log') SIZE 100M,
GROUP 2 ('/newdata/app/oracle/oradata/CATDB/redo02.log') SIZE 100M,
GROUP 3 ('/newdata/app/oracle/oradata/CATDB/redo03.log') SIZE 100M
DATAFILE '/newdata/app/oracle/oradata/CATDB/system01.dbf' SIZE 300M,
'/newdata/app/oracle/oradata/CATDB/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/CATDB/indx01.dbf' SIZE 300M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/newdata/app/oracle/oradata/CATDB/undotbs01.dbf' SIZE 200M
REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
Fri May 9 10:28:21 2008
Restarting dead background process QMN0
QMN0 started with pid=12
Fri May 9 10:28:21 2008
Database mounted in Exclusive Mode.
Fri May 9 10:28:32 2008
Successful mount of redo thread 1, with mount id 2199994309.
Assigning activation ID 2199994309 (0x83213fc5)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /newdata/app/oracle/oradata/CATDB/redo01.log
Successful open of redo thread 1.
Fri May 9 10:28:34 2008
SMON: enabling cache recovery
Fri May 9 10:28:34 2008
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in
future release
Fri May 9 10:28:34 2008
ARC1: Media recovery disabled
Fri May 9 10:28:34 2008
create tablespace SYSTEM datafile '/newdata/app/oracle/oradata/CATDB/system01
.dbf' SIZE 300M,
'/newdata/app/oracle/oradata/CATDB/drsys01.dbf' SIZE 200M,
'/newdata/app/oracle/oradata/CATDB/indx01.dbf' SIZE 300M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Fri May 9 10:28:55 2008
Completed: create tablespace SYSTEM datafile '/newdata/app
Fri May 9 10:28:56 2008
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Fri May 9 10:29:07 2008
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/newdata/app/oracle/oradata/CATDB/und
otbs01.dbf' SIZE 200M
REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Fri May 9 10:29:11 2008
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/newdat
Fri May 9 10:29:14 2008
Beginning local checkpoint up to RBA [0x1.5a0d.10], SCN: 0x0000.00001e6b
Fri May 9 10:29:14 2008
SMON: enabling tx recovery
Completed checkpoint up to RBA [0x1.5a0d.10], SCN: 0x0000.00001e6b
replication_dependency_tracking turned off (no async multimaster replication fou
nd)
Completed: CREATE DATABASE CATDB
USER SYS IDENTIFIED BY
USER
Fri May 9 10:33:36 2008
Restarting dead background process QMN0
QMN0 started with pid=12
Fri May 9 10:33:49 2008
Starting ORACLE instance (normal)
Fri May 9 10:38:52 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:44:05 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:49:18 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:52:38 2008
Beginning log switch checkpoint up to RBA [0x2.2.10], SCN: 0x0000.00007aec
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: /newdata/app/oracle/oradata/CATDB/redo02.log
Fri May 9 10:52:41 2008
ARC2: Media recovery disabled
Fri May 9 10:54:35 2008
Restarting dead background process QMN0
QMN0 started with pid=21
Fri May 9 10:55:47 2008
Completed checkpoint up to RBA [0x2.2.10], SCN: 0x0000.00007aec
Fri May 9 10:57:07 2008
Beginning log switch checkpoint up to RBA [0x3.2.10], SCN: 0x0000.0000c00f
Thread 1 advanced to log sequence 3
Current log# 3 seq# 3 mem# 0: /newdata/app/oracle/oradata/CATDB/redo03.log
Fri May 9 10:57:10 2008
ARC4: Media recovery disabled
Fri May 9 11:27:59 2008
Completed checkpoint up to RBA [0x3.2.10], SCN: 0x0000.0000c00f
Fri May 9 11:38:37 2008
Beginning log switch checkpoint up to RBA [0x4.2.10], SCN: 0x0000.00014376
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: /newdata/app/oracle/oradata/CATDB/redo01.log
Fri May 9 11:38:39 2008
ARC0: Media recovery disabled
Fri May 9 11:55:22 2008
create tablespace rman datafile '/newdata/app/oracle/oradata/CATDB/rman01.dbf' s
ize 300M autoextend on
Fri May 9 11:55:30 2008
Completed: create tablespace rman datafile '/newdata/app/orac
Fri May 9 12:09:30 2008
Completed checkpoint up to RBA [0x4.2.10], SCN: 0x0000.00014376
-----------------------------------------------------
[Updated on: Mon, 12 May 2008 02:58] Report message to a moderator
|
|
|