We are going to learn about the steps which we will use for schedule rman backup in windows. Most probably Organisations use Linux and Unix OS as per there requirements but sometimes as per company’s requirements, we have to use windows. Here we are going to have look at the process of schedule rman backup in windows. Let’s have look at it. […]
All posts by Anuradha Mudgal
Undo Segment is in Needs Recovery
Whenever we face any DBA interviews we have to go through some intersting topics interviewers ask. Undo Management is the most important part of DBA’s job responsibilities. This article will help you out to solve the issue when “Undo Segment is in Needs Recovery or Undo Segments are corrupted” The database is shutdown and can’t […]
Control file recovery
Today we are going to have look at the backbone of an Oracle Database. Being DBA we all are most aware of the recovery of the controlfile . It is the most important element of our database. Let’s have a look at the steps which are required for the recovery of controlfile. Instance terminates on startup with ORA-00600: internal […]
HOW TO CONVERT SCN TO DATE AND DATE INTO SCN
Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database. Database SCN number some time is very important 1) Particularly when you are doing rman recovery 2) Filling gaps of archive logs between the primary […]
vipca error in Oracle RAC
Today we are going to learn about the error occurs in the Oracle RAC environment. Vipca is not opening new configuration window and is giving error [root@node2 bin]# ./vipca Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])] To resolve this issue Perform two steps [root@node2 bin]# ./oifcfg setif -global bond0/192.168.0.0:public [root@node2 bin]# ./oifcfg setif -global eth2/192.168.1.0:cluster_interconnect [root@node2 […]
kfed script for ASM disk troubleshooting
Today we are going to learn about the kfed “script for ASM disk troubleshooting” As per our new DBA in the journey of Database we are normally known about troubleshooting regards errors, Now we are going to learn about disk troubleshooting. Few lines of this post explain the definition. The kfed is an undocumented ASM utility that is […]
ORA-27300: OS system dependent operation
In this article, we are going to have a look at ” ORA-27300″. In this article, we are going to learn how to solve this error. Let’s have fun with ORA-27300 During the creation of a new database for RAC environment using DBCA, It shows the error about invalid grid and diskgroup not mounted. Error Details are ORA-27300: […]
ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION
This is the post for the error “ORA-29702”. ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION Cause: An unexpected error occurred while performing a CGS operation. Action: Verify that the LMON process is still active. Also, check the Oracle LMON trace files for errors. ##################################################### ORA-29702: ERROR OCCURRED IN CLUSTER GROUP SERVICE OPERATION ##################################################### […]
RMAN-08137 on Primary Database although Archive Destination
This article is about RMAN-08137. We are going to learn how do we can solve this issue. Let’s have look at the steps to solve this issue. RMAN does not delete ArchiveLogs on Primary Database when the State of the Archive Destination to the Standby Database is set to ‘defer’. When trying to delete ArchiveLogs, this Error is […]
Archivelog in Oracle Database
Today we are going to learn about the most important element of Oracle Database which come’s much important after it’s backbone.Being Oracle DBA we must aware of Archive logs.Now we are going to have look at the technical definition of archive log. An archived redo log file is a copy of one of the filled members of a […]