C:\Users\a-tsolar>rman target / catalog rcatowner/*****@RCAT Recovery Manager: Release 11.2.0.4.0 – Production on Fri Mar 18 11:12:04 2016 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to…
[root@ORACLE init.d]# pwd /etc/init.d -rwxr-xr-x 1 root root 1275 lis 10 12:22 dbora -rwxr-xr-x 1 root root 1137 pro 2 2011 dboraem [oracle@ORACLE ~]$ cat /etc/oratab orcl12c:/opt/oracle/app/12101:Y cat /etc/init.d/dbora [root@ORACLE…
Problém Export celé databáze zabral 20 min. Import pouze dvou schémat, ale trval 5 hodin. Z toho většinu času datová pumpa stála na promptu DOMAIN_INDEX/INDEX impdp ‘/ as sysdba’ schemas=TOMAS,TOMAS_TDMS…
Problém Tue Feb 02 10:44:05 2016 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Analýza SQL> set linesize 130 SQL> SELECT tablespace_name, total_blocks, used_blocks, free_blocks, total_blocks*32768/1024/1024 as…
Problém Sun Jan 24 15:56:06 2016 Thread 1 cannot allocate new log, sequence 2677 Private strand flush not complete Current log# 3 seq# 2676 mem# 0: /opt/app/oracle/oradata/ORCL/redo03.log Thread 1 advanced…
Problém [oracle@server ~]$ sqlplus user@orcl SQL*Plus: Release 10.2.0.4.0 – Production on Mon Jan 25 16:17:57 2016 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Enter password: Chyba v pristupu k…
Databáze neustále padala na ORA-600. V alert.logu se pravidelně objevovaly tyto ORA chyby. Tue Jan 19 22:42:49 2016 Errors in file /oracle/ora/diag/rdbms/orcl/orcl/trace/orcl_smon_5609.trc (incident=173343): ORA-00600: internal error code, arguments: [13013], [5001],…
C:\>expdp ‘/ as sysdba’ directory=DPUMP_DIR1 dumpfile=perfstat.dmp logfile=perfstat.log PARFILE=’c:\Oracle\db02\RDBMS\ADMIN\spuexp.par’ LRM-00112: multiple values not allowed for parameter ‘logfile’ Export: Release 11.2.0.4.0 – Production on Thu Jan 14 14:44:08 2016 Copyright (c) 1982,…
