-
Applying CPU Patch in a dataguard (Physical Standby) environment
Continue reading →: Applying CPU Patch in a dataguard (Physical Standby) environmentHere is a brief explanation on how to apply CPU(Critical Patch Update) in a dataguard environmentIn this demo, I am applying PSU 11.2.0.4.2 on the Primary and standby databases. Standby Database Name :ORCL_STBYPrimary Database Name : ORCL Primary Server: [oracle@PRIM…
-
Rman Recovery comands….
Continue reading →: Rman Recovery comands….Rman Time-based PITR run{allocate channel dev1 type disk;set until time “to_date(‘2014-03-24:00:00:00’, ‘yyyy-mm-dd:hh24:mi:ss’)”;restore database;recover database; } or run{allocate channel dev1 type disk;set until time “to_date(‘2014-03-25:00:00’, ‘yyyy-mm-dd:hh24:mi’)”;restore database;recover database; } Rman Time-based Controlfile PITR run{SET UNTIL TIME “TO_DATE(‘20140323:12:01′,’YYYYMMDD:HH24:MI’)”; RESTORE CONTROLFILE FROM AUTOBACKUP…
-
Oracle Database Load Capture
Continue reading →: Oracle Database Load Capture[oracle@orcl01 dbcapture]$ sqlplus /”as sysdba” SQL*Plus: Release 10.2.0.4.0 – Production on Fri Dec 20 10:26:01 2013 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining…
-
CORRUPTION DETECTED: on Standby server
Continue reading →: CORRUPTION DETECTED: on Standby serverCORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 Problem Summary ————————————————— CORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 sequence 7677 Problem Description ————————————————— Primary database is in MAXIMUM PERFORMANCE…
-
Rman System datafile recovery scenerio
Continue reading →: Rman System datafile recovery scenerioSystem datafile recovery: Lets create a scenario where we will drop the system datafile, and we will recover using the rman restore and recover process.Since system datafile is key for database functioning. Before we start. Lets verify that database is…
-
RMAN FULL database recovery scenerio
Continue reading →: RMAN FULL database recovery scenerioFull database recovery : We will create a scenerio where we will drop all the datafiles and do a full database recovery. Database name : ORCL Assuming that you have already taken the full database backup (if not please take…
-
How To Shrink Table AUD$
Continue reading →: How To Shrink Table AUD$The SYSTEM tablespace is created with manual segment allocation and as such it is not possible to run the SHRINK command for the objects that are located within. However, if the AUD$ table is moved to another tablespace (locally managed…
-
Drop database including Rman backups in oracle
Continue reading →: Drop database including Rman backups in oracleExample – Deleting a Database In this example, you want to delete a test database called test1 that is registered in the recovery catalog. You start the RMAN client, connect to database test1 as TARGET, and connect to the recovery catalog.…
-
ORA-29516: Aurora assertion failure: Assertion failure
Continue reading →: ORA-29516: Aurora assertion failure: Assertion failureORA-29516: Aurora assertion failure: Assertion failure From Oracle 11g release 1 (11.1), Oracle introduces just-in-time(JIT) compiler for Oracle JVM environment, which results in faster execution because invalidation, recompilation, and storage of code is done dynamically. JIT is controlled by parameter…
-
Oracle user profile setup guide
Continue reading →: Oracle user profile setup guideA profile is a named set of the following password and resource limits: a.. Password aging and expirationb.. Password historyc.. Password complexity verificationd.. Account lockinge.. CPU timef.. Input/output (I/O) operationsg.. Idle timeh.. Connect timei.. Memory space (private SQL area for…



