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

How to start SQL Server in minimal configuration mode?

7976

---

Can you redefine a table online?

1117

---

when does an alert gets signaled?

1058

---

how can you enable flashback feature?

957

---

what are the differences of where and if in SAS?

2196

---

what is the diffrence between core dba and apps dba?

2573

---

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

1050

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2438

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1082

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1082

---

who owns the operating system files created by the utl_file package?

1081

---

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?

2515

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

996

---

how can you find out if a table can be redefined?

1018

---

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

1211

---