Wednesday, 30 September 2015

Move a datafile with RMAN

›
Using RMAN is the best way before 12c to relocate a datafile with a minimum downtime. The only downtime is for switching from the old data...
Monday, 28 September 2015

ora-01244: unnamed datafile(s) added to control file by media recovery

›
Cause:  Media recovery with a backup control file or a control file that was rebuilt, encountered the creation of a datafile that was no...
Wednesday, 23 September 2015

SQL Tuning Advisor for SQL_ID

›
Here we are going to discuss how to do SQL Tuning Advisor for SQL_ID. 1.Create SQL Tuning Advisor task DECLARE   my_task_name...
1 comment:
Tuesday, 15 September 2015

To Find out If MySQL Is Running On Linux Or Not

›
Recently got a chance to work on Mysql database.So would like to share few besic article reagrding mysql Database.Below article will help ...
Thursday, 10 September 2015

EXP-00002: error in writing to export file

›
While exporting table or schema using exp/imp utility you may come across below error. Most of the time this error occurs due to  ...
1 comment:
Thursday, 23 July 2015

How to catalog backups / archivelogs / datafile copies / control file copies

›
RMAN Catalog: It is mainly used for following: Can store database backup scripts and backup information to safe place(RMAN Repositor...
Wednesday, 15 July 2015

Oracle Baseline/ SQL plan migration to its DEV/QA/Clone

›
In this article I have explained step by step how to copy/migrate SQL baseline from source database to target database. On Source data...