Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How would you open a database in ARCHIVELOG mode with a missing a datafile?

April 26, 2017ARCHIVELOG database datafile MISSING mode

0

10 Posted

How would you open a database in ARCHIVELOG mode with a missing a datafile?

1 Answer

0

10 Posted

Mount the database, take the tablespace with the missing datafile offline, and open the database. To recover a lost datafile – start up the database in MOUNT mode – take the tablespace with the missing datafile offline – open the database – restore the backup datafile and all offline redolog files with OS commands – recover the datafile (not the database !) – bring the tablespace online. The tablespace will be recovered to the current time and the system will resynchronize the files. Committed data will not be lost.