Known Issue: Writer's Status is not Stable for Oracle Databases
Summary:
While attempting to back up Oracle Databases, you receive an error message stating that a writer's status is not stable.
This article applies to:
Carbonite Plans | Products | Platforms |
Power and Ultimate (Not sure?) | Carbonite Safe Server Backup (Not sure?) | Windows |
Oracle backup are only supported in version 5.6.
Cause:
It indicates the Database is in No Archivelog mode and is opened in a Read Write state. Volume Shadow Copy Service (VSS) does not support backing up a database in this configuration.
An event will be logged in the Windows Applications event logs:
Event Type: Error Event Source: Oracle.VSSWriter.ORCL Event Category: (255) Event ID: 44 Date: 9/7/2012 Time: 3:57:39 AM User: N/A Computer: ORACLE11G-WIN Description: VSS-00044: Database in NOARCHIVELOG mode must be in a consistent state for backup. Cause : The database was open read/write or mounted after a SHUTDOWN IMMEDIATE or SHUTDOWN ABORT. Action : Either mount the database in a consistent state or open it read-only to back up the database files. Additional info : Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production Oracle VSS writer version 11.1.0.6.0 Production Error at line : 4558 Failure on PrepareForBackup event
Solution:
The sections below are collapsed. Please click the section title to open / close a particular section.
Verify the Database Mode and State
To verify the database mode and state:
- Open Oracle SQL Plus
- Run the following commands
- SQLPLUS /NOLOG
- CONNECT username/password AS SYSDBA
- SELECT log_mode from v$database;
- SELECT open_mode FROM v$database;
Mount the Database in Read-Only State
To mount the database in read-only state:
- Open Oracle SQL Plus
- Run the following commands
- SQLPLUS /NOLOG
- CONNECT username/password AS SYSDBA
- SHUTDOWN
- STARTUP MOUNT