This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

Oracle DBA

/Tag:Oracle DBA

Managing a Standby Database – Commands

By | December 16th, 2013|Database, DBA Miscellaneous, Oracle DBA|

ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]]   Changes the state of a standby database to an active database and prepares it to become the primary database.  ALTER DATABASE ADD [STANDBY] LOGFILE [THREAD integer] [GROUP integer]filespec Adds one or more redo log file groups to the specified thread, making them available to the instance assigned [...]

How to create blackout in Oracle Enterprise Manager 12c

By | December 6th, 2013|OEM, Oracle DBA|

Following are the Steps to Create Blackouts from EM Console: 1). Login to OEM 12c -> click Enterprise ->  Monitoring -> Blackouts. 2). Click on Create.   3). Enter Name, Comments, Reason and Select the Targets and click Next. 4). Select Members Targets  to Blackout and click Next  5). Select TimeZone, Duration and click Next. 6). Review the details given for Blackout and [...]

Data Dictionary Storage

By | October 21st, 2013|DB Architecture, Oracle DBA|

1). Data dictionary (also called system catalog) stores metadata such as: Information about relations names of relations names and types of attributes of each relation names and definitions of views integrity constraints 2). User and accounting information, including passwords 3). Statistical and descriptive data number of tuples in each relation 4). Physical file organization information [...]

Difference between user and schema oracle ?

By | May 23rd, 2013|Oracle DBA|

A schema is collection of database objects, including logical structures such as tables, views, sequences, stored procedures, synonyms, indexes, clusters, and database links. A user owns a schema. A user and a schema have the same name. The CREATE USER command creates a user. It also automatically creates a schema for that user. The CREATE [...]

Graceful Switchover and Switchback for Oracle 9i Physical Standby Database

By | March 11th, 2013|DBA Miscellaneous, Oracle DBA|

Description  When activating a standby database with the documented procedures using the alter database activate standby database command, Oracle does an implicit resetlogs operation. This operation is required when recovering from a standby controlfile, backup controlfile, creating a new controlfile with the resetlogs operation, or when executing point in time recovery. The resetlogs operation helps [...]

Oracle Database 10g Release 2 Automatic Storage Management – understanding

By | March 11th, 2013|DBA Miscellaneous, Oracle DBA|

Understanding Automatic Storage Management (ASM) Introduction             One of the biggest and best enhancements in Oracle 10g release is the Automatic Storage Management (ASM) feature. ASM is a cluster file system that can be used either in a standalone Oracle instances or with Oracle Real Application Cluster (RAC) to provide a vertically integrated subsystem encapsulating [...]

Oracle RMAN – Backup and Recovery Best Practices

By | March 11th, 2013|Oracle DBA, RMAN|

This article assumes that you are doing the Backup and Recovery basics. • Running in Archivelog mode • Multiplexing the controlfile • Taking regular backups • Periodically doing a complete restore to test your procedures.  Steps to log on to the oracle RMAN. Step 1:    Logon with the oracle DBA account Step 2:    Execute [...]