HomeОбразованиеRelated VideosMore From: Oracle World

How to Recover or Recreate Controlfile without Backup ?

80 ratings | 9576 views
Hi guys in my today videos i will explain how to recover to controlfile without any backup. #RecreateControlfile #withoutBackup Oracle database Unbeatable,Unbreakable Platform..
Html code for embedding videos on your blog
Text Comments (4)
Swati Das (1 year ago)
sir i did.... SQL> select status, database_status from v$instance; STATUS DATABASE_STATUS ------------ ----------------- STARTED ACTIVE SQL> select open_mode from v$database; select open_mode from v$database * ERROR at line 1: ORA-01507: database not mounted SQL> alter database mount; alter database mount * ERROR at line 1: ORA-00214: control file 'E:\APP\USER\ORADATA\ORCL\CONTROL01.CTL' version 20195 inconsistent with file 'E:\APP\USER\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL' version 20193 what i ll do now could u resolve this error plz reply soon...........................
Saeid Banaei (1 year ago)
Thanks for the great video, I have a question, what was the reason you did not use " alter database backup controlfile to trace;" to backup the control file, since the instance is up and running?
THE BK MEN (2 years ago)
yeah,that was great,keep up you work,buddy!!
Vaibhav Patel (2 years ago)
thankx bro I have learned so many things from you (oracle world)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.