Profile cover photo
Profile photo
Shahid Ahmed
497 followers -
Sr Oracle DBA
Sr Oracle DBA

497 followers
About
Posts

Post has attachment
Oracle DBA interview Question with Answer (All in One Doc)
1.  General DB Maintenance 2.  Backup and Recovery 3.  Flashback Technology 4.  Dataguard 5.  Upgration/Migration/Patches 6.  Performance Tuning 7.  ASM 8.  RAC ( RAC (Cluster/ASM/Oracle Binaries) Installation Link   9.  Linux Operating 10.  PL/SQL General ...
Add a comment...

Post has attachment
Highest Time taken to Manage Full and Incremental Backup
select rownum as rank        ,name        , DECODE(backup_type,'D','Full','I','Incremental'            ,'L','Archive Log',backup_type) backup_type        ,round(max_secs/60) mins FROM ( select name , backup_type , max(elapsed_seconds)  max_secs      from rc...
Add a comment...

Post has attachment
Photo
Photo
05/11/2015
2 Photos - View album
Add a comment...

Post has attachment
How to change Database Default Tablespace for users
1. Create new Tablespace <KAFA_ITGFIN_DBF> for schema KAFITGFIN create tablespace KAFA_ITGFIN_DBF datafile 'D:\ORACLE\ORA92\MUJAZORC\KAFA_ITGFIN_DBF.DBF' size 5120m autoextend on; 2. Take Export of schema KAFAFIN on Seperate drive. EXP SYSTEM/SYSMAN@mujazor...
Add a comment...

Post has attachment
Monitoring RMAN Backup with QBR tools
The Quest Backup Reporter is a windows client application.
It can connect too many databases at a time and reports directly from oracle
data dictionary views and RMAN catalog. It does not make any modification to
either database as well as RMAN configuratio...
Add a comment...

Post has attachment
Photo
Add a comment...

Post has attachment
Photo
Add a comment...

Post has attachment
How to Monitor RMAN Backup through SQL Query
To Monitor RMAN you can use OEM or any other tools such as "Quest Backup Report for Oracle". You can also used following Views in oracle 9i to check the RMAN backup status: v$rman_configuration v$backup_set v$backup_piece v$backup_spfile v$session_longops S...
Add a comment...

Post has attachment
Photo
Add a comment...

Post has attachment
Oracle 9i Database Deletion Manually (When required)
Database deletion task is not coming to DBA on regular
interval. I was lucky to get few tasks for production database deletion. I have
10 year experience in database and first time, I got the opportunity to delete
the production database after migration dat...
Add a comment...
Wait while more posts are being loaded