Home

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 preview;}
Continue reading →: Rman Recovery comands….
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 and Real Application Testing options It looked like a nice…
Continue reading →: Oracle Database Load Capture
CORRUPTION DETECTED: on Standby server

CORRUPTION 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 mode Thu Jun 05 13:38:37 2014 RFS[2849]: Assigned to RFS…
Continue reading →: CORRUPTION DETECTED: on Standby server
Rman System datafile recovery scenerio

System 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 functioning without any problems. [oracle@linux1 ~]$ sqlplus /”As sysdba” SQL*Plus:…
Continue reading →: Rman System datafile recovery scenerio
RMAN FULL database recovery scenerio

Full 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 the full backup before your perform this test/task). Database is…
Continue reading →: RMAN FULL database recovery scenerio
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 with automatic segment space management) then it can be shrunk.…
Continue reading →: How To Shrink Table AUD$
Drop database including Rman backups in oracle

Example – 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. You then run the following commands to delete the target…
Continue reading →: Drop database including Rman backups in oracle
ORA-29516: Aurora assertion failure: Assertion failure

ORA-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 java_jit_enabled, and if it is set to TRUE then the…
Continue reading →: ORA-29516: Aurora assertion failure: Assertion failure
Oracle user profile setup guide

A 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 Shared Server only)j.. Concurrent sessions After a profile has been…
Continue reading →: Oracle user profile setup guide
Exporting schema excluding some tables

exporting schema excluding some tables: To exclude table from EXPDP Backup. Let’s take a case, you have 100 tables in your schema and you want to export only 99 of them except two which are huge in size and already available at destination. Here, expdp exclude=table:”in$‘EMP’\,’DEPT’$” parameter is best for DBA .…
Continue reading →: Exporting schema excluding some tables