Answer / 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.

Answer / mohapatra.gouranga@gmail.com

Recovery is imposible if no recent backup available with
archive logs. But inconsistent recovery is possible if any
old backup pieace available. Can be followed 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.

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

---

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

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---