Question:
Dear all :
I can't logon our R/3 system.the error message is :
" A >>>>>>>>>>>>>>DB Error 0 "
All of the log file is noraml. no error message.
BTW, when i excaute online backup.there are some error message.
------------------------------------------------------------------------------------
------------------------------------------------------------------------------------
BR280I Time stamp 2002-12-31 20.26.53
BR063I 50 of 60 files processed - 25369.188 MB of 29165.609 MB done
BR204I Percentage done: 86.98%, estimated end time: 21:18
BR001I *******************************************_______
BR280I Time stamp 2002-12-31 20.26.54
BR317I 'Alter tablespace PSAPSTABD end backup' successful
BR280I Time stamp 2002-12-31 20.26.54
BR301E SQL error -1122 at location BrTspAlter-3
ORA-01122: database file 44 failed verification check
ORA-01110: data file 44: '/oracle/DR3/sapdata5/stabi_3/stabi.data3'
ORA-01251: Unknown File Header Version read for file number 44
BR280I Time stamp 2002-12-31 20.26.54
BR316E 'Alter tablespace PSAPSTABI begin backup' failed
BR056I End of database backup: bdjqsnla.ant 2002-12-31 20.26.54
BR280I Time stamp 2002-12-31 20.26.57
BR054I BRBACKUP terminated with errors
-------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------
I find notes about ORA-01110,but sap recommend i can ignore it.
And i can user svrmgrl connect internal and sapr3.and i can select something from sap table.
Our system platform is :
Solaris 7 ,Oracle 8.1.6 , 46C R/3
Would you help me ?
Answer:
Hi jeminy
1. Check the file if there is an error in the file
'/oracle/DR3/sapdata5/stabi_3/stabi.data3'
2. Check tablespace using sapdba 'PSAPSTABI'
3. try reconnect the database.
_________________
Regards
Etalks
Answer:
Dear etalks:
I'm very glad you can reply me so quickly
Thank you from my bottom of my heart first
But i don't know how to follow you instruction
In SAPDBA i excaute the following step:
1,k - DB check/verification
2, a - Database System Check (the message is :
Info: Can not insert log info into table 'SAPR3.DBAOBJL
'
ORA-00376: file 44 cannot be read at this time
ORA-01110: data file 44: '/oracle/DR3/sapdata5/stabi_3/stabi.data3'
Press <return> to continue ...
3, <enter> and the relevant critical message is following:
DB Operations:
aly (#1)
failed in last run.
opt (#1)
failed in last run.
rsi (#1)
failed in last run.
rtc (#1)
failed in last run.
rtd (#1)
failed in last run.
Press <return> to continue ...
Alert log messages:
ORA-1113
ORA-1115
ORA-1122
ORA-1135
ORA-1149
ORA-1555
ORA-1562
ORA-1578
ORA-272
ORA-3113
ORA-376
ORA-600
ORA-Checkpoint not complete
Press <return> to continue ...
2003-01-03 16.50.45 --- Check for datafile status (OFFLINE/ONLINE):
SAPDBA: File '/oracle/DR3/sapdata5/stabi_3/stabi.data3' is offline
and needs recovery
If it remains offline it will neither be restored
nor recovered
Do you want to set it online? (y/n) [y] ==>
[color=brown]SAPDBA: EXECUTE IMMEDIATE failed with ORACLE error -1122.
SAPDBA: Error - /oracle/DR3/sapdata5/stabi_3/stabi.data3 online!
SAPDBA: File '/oracle/DR3/sapdata5/stabi_3/stabi.data3'
can not be set online.
You will get prompted again after RESTORE
Press <return> to continue ...
SAPDBA: !!! 1 data file is offline !!!
************* SAPDBA - End of checking status of online redologs **************
2003-01-03 16.53.15 --- Check of data file's RECOVERY status via
V$RECOVER_FILE
SAPDBA: File '/oracle/DR3/sapdata5/stabi_3/stabi.data3'
has unknown error description "WRONG FILE TYPE"
(may be this file is younger than the controlfile)
Do you want to restore/recover it? (y/n) [y] ==>
4, i select the default value [y]
SAPDBA: Alert - CRITICAL_SEGS:
SEGMENT(S) CDCLS, EDI40, ZMMCH2 WOULD CAUSE A TABLESPACE OVERFLOW BY
ALLOC. UP TO 1 NEXT EXTENT(S)
*********************** End of check of all tablespaces ***********************
2003-01-03 16.54.23 --- Check of tables and indexes without opt stats
SAPDBA: Using control table DBSTATC
for taking optimizer settings into account
SAPDBA: All tables have a valid optimizer statistics
Press <return> to continue ...
2003-01-03 16.55.09 --- Checking init.ora parameters ...
[color=red][color=orange]SAPDBA: Alert - Parameter LOG_CHECKPOINT_INTERVAL is set to 300000 < 3000000000
SAPDBA: Alert - Parameter DB_FILE_MULTIBLOCK_READ_COUNT is set to 32 > 8
SAPDBA: Alert - Parameter OPTIMIZER_FEATURES_ENABLE is set to 8.1.6 (not to prop
er value 8.0.4)
SAPDBA: 3 out of 22 checked init.ora parameters are not set properly.
Press <return> to continue ...[/color]
##############################################################################
******************************** Alert Summary ********************************
SAPDBA: Warning - Alert conditions were detected
DATAFILE_OFFLINE
SEGMENT_MANY_EXTENTS
CRITICAL_SEGS
MISSING_INDEXES
SAPDBA: Warning - Oracle profile parameters are not set properly.
For more details view CCMS transaction DB16
Press <return> to continue ...
Press <return> to continue ...[/color][/color]
5,All of this is the message about check DB in sapdba.
Is the Oracle parameter value isn't set correctly?
Waitting you reply
[color=red] Best Regards ![/color][/img][/list][/list]
Answer:
Do you have a valid backup?
Answer:
It seems something wrong happened with you one datafile.
May be there were a replacement of datafile from newer to older.. or something change in control file.
But now it is looking ok after recovery are you able to login now or not..
Yes there is a extend over flow in two SEGMENT(S) CDCLS, EDI40, ZMMCH2
Please extend and adapt the next sagment and change the size or add one more data file
And you can ignore the parameter errors.
I hope after doing all this your Database will work fine.
Enjoy
_________________
Regards
Etalks
Answer:
Please ref to notes
132496
4165
4157
132496
IF recovery required
Best of luck
_________________
Regards
Etalks
Answer:
Hi, Etalk and guys:
Today is Saturday! when i come to company,i found today is Saturday
i think i'm work too hard now
Just like you talk, i going to recovery our DB in Monday.
When i export client from our Develop R/3,and i want backup our DB.
but i found the Quantmn Tape Driver is wrong! so i replace our tape driver and schedule backup,.....the backup is wrong too.
Haha,i'm very glad you can help me warmly.i hope we can make friends!
I came from Shanghai China. and i passed the BASIS Certificated in Mar 2002,but i havn't many project experience because of our company strategy changed,we no plan in SAP work
You can contact me with e-mail:jeminy_wang@hotmail.com
Best Regards!
Answer:
with my friends strongth support , i excauted restore and recovery DB with
SVRMGRL .and can logon R/3 finally.
the detail step is following:
1,find last successful backup(offline or online),restore redo log from media with SAPDBA, such as ,my last offline backup redo log number is from 5997-6010,the present redo log is 6011-6077 .
2,the detail info as follow.
BR362I Verification of backup of /oracle/DR3/saparch/DR3arch1_5997.dbf successful
BR280I Time stamp 2002-12-24 02.17.50
BR014I 4 of 17 offline redo log files processed - 79.986 MB of 339.974 MB done
BR204I Percentage done: 23.53%, estimated end time: 2:23
BR001I ************______________________________________
BR280I Time stamp 2002-12-24 02.21.33
BR014I 13 of 17 offline redo log files processed - 259.977 MB of 339.974 MB done
BR204I Percentage done: 76.47%, estimated end time: 2:23
BR001I **************************************____________
BR351I Restoring /oracle/DR3/sapreorg/DR3arch1_6009.dbf
BR355I from /dev/rmt/0mn ...
BR353I Verifying backup of /oracle/DR3/saparch/DR3arch1_6009.dbf
BR355I from /oracle/DR3/sapreorg/DR3arch1_6009.dbf ...
BR362I Verification of backup of /oracle/DR3/saparch/DR3arch1_6009.dbf successful
BR280I Time stamp 2002-12-24 02.22.40
BR014I 16 of 17 offline redo log files processed - 319.976 MB of 339.974 MB done
BR204I Percentage done: 94.12%, estimated end time: 2:23
BR001I ***********************************************___
BR351I Restoring /oracle/DR3/sapreorg/DR3arch1_6010.dbf
BR355I from /dev/rmt/0mn ...
BR353I Verifying backup of /oracle/DR3/saparch/DR3arch1_6010.dbf
BR355I from /oracle/DR3/sapreorg/DR3arch1_6010.dbf ...
BR362I Verification of backup of /oracle/DR3/saparch/DR3arch1_6010.dbf successfu
l
BR280I Time stamp 2002-12-24 02.23.04
BR014I 17 of 17 offline redo log files processed - 339.974 MB of 339.974 MB done
BR204I Percentage done: 100.00%, estimated end time: 2:23
BR001I **************************************************
BR016I 17 offline redo log files processed, total size 339.974 MB
BR202I Saving reorg_log
BR203I to /dev/rmt/0mn ...
BR202I Saving det_log
BR203I to /dev/rmt/0mn ...
BR202I Saving sum_log
BR203I to /dev/rmt/0mn ...
BR280I Time stamp 2002-12-24 02.23.12
BR226I Rewinding tape volume in device /dev/rmt/0m ...
BR351I Restoring /oracle/DR3/sapreorg/.tape.hdr0
BR355I from /dev/rmt/0mn ...
BR241I Checking label on volume in device /dev/rmt/0mn
BR280I Time stamp 2002-12-24 02.23.55
BR226I Rewinding tape volume in device /dev/rmt/0m ...
BR007I End of offline redo log processing: adjpghsq.cds 2002-12-24 02.24.12
BR280I Time stamp 2002-12-24 02.24.14
BR003I BRARCHIVE terminated successfully
now , you can check whether it restored success
check ../saparch directory.
devr3:oradr3 13% svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR> shutdown ;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 281632752 bytes
Fixed Size 69616 bytes
Variable Size 127496192 bytes
Database Buffers 153001984 bytes
Redo Buffers 1064960 bytes
Database mounted.
SVRMGR> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SVRMGR> select * from v$recover_file ;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- ---------
44 OFFLINE 21662940 20-DEC-02
1 row selected.
(remark: the file 44 is the error file when excaute online backup)
SVRMGR> alter database datafile '/oracle/DR3/sapdata5/stabi_3/stabi.data3' onli;
Statement processed.
SVRMGR> select * from v$recover_file ;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- ---------
44 ONLINE 21662940 20-DEC-02
1 row selected.
SVRMGR> shutdown;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> starup mount;
starup mount
*
ORA-01034: ORACLE not available
SVRMGR> shutdown;
ORA-01012: not logged on
SVRMGR> startup nomount;
ORACLE instance started.
Total System Global Area 281632752 bytes
Fixed Size 69616 bytes
Variable Size 127496192 bytes
Database Buffers 153001984 bytes
Redo Buffers 1064960 bytes
SVRMGR> alter database mount;
Statement processed.
SVRMGR> select * from v$recover_file ;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- ---------
44 ONLINE 21662940 20-DEC-02
1 row selected.
SVRMGR> alter database open;
alter database open
*
ORA-01113: file 44 needs media recovery
ORA-01110: data file 44: '/oracle/DR3/sapdata5/stabi_3/stabi.data3'
SVRMGR> select * from v$recover_file ;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- ---------
44 ONLINE 21662940 20-DEC-02
1 row selected.
SVRMGR> recover database;
(remark: system now recovery automatically. )
ORA-00279: change 21662940 generated at 12/20/2002 20:46:10 needed for thread 1
ORA-00289: suggestion : /oracle/DR3/saparch/DR3arch1_5998.dbf
ORA-00280: change 21662940 for thread 1 is in sequence #5998
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Log applied.
ORA-00279: change 21663425 generated at 12/21/2002 02:55:38 needed for thread 1
ORA-00289: suggestion : /oracle/DR3/saparch/DR3arch1_5999.dbf
ORA-00280: change 21663425 for thread 1 is in sequence #5999
ORA-00278: log file '/oracle/DR3/saparch/DR3arch1_5998.dbf' no longer needed foy
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Log applied.
ORA-00289: suggestion : /oracle/DR3/saparch/DR3arch1_6068.dbf
ORA-00280: change 21777139 for thread 1 is in sequence #6068
ORA-00278: log file '/oracle/DR3/saparch/DR3arch1_6067.dbf' no longer needed foy
Log applied.
ORA-00279: change 21787214 generated at 01/01/2003 01:41:08 needed for thread 1
ORA-00289: suggestion : /oracle/DR3/saparch/DR3arch1_6069.dbf
ORA-00280: change 21787214 for thread 1 is in sequence #6069
ORA-00278: log file '/oracle/DR3/saparch/DR3arch1_6068.dbf' no longer needed foy
Log applied.
Media recovery complete.
SVRMGR> alter database open;
Statement processed.
SVRMGR> exit
Server Manager complete.
devr3:oradr3 17% su - dr3adm
Password:
Sun Microsystems Inc. SunOS 5.6 Generic August 1997
devr3:dr3adm 1% startsap
/export/home/dr3adm/startsap_devr3_00: P: not found
Starting SAP-Collector Daemon
------------------------------
Collector already running ... don't launch
saposcol already running
Checking SAP R/3 DR3 Database
------------------------------
Database is running
Starting SAP R/3 Instance
------------------------------
Startup-Log is written to /export/home/dr3adm/startsap_devr3_00.log
Instance on host devr3 started
devr3:dr3adm 2% ps -ef |grep sap
now ,check sap process .
and can logon R/3 with SAPGUI.
Complete.
_________________
Jeminy wang
E-mail:basisamateur@hotmail.com
Yahoo Messenger:jeminywang
Come from: ShangHai China
Hobby:WuShu,Fishing,Sports,DiZhi,Xiao
Are you interesting make friends with me?
Yes ,i want make friends with you!
Let's do it now!