Monthly Archives: August 2012

Undo Segment is in Needs Recovery or Undo Segments are corrupted

Undo Segment is in Needs Recovery/Undo Segments are corrupted   Database is shutdown and can’t start it, asking for Undo recovery while dropping Undo tablespace Dropping a Undo tablespace give message ORA-01548: active rollback segment Or Undo segment shows status … Continue reading

Posted in Oracle backup & recovery | 2 Comments

OCR and Voting Disk Backup and Make a OCR and Voting disk mirror location

ADDING OCR AND VOTING DISK MIRRORING IN ORACLE 10G The Oracle Clusterware (CRS) includes two important components: The voting disk and the Oracle Cluster Registry (OCR). The voting disk is a file that manages information about node membership and the … Continue reading

Posted in Oracle RAC | Leave a comment

Delete files in Linux older than x days and x min

Move files/archive logs to backup folder, files older than 1 day find /rman/arch/*.dbf -mtime +1 -exec mv {} /rman/archbkp/ \; Move files older than 25hours find /rman/arch/*.dbf -mmin +1500 -exec mv {} /rman/archbkp/ \; List files older than 2hours find … Continue reading

Posted in Linux commands for DBA | Leave a comment

schedule rman backup in windows

How to Schedule rman backup in windows ———- –rman.cmd need to schedule only this which call another script. set oracle_sid=orcl rman target sys/passwd nocatalog cmdfile=’c:\oracle\rman\dbrman.cmd’ log=’c:\oracle\rman\bk_log.log’ ————— –dbrman.cmd run { allocate channel d1 type disk; backup tag whole_database_open format ‘c:\oracle\arch\db_%t_%s_p%p’ … Continue reading

Posted in rman | Leave a comment

Oracle DataGaurd on Standard Edition

Data guard in Oracle Standard Edition is not posible, so alternat way in Oracle is Manual DataGaurd on Standard Edition also called Manual DataGuard. Steps are 1) Take rman backup from primary server script rman target ‘system/paswd’ log=/rman/rman/rmanlog.`date ‘+%a’` <<EOF … Continue reading

Posted in Oracle DataGaurd | Leave a comment

About me

Sher khan      Senior oracle Database Administrator in Information Dynamics U.A.E Current working: UAE E-mail: Cell: +971504192798 DOB: March 22, 1980 Nationality: Pakistani   Academic Career: Master of Information Technology (MIT) Institute of Computing & Information Technology GomalUniversity, … Continue reading

Posted in Uncategorized | Leave a comment

Oracle RAC DBA

Posted in Uncategorized | Leave a comment