image

Recovering Oracle Database from the loss of spfile

NOTE : ALWAYS MAKE SURE YOU HAVE YOUR LATEST FULL BACKUP Lets first give a short look how to take the full backup $RMAN target / RMAN> BACKUP DATABASE plus ARCHIVELOG; Lets move towards the topic. Here i will show you how to recover the oracle database from the loss of the spfile. I will … continue reading

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

image

Oracle DBA Interview Questions, Oracle FAQ Questions?

Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? SGA + background processes. 2. What is SGA? System/Shared Global Area. 3. What is PGA (or) what is pga_aggregate_target? Programmable Global Area. 4. What are new memory parameters in Oracle 10g? SGA_TARGET PGA_TARGET 5. What are new memory parameters in Oracle 11g? MEMORY_TARGET 6. What … continue reading

image

Oracle 10g VS 11g(LISTAGG) SQL

Hello Friend i have a table like EMPID SKILLS SUBSKILL —— ——————– ——————– 22 oracle dba 22 oracle plsql i want to output that EMPID SKILLS SUBSKILL —— ——————– ——————– 22 oracle dba,plsql Solution: SELECT EMPID, SKILLS,LISTAGG(SUBSKILL, ‘,’) WITHIN GROUP (ORDER BY SUBSKILL) AS SUBSKILLFROM TABLENAMEGROUP BY EMPID. This solution will work for oracle 11gR2 … continue reading

image

PREPARING LINUX FOR ORACLE 11GR2 64Bit INSTALLATION STEP BY STEP

This article explains you step by step how to prepare the linux OS for ORACLE 11G step by step. This article oracle 11g installation is primarily focuses on the prior steps  before the installation oracle 11g i.e the steps required to prepare  the linux for oracle 11g installation which is a quite a challenging task. … continue reading

image

oracle ora-12545 target host or object does not exist

while trying to login into the oracle account , i was unable to login into the system resulting the message “oracle ora-12545 target host or object does not exist” .And i finally solved orac 12545 target host or object not found . How i solved this issue: Actually , orac 12545 target host or object … continue reading

image

ORA-01033: ORACLE initialization or shutdown in progress

Yesterday when i tried to login into my application , i could not login into my account . I was unable to login with the following error. But datbase was in open state. ORA-01033: ORACLE initialization or shutdown in progress Actually , while trying to find out the problem , the archive log was full … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube