nhiDbSave fails with error ORA-00258

Article Id: 40630
Status: Published
Updated On: 14-02-2018 07:46
Legacy Id: TEC1670013
Products:
EHEALTH - MISC CA eHealth Performance Management - Data Polling CA eHealth Performance Management - Usage and Administration DEVELOPER PROG REMOTE POLLER
Issue/Introduction:

Problem:

Database save fails with the following error

 

Error: ERROR: SQLCODE=-258 SQLTEXT=ORA-00258: manual archiving in NOARCHIVELOG mode must identify log 

 - Error: Rman recovery failed. 

Refer to log /ehbackups/nightly_dbsave.tdb/oracle_rman/rman_save.log for more details.. 

Error: The program nhiSaveDb failed. 

 

 

Environment:

eHealth on Solaris, Linux, Windows; all versions

    

 

Cause:

    The mode of the database was changed to NOARCHIVELOG

You can verify this by logging into sqlplus and use the following query

select log_mode from v$database;

 

Resolution:

 

     Change the database mode to ARCHIVELOG 

 

1. Stop eHealth by running "nhServer stop", from command line

 

2. Start your SQL *PLUS and log in with SYSDBA priveledges. 

 

START > RUN > sqlplus  sys/[email protected]_SID AS SYSDBA  

                       or sqlplus "sys/ as sysdba" for Solaris/Linux

 

3. Issue a Shutdown command 

SQL > SHUTDOWN IMMEDIATE; 

 

4. Mount yourDatabase 

SQL > STARTUP MOUNT; 

 

5. Set your database in ARCHIVELOG mode 

SQL > ALTER DATABASE ARCHIVELOG; 

 

6. Open your database 

SQL > ALTER DATABASE OPEN; 

 

7. Start eHealth by running "nhServer start" from command line

 

 

Environment:

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: