0

please I have copied my RMAN backup files to a new server with the same file path and oracle database name, I have taken the database to mount stage, but when I say 'alter database open resetlogs', it says error ORA-01194 file 1 needs more recovery to be consistent, then ORA-01110 data file 1: '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_ko3023c2_.dbf'

Please what am I missing? I need to open the database. I have also tried restore database and recover database. When I say Restore database it says no backup copy of datafile 1 to restore no backup copy of datafile 3 to restore.... till datafile 11

but I have already copied the datafiles to the target server and database in in mount state

Rex
  • 131
  • 1
  • 1
  • 4
  • Please listing detail your action (db status when performing action, do which action, ...). It a broad solution for this. But firstly "resetlogs" is wrong, secondly, you did copy backup/archive so how can you recover? – Duong Nov 25 '22 at 03:58

0 Answers0