ORA-01110,ORA-27037 when creating Physical Standby from Cold backup

Recently,while creating a physical standby database after restoring the cold backup(9.2.0.8 version) and starting the MRP process i faced the below error- Errors in file /oracle/app/admin/TEST/bdump/TESTdr_dbw0_1681.trc: ORA-01157: cannot identify/lock data file 85 - see DBWR trace file ORA-01110: data file 85: '/s02/oradata/TEST/TESTDATA36.dbf' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or … Continue reading ORA-01110,ORA-27037 when creating Physical Standby from Cold backup

ASM – My Playground

Recently i installed ASM on my laptop (Windows XP version 2002 SP3) and have a single instance 10.2.0.4 database on it.So thought of playing with ASM a little.Before starting with the game , a small background on ASM, CSS is must , i suppose. ASM -- From asm_10gr2_best_practices ASM is a management tool specifically built … Continue reading ASM – My Playground

Dropping tempfile while inuse – 10.2.0.4

I was asked by one of my friend, what would happen if we drop the tempfile (from multiple tempfiles in temp tablespace)while it is in-use.Inuse, in the sense,that some sessions are performing huge sorting and the temp tablespace is being used.With my little knowledge of Oracle, i replied "The tempfile must not get dropped,it must … Continue reading Dropping tempfile while inuse – 10.2.0.4

Exporting tables from different Schemas using EXPDP

Recently i saw a thread in OTN forum where it was asked "How to export (using EXPDP) tables from different schemas in a single expdp commad". Suppose you are asked to take export backup of SCOTT's emp and HR's jobs tables, how would you do it?? Using the traditional exp-imp method :- D:\>exp file= exp_test.dmp … Continue reading Exporting tables from different Schemas using EXPDP

Job to be run every 2nd Sunday of the Month

At the client's site, a script (executing procedure)was supposed to be run every 2nd Sunday of the month, for which crontab was set.The script ran successfully for almost 5months, when suddenly this month it didn't run.On finding out the cause, the ".sh" file permission had changed. I personally somehow, don't like keeping the jobs dependent … Continue reading Job to be run every 2nd Sunday of the Month