Database Backup and Recovery (MOSC)

MOSC Banner

ORA-1146

edited Feb 20, 2010 4:04AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Database is generating ORA-1146 when doing a hot backup. Checked the error and queried the V$BACKUP view. Should any file# have a status of ACTIVE
it's still in backup mode and this needs to be corrected. This is not the case as defined below.  Is there anything else I need to correct?  We are not using RMAN, the hot backup script has been running for many months without this error. Your response is appreciated.

 

 

SQL> select file#, status from v$backup;

 

     FILE# STATUS

---------- ------------------

         1 NOT ACTIVE

         2 NOT ACTIVE

         3 NOT ACTIVE

         4 NOT ACTIVE

         5 NOT ACTIVE

         6 NOT ACTIVE

         7 NOT ACTIVE

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