Subscriber Count

    425

Subscribe2

Pages

Contact for Online learnings
* indicates required field
Thanks for the inquiry. You will be receiving a mail shortly with course details. If not please check the spam folder once and mark our mail as not a spam.

Clone Database: Turn your backup (rman image copy) to a database without copy/restore?

Imagine how it could be if you can use your image copies of your databases as your UAT/dev databases, without much usign complex restore procedure, how it could be if you refresh/clone the databases.

The answer is is using Oracle Direct NFS Client and dbms_dnfs package.

Clonedb is a new Direct NFS (DNFS) feature introduced […]

Data Pump: Expdp/impdp legacy support.

Hello,

Am trying to use expdp, Watch this screenshot closely

and you ever wonder that how does it works, as I have used , row=n, file=test1.dmp with expdp which should not work but it is.

[…]

ORA-02082: a loopback database link must have a connection qualifier

One more for today,

Here is the error, this database link should point to production db,

SQL> create database link PRODDB connect to admin identified by admin using ‘PROD’; create database link MQDB connect to strmadmin identified by strmadmin using ‘PROD’ * ERROR at line 1: ORA-02082: a loopback database link must have a connection […]

SMON Transaction Recovery hanging up your database?

When a large transaction got killed, terminated we all know that smon will do the rollback of the transaction, “smon: enable tx recovery” which can evident in alert log.

Some time due to fast_start_parallel_rollback =high , lot of parallel sessions invoked and may complete hung your database or not permit any other session to work.

[…]

11gR2 continued it surprises: Have you ever seen that data file I/O error cause Instance crash ? 11.2.0.2 does it…

Uh!!,

Yes should start with that Uh.. only. Let get back to one more post.

One of my databases having I/O error, actually its a VM Linux machine with 11.2.0.2, I have removed the Virtual disk forcibly, (renamed) which is having one datafile. Actually, want to test this new hidden parameter “_datafile_write_errors_crash_instance”, which exactly crashed […]

RMAN-07518: Reason: Foreign database file DBID: 18023747 Database Name: TEST

Very recently I have encountered this issue while cataloging the backup pieces in order to sync the standby server.

Well this is all about that database DBID is different from the source (primary) database where you cannot/rman cannot see those backups relevant to this destination database. very obvious thing.

This db in the issue has […]

Oracle Compression: Concepts & Usage

As the data grows in relational databases (new business requirements, managing audit data etc), the cost associated with the disk systems to store that data and the resources required to manage them becomes vital.

Hence it is necessary to adopt techniques like compression, de-duplication etc to reduce the storage costs.

Lets go one by […]

ORA-01200: actual file size of X is smaller than correct size of Y

Yesterday My colleague has encountered the following issue, which is interesting.

Environment:-

1) Linux & 10g Database

2) Oracle Block size =8192

3) OS Block/Page size = 4096

Issue:- ORA-01200: actual file size of X is smaller than correct size of Y

Verification:-

1) Database was not opening (non system datafile)

2) DBV says no […]

Dataguard: ORA-16047: DGID mismatch between destination setting and standby

 

In My primary alert log,

****************************************************************** LGWR: Setting ‘active’ archival for destination LOG_ARCHIVE_DEST_3 ****************************************************************** LGWR: Error 16047 creating archivelog file ‘STREAMS’ Mon Oct 15 23:58:24 IST 2012 Errors in file /u02/app/oracle/admin/PROD/bdump/prod2_lns2_16765.trc: ORA-16047: DGID mismatch between destination setting and standby LNS: Failed to archive log 5 thread 2 sequence 2759 (16047) Mon Oct 15 23:58:30 […]

EXPDP: FLAHSBACK_TIME, ora-01841

For doing a consistent expdp backup to use flashback_time , documentation provides to use systimestamp where it will fail always (as in my case now)

Error:-

Conneted to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production With the Partionining,OLAP, Data Mining and Real Applicatiojn Testing options ORA-39001: invalid argument value ORA-39150: bad […]