Steps for Renaming Redo Log Members Shut down the database. 1. SHUTDOWN 2. Copy the redo log files to the new location.Operating system files, such as redo log members, must be copied using the appropriate operating system commands. See your operating system specific documentation for more information about copying files. The following example uses operating…
Database Statistics Statspack is different from BSTAT/ESTAT Statspack collects more data, including high-resource SQL It precalculates many ratios such as cache hit ratios, rates and transaction statistics It uses permanent tables owned by PERFSTAT user to store performance stats It separates data collection from report generation It makes data collection easy to automate using either…
Media Recovery – Oracle Executive Overview: The media failure is the biggest threat for enterprise data management. A media failure is a physical problem that occurs when a computer unsuccessfully attempts to read from or write to a file necessary to operate the database. The technique you use to recover from media failure of a…
Introduction In this paper we will present a method for retrieving data from an Oracle database that cannot be opened normally because one or more datafiles is inconsistent with the others. An example of a scenario where you would find yourself in this situation is as follows: A disk failed on our server and we…
The topics covered in listener security management are straightforward, but there are special sqlnet.ora tricks for blocking access by IP address. Blocking Oracle Access by IP Address Now comes the fun part: keeping people out of your database! While IP-based blocking is not as suitable as a full firewall, you are able to block clients…
Oracle Technical Interview Questions Answered – Part1 The interview process can be quite stressful. Here is the first part of a two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position. Ever since I wrote the past article on the Oracle Technical Interview,…
Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) with Oracle Apps Virtual Private Database (VPD) is an Oracle database security technology, enabling row level access control. With VPD we are able to control users access to data related to them only and preventing from them to access data they are not authorized…
HOW TO HIRE (OR BE HIRED AS) AN ORACLE DBA Over the last year I have interviewed several dozen candidates for Oracle related positions. The positions ranged from entry level developer to senior level DBA. Many of the interviews were for DBA level positions. In this period I learned that it is very difficult to…
Unix Command’s for DBA’s Basic File Navigation The “pwd” command displays the current directory: root> pwd /u01/app/oracle/product/9.2.0.1.0 The “ls” command lists all files and directories in the specified directory. If no location is defined it acts on the current directory: root> ls root> ls /u01 root> ls -al The “-a” flag lists hidden “.” files….