blockheading的博客

SYS@PROD1> alter database archivelog;alter database archivelog*ERROR at line 1:ORA-00265: instance recovery required, cannot set ARCHIVELOG modeElapsed: 00:00:00.22SYS@PROD1> alter database op

--ORA-25319: Queue table repartitioning aborted发生背景：监控日志时无限刷出ORA-25319: Queue table repartitioning abortederror 25319 happened during Queue table repartitioningErrors in file /u01/app/oracl

--ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/app/oracle/oradata/PROD1/example01.dbf问题原因：因为表空间中有坏块导致不能备份。RMAN> backup full database plus archivelog;Starting backup a

--NOTE: cannot fetch plan for SQL_ID: ******, CHILD_NUMBER: 0SCOTT@PROD1> SELECT * FROM table(dbms_xplan.display_cursor(NULL, NULL, 'basic +rows'));PLAN_TABLE_OUTPUT---------------------

--故障发生SYS@PROD1> startup forceORACLE instance started.Total System Global Area 732352512 bytesFixed Size 1347456 bytesVariable Size 356515968 bytesDatabase Buffers

--EXP-00091 Exporting questionable statistics.[oracle@ocm1 ~]$ exp userid=scott/tiger tables=t file=/home/oracle/t1.dmp buffer=1048576 log=/home/oracle/t1.logExport: Release 11.2.0.3.0 - Production

ORA-12719: operation requires database is in RESTRICTED mode解决过程：SQL> drop database;drop database*ERROR at line 1:ORA-12719: operation requires database is in RESTRICTED modeSQL> ALTER SYSTE

解决过程：ORA-16820: fast-start failover observer is no longer observing this databaseDGMGRL> stop observerDone.DGMGRL> show configurationConfiguration - testdg Protection Mode: MaxAvailability

--ORA-02437 使对已有数据不检查的主键约束生效SYS@PROD1> desc t1 Name Null? Type ----------------------------------------------------- -------- ------------------------------------ ID NUMBER TEX

--故障发现[oracle@ocm1 ~]$ rman target/Recovery Manager: Release 11.2.0.3.0 - Production on Sun Dec 11 21:32:02 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.RMAN

错误背景：查看grid状况发现报错。解决方法：

问题描述：在通过RMAN将数据库恢复到同类机异机的时候，restore spfile一直报RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceRMAN> restore spfile from '/tmp/bak/db_14_1_928703445';Starting resto

发生重演：EODA@PROD1> drop table temp purge;drop table temp purge *ERROR at line 1:ORA-14452: attempt to create, alter or drop an index on temporary table already in useEODA@PROD1> select

使用hr用户查看执行计划时报错SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled原因是该用户没有PLUSTRACE这个用户导致的。SYS@PROD1> grant plustrace to hr; --尝试授权提示不存在。grant plustrace to hr

EODA@PROD1> drop table t purge;drop table t purge *ERROR at line 1:ORA-00054: resource busy and acquire with NOWAIT specified or timeout expiredEODA@PROD1> select t2.username,t2.sid,t

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL参考：http://www.orafaq.com/forum/t/48150/2/解决方法：start /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catalog.

Cause: Transaction in progressAction: Commit or rollback transaction and then re-executeEODA@PROD1> alter session enable parallel dml;ERROR:ORA-12841: Cannot alter the session parallel DML

使用隐含参数_ALLOW_RESETLOGS_CORRUPTION后resetlogs打开数据库后,我们说很多时候你会遇到ORA-00600 2662号错误，这个错误的含义是:A data block SCN is ahead of the current SCN. The ORA-600 [2662] occurs when an SCN is compared to the depen

问题背景描述：SQL> alter session set container=pdbwyzc； --切换pdbSQL> define username=eodaSQL> define usernamepwd=fooSQL> create user &&username identified by &&usernamepwd;SQL> grant dba to &&username;

问题描述：启动数据库时遇到845错误。SQL> startupORA-01081: cannot start already-running ORACLE - shut it down first解决方法：[oracle@ocm2 dbs]$ df -hFilesystem Size Used Avail Use% Mounted on/dev/map

--ORA-16661: the standby database needs to be reinstated解决过程：DGMGRL> reinstate database prod3DGMGRL> show configurationConfiguration - testdg Protection Mode: MaxAvailability Databases: