Aug-14

28-Aug

While activating the standby database, hit an internal error.

ALTER DATABASE ACTIVATE STANDBY DATABASE

ERROR at line 1:
ORA-00600: internal error code, arguments: [krse_arc_complete.4], [], [], [], [], [], [], [], [], [], [], []

ALTER DATABASE ACTIVATE STANDBY DATABASE
ERROR at line 1:
ORA-00600: internal error code, arguments: [krse_arc_complete.4], [], [], [], [], [], [], [], [], [], [], []

Work around:  drop the standby redo log files and activate the standby.

06-Aug

Current transactions

SELECT b.INST_ID,a.sid, a.username, b.xidusn, b.used_urec, b.used_ublk,flag,sql_id,sql_hash_value,ROW_WAIT_OBJ#,program

  FROM gv$session a, gv$transaction b

  WHERE a.saddr = b.ses_addr and a.inst_id=b.inst_id;

 

ZFS Appliance – Exadata RMAN backup configuration

 

http://docs.oracle.com/cd/E28223_01/html/E27586/configappl.html

 

03-Aug

List all the active requests in a cell server

<pre>cellCLI>  LIST ACTIVEREQUEST

List attributes of active requests

cellCLI> DESCRIBE ACTIVEREQUEST

 

List a specific I/O type of active requests

cellCLI> LIST ACTIVEREQUEST WHERE IOTYPE=’ PredicateCacheGet’ DETAILS

cellCLI> LIST ACTIVEREQUEST WHERE IOTYPE=’Smart scan’  ATTRIBUTES  DBNAME, IOREASON, IOTYPE, REQUESTSTATE

 

http://dbmentors.blogspot.in/2013/10/exadata-monitoring-active-requests.html

 

CellCLI> describe activerequest

        name

        asmDiskGroupNumber

        asmFileIncarnation

        asmFileNumber

        consumerGroupID

        consumerGroupName

        dbID

        dbName

        dbRequestID

        fileType

        id

        instanceNumber

        ioBytes

        ioBytesSofar

        ioGridDisk

        ioOffset

        ioReason

        ioType

        objectNumber

        parentID

        requestState

        sessionID

        sessionSerNumber

        sqlID

        tableSpaceNumber

 

Get the details of a CELL metric

 

CellCLI> list metricdefinition SIO_IO_WR_FC detail

         name:                   SIO_IO_WR_FC

         description:            "Cumulative number of megabytes of flash cache population writes by smart IO"

         metricType:             Cumulative

         objectType:             SMARTIO

         unit:                   MB

 

View  the metrices definition

CellCLI> list metricdefinition