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;

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

How do you resize a data file?

2 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

Datapump backup steps?

1 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

How would you force a log switch?

4 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---