on 12-17-2008 8:14 AM
Hi All,
yesterday my system is suddenly shutdown and when i try to start from SAPMMC then the Work+Disp is first go on Running but Dialog Queue standstill, J2EE status is unvailable and then it stopped.
when i try to start SQLPLUS "/as Sysdba"
then i m receiving following message:
SQL> startup
ORACLE instance started.
Total System Global Area 679477248 bytes
Fixed Size 2056000 bytes
Variable Size 348127424 bytes
Database Buffers 322961408 bytes
Redo Buffers 6332416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'F:\ORACLE\MDS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
while i have installed ECC6.0 SR3(JAVA+ABAP and MI & DI Usage Type) on Window 64 bit edition for MDSD.
how can i resolve this issue....
regards,
majamil
try this:
sqlplus / as sysdba
shutdown immediate;
startup
you should get error, now try:
recover;
if you get media recovery complete:
alter database open;
if it fails:
recover using backup controlfile until cancel
when finished:
alter database open;
now pray that it works. still failing? it's time to restore.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric,
thanks for reply and here i m looking green signal following.... plz check it and tell me for further proceeding.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 679477248 bytes
Fixed Size 2056000 bytes
Variable Size 348127424 bytes
Database Buffers 322961408 bytes
Redo Buffers 6332416 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'F:\ORACLE\MDS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
SQL> recover;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>
cheers,
thanks for replies,
Dear here required ur favors ..... if my system did not recover then there was last option of Restore DB. So, if i restore DB then which steps are necessitate for restore.
here i m working on DR and performing these steps:
this is for Testing Purpose
1. copy and paste daily Oraarch from PRD to DR
2. SQL> startup mount
3. SQL> recover database using backup controlfile;
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
when recovery completed then run following command.
4. SQL> recover database using backup controlfile;
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
IF PRD will be down then run below command after recover database.
5. SQL> alter database open resetlogs
if i login to DR then what will i do for further?
regards,
The disp+work.exe can´t start because your database is not coming up.
Please check the note suggested. You may need to recover the database from a backup.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please check with the following Note 13789 - Recovery on error ORA-1113
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please post error lines from dev_w0 from work directory
(/usr/sap/sid/dvebmgs00/work)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Rahul,
Dev_w0 log is
---------------------------------------------------
trc file: "dev_w0", trc level: 1, release: "700"
---------------------------------------------------
*
* ACTIVE TRACE LEVEL 1
* ACTIVE TRACE COMPONENTS all, MJ
*
B
B Wed Dec 17 13:36:27 2008
B create_con (con_name=R/3)
B Loading DB library 'F:\usr\sap\MDS\DVEBMGS00\exe\dboraslib.dll' ...
B Library 'F:\usr\sap\MDS\DVEBMGS00\exe\dboraslib.dll' loaded
B Version of 'F:\usr\sap\MDS\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.144)
B New connection 0 created
M sysno 00
M sid MDS
M systemid 562 (PC with Windows NT)
M relno 7000
M patchlevel 0
M patchno 144
M intno 20050900
M make: multithreaded, Unicode, 64 bit, optimized
M pid 2372
M
M kernel runs with dp version 232000(ext=109000) (@(#) DPLIB-INT-VERSION-232000-UC)
M length of sys_adm_ext is 576 bytes
M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2372) [dpxxdisp.c 1305]
I MtxInit: 30000 0 0
M DpSysAdmExtCreate: ABAP is active
M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active
M DpShMCreate: sizeof(wp_adm) 25168 (1480)
M DpShMCreate: sizeof(tm_adm) 5652128 (28120)
M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)
M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)
M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080
M DpShMCreate: sizeof(comm_adm) 552080 (1088)
M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0
M DpShMCreate: sizeof(slock_adm) 0 (104)
M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0
M DpShMCreate: sizeof(file_adm) 0 (72)
M DpShMCreate: sizeof(vmc_adm) 0 (1864)
M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)
M DpShMCreate: sizeof(gw_adm) 48
M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000010E70050, size: 6348592)
M DpShMCreate: allocated sys_adm at 0000000010E70050
M DpShMCreate: allocated wp_adm at 0000000010E72150
M DpShMCreate: allocated tm_adm_list at 0000000010E783A0
M DpShMCreate: allocated tm_adm at 0000000010E78400
M DpShMCreate: allocated wp_ca_adm at 00000000113DC2A0
M DpShMCreate: allocated appc_ca_adm at 00000000113E2060
M DpShMCreate: allocated comm_adm at 00000000113E3FA0
M DpShMCreate: system runs without slock table
M DpShMCreate: system runs without file table
M DpShMCreate: allocated vmc_adm_list at 000000001146AC30
M DpShMCreate: allocated gw_adm at 000000001146ACB0
M DpShMCreate: system runs without vmc_adm
M DpShMCreate: allocated ca_info at 000000001146ACE0
M DpShMCreate: allocated wall_adm at 000000001146ACF0
M ThTaskStatus: rdisp/reset_online_during_debug 0
X EmInit: MmSetImplementation( 2 ).
X MM global diagnostic options set: 0
X <ES> client 0 initializing ....
X Using implementation view
X <EsNT> Using memory model view.
M <EsNT> Memory Reset disabled as NT default
X ES initialized.
M
M Wed Dec 17 13:36:28 2008
M ThInit: running on host sapmdsd
M
M Wed Dec 17 13:36:29 2008
M calling db_connect ...
C Prepending F:\usr\sap\MDS\DVEBMGS00\exe to Path.
C
C Wed Dec 17 13:36:30 2008
C Oracle Client Version: '10.2.0.2.0'
C Client NLS settings: AMERICAN_AMERICA.UTF8
C Logon as OPS$-user to get SAPSR3's password
C Connecting as /@MDS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 00000000138DFFA0 000000000A7FE2D0 0000000013903948
C Attaching to DB Server MDS (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
C Starting user session (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38,usrhp=000000000A7FEAE8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11044]
C Try to connect with default password
C Connecting as SAPSR3/<pwd>@MDS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 UTF8 1 00000000138DFFA0 000000000A7FE2D0 0000000013903948
C Attaching to DB Server MDS (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
C
C Wed Dec 17 13:36:31 2008
C Starting user session (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38,usrhp=000000000A7FEAE8)
C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
[dboci.c 4532]
C Detaching from DB Server (con_hdl=0,svchp=0000000013903808,srvhp=0000000013905C38)
C *** ERROR => CONNECT failed with sql error '1033'
[dbsloci.c 11044]
B ***LOG BV3=> severe db error 1033 ; work process is stopped [dbsh#2 @ 1199] [dbsh 1199 ]
B ***LOG BY2=> sql error 1033 performing CON [dblink#5 @ 431] [dblink 0431 ]
B ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#5 @ 431] [dblink 0431 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]
M
M Info for wp 0
M
M stat = WP_RUN
M waiting_for = NO_WAITING
M reqtype = DP_RQ_DIAWP
M act_reqtype = NO_REQTYPE
M rq_info = 0
M tid = -1
M mode = 255
M len = -1
M rq_id = 65535
M rq_source =
M last_tid = 0
M last_mode = 0
M semaphore = 0
M act_cs_count = 0
M csTrack = 0
M csTrackRwExcl = 0
M csTrackRwShrd = 0
M mode_cleaned_counter = 0
M control_flag = 0
M int_checked_resource(RFC) = 0
M ext_checked_resource(RFC) = 0
M int_checked_resource(HTTP) = 0
M ext_checked_resource(HTTP) = 0
M report = > <
M action = 0
M tab_name = > <
M attachedVm = no VM
M
M *****************************************************************************
M *
M * LOCATION SAP-Server sapmdsd_MDS_00 on host sapmdsd (wp 0)
M * ERROR ThInit: db_connect
M *
M * TIME Wed Dec 17 13:36:31 2008
M * RELEASE 700
M * COMPONENT Taskhandler
M * VERSION 1
M * RC 13
M * MODULE thxxhead.c
M * LINE 10688
M * COUNTER 1
M *
M *****************************************************************************
M
M PfStatDisconnect: disconnect statistics
M Entering TH_CALLHOOKS
M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP
M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 724]
M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 261]
M Entering ThSetStatError
M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)
M Entering ThReadDetachMode
M call ThrShutDown (1)...
M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2372) [dpnttool.c 327]
regards,
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.