Exit Code -311 occurs in the system that Oracle was installed


Summary
Exit Code -311 occurs when perform the backup in the system that 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, 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:
http://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>

 

Tags: NJKB-56
Last update:
2015-11-18 07:58
Author:
Revision:
1.1
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.