Restructure an Oracle table online using DBMS_REDEFINITION

Introduction As a DBA you may have faced situations, where you need to change the column ordering of a particular table. We have different options to accomplish the task. However, most of the methods requires an outage. Here,

Installing Oracle 12c Goldengate on Linux x64

Considerations (Demo Environment) GG_HOME=/opt/oracle/gg/12.1.2 Oracle RDBMS Release 12c is already installed ORCALE_HOME (for 12c database)=/app/oracle/product/12.1.0 Step 1: Download the installation package from OTN For Linux x64 :   Step 2: unzip   Step 3: Move

Script to check OS memory utilization for Oracle Instance

This shell script can be used to check, how much Physical Memmory a particular Oracle database instance is consuming on a Unix [Linux/SunOs] machine. #!/bin/sh ### script to find the actual memory utilization by a oracle instance

Migrate a Non CDB database to PDB and plug in to a CDB using DBMS_PDB package

Following databases were used for demonstration Existing CDB : LABCP Existing PDB: LABP Existing NON CDB: LABPA   Step by Step Migration Tasks 1. Generate XML file from NON CDB to prepare for the PDB creation Make

ORA-01555 from 11g target database while refreshing MVIEW

Symptom: MVIEW refresh is getting failed with following errors. ORA-12012: error on auto execute of job 31030 ORA-12008: error in materialized view refresh path ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$" too small

Steps to manually switch over database roles

Login to the Primary Database and Switch the Logs SQL> alter system archive log current; ---- ---- (Issue this command few times) (In case of RAC database, shutdown all the nodes except the primary one. Perform log switch

RMAN Backup fails with ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Issue Description: RMAN backup failed with ORA-27054 errors while NFS filesystem was used for backup destination RMAN> run 2> { 3> allocate channel c1 device type disk; 4> allocate channel c2 device type disk; 5> backup database

How to Un-Catalog Duplicate Backup piece

Use the RMAN,  CROSSCHECK command to find the duplicate entries for a backup file. RMAN> crosscheck backup [completed ] [after/before]  [time];   2.  If you use the backup piece name of the duplicate entries, you will get

Recreate AWR in Oracle 11g

1: Check and make a note of the following parameter values SQL> show parameter cluster_database SQL> show parameter statistics_level SQL> show parameter sga_target SQL> show parameter memory_target SQL> show parameter spfile   2: Disable AWR Snapshots by
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed