-
Hi guys,
I looked at my test instance's alert log and believe that i did make a mess on my test instance. Please look at my today test's alert message and please suggest what i should do:
Fri Jan 26 08:36:13 2001
Shutting down instance (immediate)
License high water mark = 1
Fri Jan 26 08:36:13 2001
alter database close normal
Fri Jan 26 08:36:13 2001
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jan 26 08:36:14 2001
Thread 1 closed at log sequence 999
Current log# 3 seq# 999 mem# 0: /usr2/oracle/arc/dblogrtp3.dbf
Fri Jan 26 08:36:14 2001
Completed: alter database close normal
Fri Jan 26 08:36:14 2001
alter database dismount
Completed: alter database dismount
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 7.1.4.1.0.
System parameters with non-default values:
processes = 200
shared_pool_size = 6000000
control_files = $ORACLE_HOME/dbs/c1arc.ctl, /usr2/oracle/arc/c2arc.ctl, /usr3/oracle/arc/c3arc.ctl
db_block_buffers = 1200
log_archive_start = TRUE
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 20
rollback_segments = rb_1, rb_2, rb_3, rb_4, rb_5, rb_6, rb_7, rb_8
sequence_cache_entries = 100
sequence_cache_hash_buckets= 89
remote_login_passwordfile= NONE
mts_service = arc
mts_servers = 0
mts_max_servers = 0
mts_max_dispatchers = 0
audit_trail = NONE
sort_area_retained_size = 65536
db_name = arc
open_cursors = 200
ifile = $ORACLE_HOME/dbs/cfarc.ora
background_dump_dest = $ORACLE_HOME/rdbms/log
user_dump_dest = $ORACLE_HOME/rdbms/log
max_dump_file_size = 10240
core_dump_dest = $ORACLE_HOME/dbs
PMON started
DBWR started
ARCH started
LGWR started
RECO started
Fri Jan 26 08:47:04 2001
alter database mount exclusive
Fri Jan 26 08:47:04 2001
Completed: alter database mount exclusive
Fri Jan 26 08:47:04 2001
alter database open
Fri Jan 26 08:47:05 2001
Thread 1 opened at log sequence 999
Current log# 3 seq# 999 mem# 0: /usr2/oracle/arc/dblogrtp3.dbf
Fri Jan 26 08:47:06 2001
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Jan 26 08:47:06 2001
Completed: alter database open
Fri Jan 26 08:50:33 2001
alter database backup controlfile to trace noresetlogs
Completed: alter database backup controlfile to trace noreset...
Fri Jan 26 08:53:40 2001
Shutting down instance (immediate)
License high water mark = 1
Fri Jan 26 08:53:40 2001
alter database close normal
Fri Jan 26 08:53:40 2001
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jan 26 08:53:42 2001
Thread 1 closed at log sequence 999
Current log# 3 seq# 999 mem# 0: /usr2/oracle/arc/dblogrtp3.dbf
Fri Jan 26 08:53:42 2001
Completed: alter database close normal
Fri Jan 26 08:53:42 2001
alter database dismount
Completed: alter database dismount
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 7.1.4.1.0.
System parameters with non-default values:
(info is deleted by jn1971)
PMON started
DBWR started
ARCH started
LGWR started
RECO started
Fri Jan 26 08:54:49 2001
CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 50
MAXINSTANCES 1
MAXLOGHISTORY 100
LOGFILE
GROUP 1 '/usr2/oracle/arc/dblogrtp1.dbf' SIZE 2M,
GROUP 2 '/usr2/oracle/arc/dblogrtp2.dbf' SIZE 2M,
GROUP 3 '/usr2/oracle/arc/dblogrtp3.dbf' SIZE 2M,
GROUP 4 '/usr2/oracle/arc/dblogrtp4.dbf' SIZE 2M
DATAFILE
'/usr3/oracle/arc/dborartp.dbf' SIZE 30M,
'/usr2/oracle/arc/rtprb01.dbf' SIZE 200M,
'/usr3/oracle/arc/rtpdat01.dbf' SIZE 150M,
'/usr2/oracle/arc/rtptemp01.dbf' SIZE 30M,
'/usr3/oracle/arc/rtpidx01.dbf' SIZE 30M,
'/usr2/oracle/arc/rtptool01.dbf' SIZE 10M,
'/usr3/oracle/arc/prestdata1.dbf' SIZE 90M,
'/usr2/oracle/arc/rtpuser01.dbf' SIZE 50M,
'/usr2/oracle/arc/rtptempu01.dbf' SIZE 50M,
'/usr3/oracle/arc/prestdata2.dbf' SIZE 90M,
'/usr3/oracle/arc/rtpdat02.dbf' SIZE 50M,
'/usr3/oracle/arc/rtpdat04.dbf' SIZE 100M,
'/usr3/oracle/arc/rtpidx02.dbf' SIZE 30M,
'/usr3/oracle/arc/rtpidx03.dbf' SIZE 60M,
'/usr3/oracle/arc/rtpidx04.dbf' SIZE 30M,
'/usr3/oracle/arc/rtpidx05.dbf' SIZE 100M,
'/usr3/oracle/arc/rtpidx06.dbf' SIZE 100M,
'/usr2/oracle/arc/rtptemp02.dbf' SIZE 50M,
'/usr3/oracle/arc/rtpdat03.dbf' SIZE 100M,
'/usr2/oracle/arc/rtptempu02.dbf' SIZE 50M
Fri Jan 26 08:54:50 2001
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOG...
Fri Jan 26 08:54:50 2001
ALTER DATABASE OPEN
ORA-1507 signalled during: ALTER DATABASE OPEN...
Fri Jan 26 09:01:58 2001
Starting ORACLE instance (normal)
Fri Jan 26 09:01:58 2001
CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOGS NOARCHIVELOG
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ARC" NORESETLOG...
(detial is deleted by jn1971)
Fri Jan 26 09:01:58 2001
alter database recover DATABASE
ORA-1507 signalled during: alter database recover DATABASE...
Fri Jan 26 09:01:58 2001
alter database recover cancel
ORA-1507 signalled during: alter database recover cancel...
Fri Jan 26 09:01:58 2001
ALTER DATABASE OPEN
ORA-1507 signalled during: ALTER DATABASE OPEN...
ARC is sid of my test instance. Please help.
Thanks,
jn1971 :(
-
Check your alert log! see what it says. We can proceed from there.
-
This is what you have to do:
. Shutdown your instance
. Make sure that there is no background processing running for this instance
(run ps -ef | grep -i oracle, kill if required or do a shutdown abort)
. Its good idea to move the existing redologs to a new location
sometimes you might need it for recovery purposes.
. move or rename your control files (you can also use the reuse clause)
. Verify that your create control file is something like this :
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PM1" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 '/oradata/pm1/vg01_01/redo_01.log' SIZE 126M,
GROUP 2 '/oradata/pm1/vg01_01/redo_02.log' SIZE 126M,
GROUP 3 '/oradata/pm1/vg01_01/redo_03.log' SIZE 126M
DATAFILE
'/oradata/pm1/vg01_01/system_01.dbf',
'/oradata/pm1/vg01_01/rbs1_01.dbf',
'/oradata/pm1/vg01_01/rbs2_01.dbf',
'/oradata/pm1/vg01_01/users_01.dbf',
'/oradata/pm1/vg01_01/tools_01.dbf',
'/oradata/pm1/vg01_01/pm1_med01.dbf'
;
I am assuming you have a script that does the above eg :makecontrol.sql
. you may have to use resetlogs (its been a while since I did this)
. make sure your sid is set accordingly (. oraenv)
. start a server mamager session :
. svrmgrl
. connect internal
. @makecontrol.sql
. you can now try an alter database open command to see if the database will come up
. if it says it needs recovery, do the recovery (recover database or
recover database until cancel).
. you should not have any problems bringing your database back up!.
-
Its fixed
Hi guys And Gram2000,
My instance is fine know and i did recreate the controlfiles successfully. The prolem was that I typed
setenv oracle_sid test
not
setenv ORACLE_SID test
Unix does take serious about case sensitivity.
I could shut down the instance and follow your suggestions to create controlfiles.
THANKS VERY MUCH ALL OF YOU OUT THERE FOR HELPING ME.
THANKS,
jn1971
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
|