Home

About Me
Blog
Projects
Awards
Publications
Volunteer

Blog Posts

  • 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;}

  • 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 addition because, as others have…

  • 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 process 5367 RFS[2849]: Opened log…

  • 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: Release 11.2.0.1.0 Production on Mon…

  • 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 running in archive-log mode, if…

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts