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

Advertisements
  1. Igor Gorbatovsky
    May 25, 2015 at 8:43 pm

    Thanks for ORA-600 solution!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: