data file need media recovery
I am new to this field so please be patient. I have taken the backup of all datafiles, redologs, control file, spfile for my database.
After taking the backup i shutdown the database and change the location of all original datafiles, redolog files , control files which is asked by my team lead.
Now when i try to bring the database up its giving me this error:
ORA-01113: file 1 needs media recovery
ORA-01110: datafile 1:'D:\ORACLE\ORADATA\SONA\SYSTEM01.dbf'
Here the problem may occur because i forgot to execute command for switching log before taking backup.
Can any help me out!