Can any one tell me how the get the datafile when my controlfile is lost and i have created a new controlfile. and the information about the datafile is present in the previous controlfile which is corrupt and deleted. and there is no backup of the datafile is present

Questions by parthokonar1   answers by parthokonar1

Showing Answers 1 - 8 of 8 Answers

taraldesai

  • Jun 23rd, 2007
 

mount with pfile where your pfile control_file parameter points to old ctl file...then issue

alter database backup control file to trace;



  Was this answer useful?  Yes

Rushil

  • Sep 17th, 2014
 

Hi, Can anyone explain what is data file and control file.

  Was this answer useful?  Yes

SATHEES KUMAR

  • Jul 1st, 2015
 

Control file is a small binary file that record the physical structure of the database like datafile and redolog file location, timestamp,scn and used for recover purpose all so but have no datafile backup then you cant recover the database.

  Was this answer useful?  Yes

Suzanne

  • Apr 26th, 2016
 

The information is stored in the alter log. It will tell you which datafile is corrupt and you will be able to recover using RMAN

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions