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.

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

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

Describe what redo logs are.

1 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Explain the use of table functions.

1 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

Give the reasoning behind using an index.

2 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---