Answer / raj

If RMAN backup exists
go to RMAN prompt
recover controlfile from backup controlfile
restore database from bckup
recover database

Answer / kittu_chintu2005

Method 1:
SQL>STARTUP NOMOUNT;
SQL>CREATE CONTROLFILE REUSE DATABASE "DB_NAME" ARCHIVELOG RESETLOGS
LOGFILE
GROUP 1 ( 'location of redo1a.log','location of redo1b.log') size XXmb,
GROUP 2 ( 'location of redo2a.log','location of redo2b.log') size xxmb
DATAFILE
'location of system.dbf',
'location of users.dbf',
'location of temp.dbf',
'location of ts1.dbf';
SQL>RECOVER DATABASE;
SQL>ALTER DATABASE OPEN RESETLOGS;

Answer / suman

we are restore the control file from cold/hot backup
after that
$sqlplus / 'as sysdba'
>startup nomount
>recover database using backup controlfile until cancel;
>alter database mount;
>alter database open resetlogs;

Answer / bolla

At o/s level we are restore control.file from cold/hot backup
after
]$sqlplus /'as sysdba'
sys>startup nomount
sys>recover database using backup controlfile until cancel;
sys>alter database mount;
sys>alter database open resetlogs;

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---