Monthly Archives: May 2014

Raid Level recomendation for Oracle Database

RAID Type of RAID Control Database Redo Log Archive Log File File File File 0 Striping Avoid* OK* Avoid* Avoid* 1 Shadowing OK OK Recommended Recommended 0+1 Striping + OK Recommended OK Avoid Shadowing 3 Striping with OK Avoid Avoid … Continue reading

Posted in Database administration, Linux commands for DBA | Leave a comment

How to Rename Oracle Database

How to Rename Oracle Database 1 – Create Controlfile to trace SQL> alter database backup controlfile to trace; Database altered. 2- Check existing database nameĀ  SQL> select name from v$database; NAME ——— TESTDB SQL>shutdown immediate   3- Startup nomount SQL> … Continue reading

Posted in Uncategorized | Leave a comment