- Running Oracle Database 12c on Windows Server 2012
Whenever I attempt to do a log switch (alter system archive log current), I am given the error in the title. Searching online shows the simple solution of opening the database via
alter database open, then checking the status via
select status from v$instance to ensure it is open will fix the issue. However, anytime I check the status, it is already in an OPEN state.
alter database open doesn't do anything as it's already open.
Anyone have any idea why I'm encountering this issue? Any help would be appreciated.