Exit Code -311 occurs in the system that Oracle was installed
Published: 2018/08/31
Updated: 2021/01/08
Summary
Exit Code -311 occurs when performing the backup in a system which Oracle was installed.
— AIP Task Log —
10/08/2015 14:00:23.718 com exception caught(0x8000ffff) in VssStart
10/08/2015 14:00:23.780 [10/08/2015 14:00:23.718] OUTPUT:
ERROR: Selected writer ‘Oracle VSS Writer – ORCL’ is in failed state!
– Status: 7 (VSS_WS_FAILED_AT_PREPARE_BACKUP)
– Writer Failure code: 0x800423f4 (<Unknown error code>)
– Writer ID: {26d02976-b909-43ad-af7e-62a4f625e372}
– Instance ID: {28d56957-6fa8-4a0e-9e62-ab293d6ed7f2}
:
:
10/08/2015 14:00:24.030 Exit Code: -311
— Windows Application Log —
Log Name: Application
Source: Oracle.VSSWriter.ORCL
Event ID: 44
Level: Error
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 Release 11.2.0.1.0 – 64bit Production
Oracle VSS writer version 11.2.0.0.0 Beta
Error at line : 4566
Failure on PrepareForBackup event
Cause
When using the Oracle VSS Writer, Archivelog mode is required.
Because the default installation of Oracle is in NOARCHIVELOG mode, the Oracle VSS writer does not work.
Workaround
1) Changing the Database Archiving Mode
This is the step to change the mode.
>sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
Reference:
https://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN11335
2) Not change the noarchivelog
Set the Oracle stop scripts in the Advanced Settings of backup schedule.
– Sample Pre-snapshot script BAT file
net stop <OracleServiceSID>
net stop <TNSListener Service>
– Sample Post-snapshot script BAT file
net start <TNSListener Service>
net start <OracleServiceSID>
?akb&p=2046