Unix and SQL Scripts for Oracle DBA



If you need any script be it any script Please let me know.

Leave your comment as per your requirement with your email address and location i will email 
you the scripts

Make sure you mention the description and requirement of your script

Thanks
Ghufran Ahmed Khan

Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

ORACLE BACKUP AND RECOVERY

WHAT IS BACKUP AND RECOVERY IN ORACLE ·         Backup Strategy -           Whole DB backup -           Partial DB backup ·         Backup Type -           Full DB backup -           Incremental DB Backup ·         Backup Mode -           Online( Inconsistent ) DB backup -           Offline ( Closed/Consistent ) DB Backup Consistent and Inconsistent Backups A consistent backup is one in which the files being backed up contain all changes up to the same system change number (SCN) . This means that the files in the backup contain all the data taken from a same point in time. Unlike an inconsistent backup, a consistent whole database backup does not require recovery after it is restored. The only way to make a consistent whole database backup is to shut down the database with the NORMAL , IMMEDIATE , or TRANSACTIONAL options and make the backup while the database is closed. The important point is that you can open the database after restoring a consistent who
Read more