Database Backup and Recovery (MOSC)

MOSC Banner

ora 01531 after cold backup

edited Dec 30, 2014 11:53AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓

I have a database that I do not have in archive log mode.   I schedule a cold backup via OEM and the backup seems to run fine but the following error shows up at the tail end of the backup log.  Any idea how I can correct this?

released channel: oem_backup_disk1

released channel: oem_backup_disk2

exit;

Recovery Manager complete.

startup open

SQL> SQL> Connected.

SQL> SQL> alter database open

*

ERROR at line 1:

ORA-01531: a database already open by the instance

My backup script is as follows.

SET COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center