Answer Posted / mohapatra.gouranga@gmail.com

Recovery is not possible if no backup.
But inconsistent recovery is possible by following method:
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.

Where would you look for errors from the database engine?

2858

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1050

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1763

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1212

---

how can you connect from 10g user to 11g user??

2117

---

how can you initialize log miner?

1150

---

what functionality does oracle provide to secure sensitive information?

1000

---

what are the types of connection load-balancing?

1001

---

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

4429

---

what is the use of ocr?

1033

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1997

---

what is the use of recording information about current session?

1055

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1027

---

what is asm?

1057

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3763

---