ORA-01194: file 1 needs more recovery to be consistent Method 1: 1) Start the database in mount state SQL> startup mount; 2) Recover the database. SQL> recover database; If you come across below error ORA-00283:...
http://neerajoracledba.blogspot.in/2014/07/ora-01194-file-1-needs-more-recovery-to.html