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.

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

0 Answers   HP,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

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

2 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---