image

Daily Activities of Oracle Database Administrator

Daily Work of DBA: Check the Database Availability Check the Listener Availability Monitoring space Availability Viewing the Alert log file to analyze the ORA errors if any. Check tablespaces should not be used more that 95%. Viewing the temporary files, through the DBA_TEMP_FILES. Daily resolving the tickets by using Remedy ticketing tool. Taking backups by … continue reading

image

When to use SET DBID in RMAN

We should use the command SET DBID in RMAN under the following circumstances. You are not connected to a recovery catalog and want to restore the control file or server parameter file (SPFILE) You are connected to a recovery catalog want to restore the control file, but the database name is not unique in the … continue reading

image

Deleting the Archive log Using RMAN

Once you are connected, then you can use the following to delete archivelogs with one of the following commands. You can choose the commands depending on your situation. 1. To delete all Archivelogs withou backing them up: delete archivelog all; 2. To backup all archivelogs which are not already backed up atleast one time –And … continue reading

image

Multiplexing Control File

This article will focus on multiplexing the  control file. There are possibilities where control file can go corrupt , loss or damage by accident or some accidental deletion. Having multiple copies of control files will reduce risk of  result of loss of control files.If we have the copy of the control files we can simply … continue reading

image

DROP a Database using RMAN Oracle

How to Drop a Database using RMAN in ORACLE: Use the drop database command to drop a database from the RMAN prompt. Here are the steps to follow: 1. Start up the database in mount exclusive mode: SQL> startup mount exclusive; Database mounted. SQL> exit 2. From the RMAN interface, use the following command to … continue reading

image

Deleting the Archive Log in Using RMAN in oracle

run { allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel; } OR BACKUP ARCHIVELOG UNTIL TIME ‘SYSDATE-7′; DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-14′; OR allocate channel for delete type disk; change archivelog until time ‘SYSDATE-7′ delete; release channel;      

image

Checking the Availability of the Backup in ORACLE

The first step in any recovery procedure is to confirm the availability of the complete set of backup. By complete set I mean all the files required for the recovery. This is called the Redundancy Set. The set of files needed to recover an Oracle database from the failure of any of its files – … continue reading

image

Oracle DBA Interview Questions, Oracle FAQ Questions? Part IV

61. What is the use of root.sh & oraInstRoot.sh? Ans: Changes ownership & permissions of oraInventory Creating oratab file in the /etc directory In RAC, starts the clusterware stack 62. What is transportable tablespace (and across platforms)? 63. How can you transport tablespaces across platforms with different endian formats? Ans: RMAN 64. What is xtss … continue reading

image

Oracle DBA Interview Questions/FAQs Part3

41. What are materialized view refresh types and which is default? Complete, fast, force(default) 42. How fast refresh happens? 43. How to find out when was a materialized view refreshed? Query dba_mviews or dba_mview_analysis or dba_mview_refresh_times SQL> select MVIEW_NAME, to_char(LAST_REFRESH_DATE,’YYYY-MM-DD HH24:MI:SS’) from dba_mviews; (or) SQL> select NAME, to_char(LAST_REFRESH,’YYYY-MM-DD HH24:MI:SS’) from dba_mview_refresh_times; (or) SQL> select MVIEW_NAME, … continue reading

image

Oracle DBA Interview Questions/FAQs Part2

21. What is a datafile? Every Oracle database has one or more physical datafiles. Datafiles contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the datafiles allocated for a database. 22. What are the contents of control file? Database name, SCN, LSN, datafile locations, … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube