Ran into the error above when moving (restoring from a backup) a 12c database (data files, control files, redo logs) from an Oracle Linux 6 server to a new Oracle Linux 8 server and trying to do a 19c upgrade with the following command:
alter database open resetlogs upgrade;
The problem was the path of a redo log group was not correct. The path doesn’t exist on the new Oracle Linux 8 server. We can check redo log group information with the following commands:
select * from v$log;
select * from v$logfile;
Then we can rename redo log file and clear the group.
alter database rename file '/dbase/oradata/redo/redo1.log' to '/dbase/redo/redo1.log';
alter database clear logfile group 1;
alter database clear unarchived logfile group 1;
Redo logs will be created at the correct place with the commands above.
Reference:
Open Resetlogs Fail with ORA-00600[ksvworkmsgalloc: bad reaper] (Doc ID 2728106.1)