Oracle 23c New Features for DBA'sHello,
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. Continue reading Data Pump: Expdp/impdp legacy support.
|
|||||||||||||||||||||||||
|
Hello All, We all build RAC infrastructure and we have seen many cases that environment is not stable after live or when start using it. The reasons may be many, but due to vast technologies involvement in high availability concepts we do not know or we ignore many aspects while doing environment testing. It is indeed very important, We need to do end to end test cases with regards to failovers as the high availability infrastructure is meant for that. Zero failure tolerance, or Connection failover or what ever the case this test cases should be structured, well organized so that our high availability solution to business critical systems should be fool proof. Have collected the RAC failover test cases from various sources and modified a bit , attached here in with categorical wise which may be useful to you all when some one ask you about to do testing of RAC new environment. This documents contains, Category of testing Action & Target we are testing Steps to carry out testing Expected result of testing Test result to record
-Thanks Geek DBA 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'; SQL> drop database link proddb; Weird, no rows in dba_db_links Lets check, whether my global_name set to true and what value it is Continue reading ORA-02082: a loopback database link must have a connection qualifier 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. I came across similarly with same due to a large import got failed with undo 🙁 (more than 40gb import dump of 50gb table), this is in middle of the business day and hampering the system load peaking to 14,15, 18 of averages respectively. Error in parallel slave trace:-
So is there a way to disable the smon transaction recovery for sometime and continue later ? Continue reading SMON Transaction Recovery hanging up your database? In RAC, you may all know about a TAF services which gives the failover capability to availability instances when the preferred failed. But how does this can work in when you have a Dataguard Environment with Primary and standby. Well answer is until 10g/11gR1 create a trigger like below and manage the service based upon the instance role. Creating a service
and have database level trigger to start service in case database role switch happens:
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 my instances as expected, so thought of writing this post to make you all aware of it.
Before to 11.2.0.2 , when any data file got corrupted,or receives 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 been built long back and in sync, whilst I was doing a roll forward standby recovery and trying to catalog found this issue. Now, how to change the DBID to the desired or the original one, Continue reading RMAN-07518: Reason: Foreign database file DBID: 18023747 Database Name: TEST We all know that sys password is required and should be same on both the primary and standby databases, and many times during switchover, failover we encountered, ORA-01017: invalid username/password; logon denied, due to password mismatch etc. From 11g Onwards, a new parameter REDO_TRANSPORT_USER has been introduced to overcome this issue, Continue reading Dataguard 11g: Log shipping – No more sys password hassles ADRCI: Automatic diagnostic repository command interface, used to manage the diagnostic, health monitor, or incident packaging solutions for Oracle databases. This is the small adrci automatic purge script rather to rely on traditional log purging or housekeeping scripts. This script will check in /etc/oratab and list down all oracle homes and then set those Oracle ADR bases and clean up the traces/incidents/logs etc. Download Script here:- ADRCI_Purge.sh Hope this helps -Thanks Geek DBA
Housekeeping of logs , traces, diag directories is every DBA’s job and some may write their own , some adopt from others which is common. Often we found in our environments similar sort of scripts placed, which I found mostly were Non Pluggable to any new environments
Trust me I came across at least more than five environments which are having either too big complex scripts or none.
adrci ( I will add that one too soon)
Download:- Housekeeping Shell Script Hope this helps. Thanks Geek DBA |
|||||||||||||||||||||||||
Follow Me!!!