Benutzer:Amsel/Bla
aus Wikinews, einem freien Wiki für Nachrichten
Inhaltsverzeichnis |
[Bearbeiten] Oracle
ARCHIVE_REDIRECTION
- change archiver destination for Oracle 10g
alter system set log_archive_dest='/oracle/ABC/sapdata1/sos_arch/ABCarch' scope=memory;
change init file:
alter system set log_archive_dest='/oracle/ABC/sapdata1/sos_arch/ABCarch' scope=spfile;
if spfile gets lost:
create spfile='/where/to/find/filename.ora' from pfile='$ORACLE_HOME/dbs/initSID.ora';
- otherwise/Oracle 9
archive log list;
archive log start to '/oracle/ABC/sapdata1/sos_arch/ABCarch';
eventl.
alter system switch logfile;
vi $ORACLE_HOME/dbs/initSID.ora
[Bearbeiten] w:Tablespace Managment
- Wie gross ist der Tablespace?
SELECT sum(bytes)/1024/1024 FROM dba_data_files WHERE tablespace_name='Name';
- Wieviel Platz ist noch vorhanden?
SELECT sum(bytes)/1024/1024 FROM dba_free_space WHERE tablespace_name='Name';
- Welche sind die dbf Files?
SELECT file_name, (bytes/1024)/1024 "Size in MB" FROM dba_data_files WHERE tablespace_name='Name';
- Uebersicht aller kritischen Tablespaces!
SELECT Total.name "Tablespace Name",nvl(Free_space, 0) Free_space,nvl(total_space-Free_space, 0) Used_space, total_space, (Free_space/total_space)*100 as "% free" FROM (select tablespace_name, sum(bytes/1024/1024) Free_Space from sys.dba_free_space group by tablespace_name) Free,(select b.name, sum(bytes/1024/1024) TOTAL_SPACE from sys.v_$datafile a, sys.v_$tablespace B where a.ts# = b.ts# group by b.name) Total WHERE Free.Tablespace_name(+) = Total.name ORDER BY "% free";
Tablespace muss erweitert werden
- ein dbf file auf 450 MB vergroessern:
ALTER database datafile '/wo/der/file/ist/name.dbf' resize 450M;
- ein dbf file hinzufuegen geht auch:
ALTER tablespace TABLESPACENAME add datafile '/wo/dieser/hin/soll/name.dbf' size xxxxM;
- mit SAP tool brspace:
brspace -u / -f tsextend -t TABLESPACENAME -a yes -f sapdata1 -i 50 -m 20000 -s 100
- -u = user
- -t TABLESPACENAME
- -a yes = autoextend yes
- -i number = file increment size in MB
- -m number = maximum file size in MB
- -s number = initial size in MB
- das dazugehoerige SQL statement waere dann in etwa:
alter tablespace PSAPBWP add datafile '/oracle/SID/sapdata1/bwp_7/bwp.data7' size 100M autoextend on next 50M maxsize 20000M
[Bearbeiten] SAP
- ccmsping missing:
/sapmnt/SID/exe/sapccmsr -DCCMS pf=/usr/sap/ccms/SID_00/sapccmsr/SID_CCMSR.PFL
/nSDM0 - check this.
