dbms_swrf_internal
AWR_EXTRACT -> AWR_LOAD -> MOVE_TO_AWR
This site contains information, scripts and instructions related to Oracle database and other technologies. Please use sqlplus and test my scripts on test environment before actual use on production. All relevant comments are welcome.
Страницы
- Main
- Veritas cluster
- AIX
- Solaris
- Linux
- Performance scripts
- RAC
- TNS
- Init parameters
- Dataguard
- ASM
- Unix tips
- VxVM
- Linux HA (hearbeat)
- Oracle internals
- Metalink (useful notes)
- Security
- OGG Oracle Golden Gate
- HTML/JavaScript in sqlplus
- Automatic TSPITR 11.2.0.3 (dropped user)
- 12.1
- SQL Performance Analyzer
- Backup/Recovery
- Alert log
среда, 8 сентября 2010 г.
asmcmd: ASMCMD-08103: failed to connect to ASM; ASMCMD running in non-connected mode
Can be if any issue with connection to +ASM
try sqlplus / as sysdba
try sqlplus / as sysdba
вторник, 7 сентября 2010 г.
rman: RMAN-10015: error compiling PL/SQL program
RMAN> sql "alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' off line";
using target database control file instead of recovery catalog
sql statement: alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' offline
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 09/06/2010 13:18:57
RMAN-10015: error compiling PL/SQL program
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' offline;
alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
using target database control file instead of recovery catalog
sql statement: alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' offline
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 09/06/2010 13:18:57
RMAN-10015: error compiling PL/SQL program
SQL> alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' offline;
alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
ASM: adding diskgroup
SQL> alter diskgroup data add disk '/dev/raw/raw2' size 1019m;
alter diskgroup data add disk '/dev/raw/raw2' size 1019m
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15033: disk '/dev/raw/raw2' belongs to diskgroup "DATA"
SQL> a force
1* alter diskgroup data add disk '/dev/raw/raw2' size 1019m force
SQL> /
Diskgroup altered.
alter diskgroup data add disk '/dev/raw/raw2' size 1019m
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15033: disk '/dev/raw/raw2' belongs to diskgroup "DATA"
SQL> a force
1* alter diskgroup data add disk '/dev/raw/raw2' size 1019m force
SQL> /
Diskgroup altered.
Подписаться на:
Сообщения (Atom)
Update BLOB
set define off DECLARE vb1 CLOB := 'long text'; vb2 CLOB := 'long text'; vb3 CLOB := ...
-
set define off DECLARE vb1 CLOB := 'long text'; vb2 CLOB := 'long text'; vb3 CLOB := ...
-
RMAN> sql "alter database datafile '/u01/app/oracle/oradata/orcl/test_1.dbf' off line"; using target database contro...
-
-- After media failure 03:03:25 150 4294967295 SYS@orcl> select * from t_t where object_name = 'test'; select * from t_t where ob...