QUERY ACTLOG BEGINDATE=12/25/2009 BEGINTIME=NOW-1:00 ENDDATE=12/26/2009 ENDTIME=NOW ORIGINATOR=ALL
QUERY SESSION
QUERY EVENT * * BEGINDATE=12/25/2009 BEGINTIME=00:00 ENDDATE=12/26/2009 ENDTIME="08:02:14 "
select
volume_name as dbbackup from volhistory where type='BACK-
UPFULL' and devclass='LTO'
select
stgpool_name,count(*) as "toplam adet" from volumes where
devclass_name='LTO' group by stgpool_name order by 1
select count(*) as Scratch_adedi from libvolumes where status='Scratch'
select
count(*) as Lib_Kartus_sayisi from libvolumes
select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Missed')))
select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Failed')))
select
nodename,substr(char(date_time), 1, 16) as "TME",message
from actlog where (msgno=4005 or msgno=4007 or msgno=4018
or msgno=4037 or msgno=4987) and (date_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
nodename
select
substr(char(date_time), 1, 16) as date_time,message from
actlog where (date_time between '2009-12-22 08:00:00' and
'2009-12-23 07:59:59') and severity<>'I'
select
entity,activity,bytes as BYTES from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
bytes desc
select node_name,platform_name,client_os_level,client_version,c-
lient_release,client_level,client_sublevel from nodes
where node_name in (select entity from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59'))
4 Ocak 2010 Pazartesi
lob segment shrink
https://forums.sdn.sap.com/thread.jspa?threadID=1414229&messageID=7891933
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=821687
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1319517
https://websmp130.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1010237
ESBIGTBL Tablespace is Growing More Than a Giga Per Day [ID 331534.1]
select owner, table_name, column_name from dba_lobs
where segment_name = 'SYS_LOB0000080468C00006$$'
select * from SAPSR3.tst03
SYS_LOB0000080468C00006$$
tst03 112
lob -3.25
alter table SAPSR3.TST03 disable row movement;
alter table SAPSR3.TST03 shrink space cascade;
select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
----------------------------------------------
SOFFCONT1.SYS_LOB0000068056C00007$$ 64G
RSBCS_REORG
RSDBDEOC
SO30 trans (RSBCSRE03 report)
14,4 08.20 GSYS_LOB0000076186C00006$$
alter table SAPSR3.TST03 enable row movement;
alter table SAPSR3.TST03 shrink space cascade;
alter table SAPSR3.TST03 enable row movement;
select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
SOFFCONT1
so30
RSBCS_REORG
RSSOCVPC
RSSORE00
RSCBCSRE03
RSBCSRE03
ALTER TABLE SOFFCONT1 MODIFY LOB (CLUSTD) (SHRINK SPACE);
select owner, table_name, column_name from dba_lobs
where table_name='SOFFCONT1'
brspace -c force -p initsid.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t TST03
-------------
set heading off;
set echo off;
Set pages 999;
set long 90000;
spool shrink_list
select 'brspace -c force -p initBP3.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t '||table_name from user_tables;
spool off
---------------
http://forums.sdn.sap.com/thread.jspa?threadID=338689
1. Run RSSO_DELETE_PRIVATE - I have run these for Document class RAW and OTF.
2. Run RSSODFRE
3. Run RSBCS_REORG - I have run these for Document class RAW and OTF.
This will delete and clean-up SOC3 and SOFFCONT1.
SOFFCONT1 stores any reports sent thru SAP office / workplace.
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=821687
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1319517
https://websmp130.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1010237
ESBIGTBL Tablespace is Growing More Than a Giga Per Day [ID 331534.1]
select owner, table_name, column_name from dba_lobs
where segment_name = 'SYS_LOB0000080468C00006$$'
select * from SAPSR3.tst03
SYS_LOB0000080468C00006$$
tst03 112
lob -3.25
alter table SAPSR3.TST03 disable row movement;
alter table SAPSR3.TST03 shrink space cascade;
select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
----------------------------------------------
SOFFCONT1.SYS_LOB0000068056C00007$$ 64G
RSBCS_REORG
RSDBDEOC
SO30 trans (RSBCSRE03 report)
14,4 08.20 GSYS_LOB0000076186C00006$$
alter table SAPSR3.TST03 enable row movement;
alter table SAPSR3.TST03 shrink space cascade;
alter table SAPSR3.TST03 enable row movement;
select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
SOFFCONT1
so30
RSBCS_REORG
RSSOCVPC
RSSORE00
RSCBCSRE03
RSBCSRE03
ALTER TABLE SOFFCONT1 MODIFY LOB (CLUSTD) (SHRINK SPACE);
select owner, table_name, column_name from dba_lobs
where table_name='SOFFCONT1'
brspace -c force -p initsid.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t TST03
-------------
set heading off;
set echo off;
Set pages 999;
set long 90000;
spool shrink_list
select 'brspace -c force -p initBP3.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t '||table_name from user_tables;
spool off
---------------
http://forums.sdn.sap.com/thread.jspa?threadID=338689
1. Run RSSO_DELETE_PRIVATE - I have run these for Document class RAW and OTF.
2. Run RSSODFRE
3. Run RSBCS_REORG - I have run these for Document class RAW and OTF.
This will delete and clean-up SOC3 and SOFFCONT1.
SOFFCONT1 stores any reports sent thru SAP office / workplace.
crontab
http://www.bilgipasaji.com/forum/hosting-genel-bilgi-395/46206-cron-jobs-kurulumu-ayarlari-kullanimi.html
sap portal açılış adımları
JdbcCon.log
/home/bpdadm/startdb.log
/home/bpdadm/startsap_SCS01.log
/home/bpdadm/startsap_JC00.log
/home/bpdadm/startdb.log
/home/bpdadm/startsap_SCS01.log
/home/bpdadm/startsap_JC00.log
error 0516-787 extendlv: Maximum allocation for logical volume
: 0516-787 extendlv: Maximum allocation for logical volume ... is 512
permalink
chlv -x 1000
permalink
chlv -x 1000
brbackup, brspace datafile boyutu resize
brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_27/sr3.data27' -s 11500M
alter database datafile '/oracle/SID/sapdata4/sr3_27/sr3.data27' resize 11500M
brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_30/sr3.data30' -s 14500M
ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' RESIZE 10240M;
ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' AUTOEXTEND ON NEXT 500M MAXSIZE 10240M;
---------------------------
brbackup -u system/***** -c -m all -t online
./nbackint -p /utl/ -f password -- yedekleme kartuj sistemi ile bağlantı
backint -p D:\oracle\%ORACLE_SID%\102\database\init%ORACLE_SID%.utl -f password
brbackup -u system/manager -c -m all -t offline_force
brarchive -u system/manager -c force -sd
-p initBPD2.sap -d disk
-t online -m all -k no -e 0 -l E
-p initBPD.sap -d util_file_online -r initBPD.utl
-t online -m all -k no -l E
-p initBPD.sap -d util_file_online -r initBPD.utl -t online -b -d -m all -k no -l E
alter database datafile '/oracle/SID/sapdata4/sr3_27/sr3.data27' resize 11500M
brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_30/sr3.data30' -s 14500M
ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' RESIZE 10240M;
ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' AUTOEXTEND ON NEXT 500M MAXSIZE 10240M;
---------------------------
brbackup -u system/***** -c -m all -t online
./nbackint -p /utl/ -f password -- yedekleme kartuj sistemi ile bağlantı
backint -p D:\oracle\%ORACLE_SID%\102\database\init%ORACLE_SID%.utl -f password
brbackup -u system/manager -c -m all -t offline_force
brarchive -u system/manager -c force -sd
-p initBPD2.sap -d disk
-t online -m all -k no -e 0 -l E
-p initBPD.sap -d util_file_online -r initBPD.utl
-t online -m all -k no -l E
-p initBPD.sap -d util_file_online -r initBPD.utl -t online -b -d -m all -k no -l E
sap oracle bağlantısı testi
startsap options:
# startsap - starts r3 and database.
# startsap db - starts only the database.
# startsap r3 - starts r3 and assumes that the database is already started.
Stopping of an R/3 uses the file stopsap.
http://myadmin.wordpress.com/2007/01/29/startsap-what-is-behind-it/
R3trans -x sap database bağlantı sağlyabiliyormu
http://help.sap.com/saphelp_40b/helpdata/pt/3d/ad5ca44ebc11d182bf0000e829fbfe/content.htm
http://www.tech-recipes.com/rx/569/some-common-aixunix-commands/
# startsap - starts r3 and database.
# startsap db - starts only the database.
# startsap r3 - starts r3 and assumes that the database is already started.
Stopping of an R/3 uses the file stopsap.
http://myadmin.wordpress.com/2007/01/29/startsap-what-is-behind-it/
R3trans -x sap database bağlantı sağlyabiliyormu
http://help.sap.com/saphelp_40b/helpdata/pt/3d/ad5ca44ebc11d182bf0000e829fbfe/content.htm
http://www.tech-recipes.com/rx/569/some-common-aixunix-commands/
Kaydol:
Kayıtlar (Atom)