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

How to Recover or Recreate Controlfile without Backup ?

87 ratings | 10480 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 (6)
Hemanth Santosh (1 month ago)
hi , unknowingly i deleted the controlfile and then i created new controlfile with noresetlogs option,when i tried to open,its asking system file needs more recovery, database was also in archivelog mode when i lost controlfile...could you suggest what action needs to be taken?
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...........................
Abdul Taher Iqbal (9 days ago)
Thankx bro I have learned so many things from you (oracle world)
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.