ORA-00376/ORA-01110 - Cold Backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-00376/ORA-01110 - Cold Backup

  1. #1
    Join Date
    Aug 2002
    Posts
    43
    Oracle 8.1.7
    Oracle Failsafe 3.1.2
    Win 2K Advanced Server v5

    I do a cold backup of our Production database every Sunday at 18:15. On two occasions we've had these errors in our alert log.

    SMON: Restarting fast_start parallel rollback
    ORACLE Instance evolvliv (pid = 6) - Error 376 encountered while recovering
    transaction (4, 39) on object 4682.
    Sun Aug 25 18:55:42 2002
    Errors in file u:\Oracle\Admin\evolvliv\BDump\evolvlivSMON.TRC:
    ORA-00376: file 5 cannot be read at this time
    ORA-01110: data file 5: 'U:\ORACLE\ORADATA\EVOLVLIV\CL_IND01.DBF'
    ORACLE Instance evolvliv (pid = 6) - Error 376 encountered while recovering
    transaction (4, 49) on object 4682.
    Sun Aug 25 18:55:42 2002
    Errors in file u:\Oracle\Admin\evolvliv\BDump\evolvlivSMON.TRC:
    ORA-00376: file 5 cannot be read at this time
    ORA-01110: data file 5: 'U:\ORACLE\ORADATA\EVOLVLIV\CL_IND01.DBF'
    SMON: ignoring slave err,downgrading to serial rollback

    The event log also reports :

    The node lost communication with cluster node 'svr114' on network Private network.

    This seemed to have happened approx the same time as the cold backup.
    This script takes it offline

    REM Take the group offline
    c:\oracle\ofs\fs\fsmgr\bin\fscmd offlineresource evolvliv /cluster=CLU103 /user=Cluster /pwd=PassWord1 /domain=firstdata /OFFLINE=IMMEDIATE

    copy /Y U:\ORACLE\ORADATA\evolvliv\SYSTEM01.DBF v:\backup\cold

    copy /Y U:\ORACLE\ORADATA\evolvliv\CL_RBS01.DBF v:\backup\cold

    copy /Y U:\ORACLE\ORADATA\evolvliv\CL_TMP01.DBF v:\backup\cold

    copy /Y U:\ORACLE\ORADATA\evolvliv\CL_DAT01.DBF v:\backup\cold

    copy /Y U:\ORACLE\ORADATA\evolvliv\CL_IND01.DBF v:\backup\cold

    copy /Y U:\ORACLE\ORADATA\evolvliv\CONTROL1.CTL v:\backup\cold

    copy /Y U:\ORACLE\ORADATA\CONTROL2.CTL v:\backup\cold

    copy /Y U:\ORACLE\CONTROL3.CTL v:\backup\cold
    copy /Y U:\ORACLE\ADMIN\evolvliv\PFILE\INITevolvliv.ORA v:\backup\cold

    exit

    This brings it back online

    REM Place the oracle resource back online.
    c:\oracle\ofs\fs\fsmgr\bin\fscmd onlineresource evolvliv.firstdata.corp.fdrl.co.uk /cluster=CLU103 /user=Cluster /pwd=PassWord1 /domain=Firstdata

    exit

    Has anyone come across this error? Any suggestions/comments as to howmake sure the files are available for backup?

  2. #2
    Hi,

    From the oracle error description, something is trying to read the datafile which is offline. If you want to make cold backup, why dont you shutdown the database and restart when it finishs? You can put the procedure in the script. Or if you want to make hot backup while database is open use "alter tablespace tablespacename begin backup;" copy the file and when it finishs, end the backup with "alter tablespace tablespacename end backup;". You could also put this in script.

    regards,
    feroz

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    What and when exactly you are getting error in the whole process. Could you plz elaborate...
    My understanding is that you are taking only cold backup by shuting down the database and not the hot backup...
    "Greatest Rewards come only with Greatest Commitments!"

  4. #4
    Join Date
    Aug 2002
    Posts
    43
    These errors are intermittent. I do a daily hot backup but on Sundays I do a cold backup which involves shutting down the database and bringing it back online. Because we're using Oracle Failsafe the database is taken offline by using FSCMD.exe commands and then brought back online.
    The first script is scheduled for 18:15 which shuts the db down and then copies all the files to a directory. Then at 18:25 another scheduled script brings the resource back online. What puzzles me is that these have been working for months without errors but recently there were problems with the network config etc and also the event log report the node losing communication with our server. A fix has been scheduled for this weekend so I'll monitor this and see if this will resolve our issue.

  5. #5
    Join Date
    Aug 2002
    Posts
    43
    Sorry I do a daily hot backup and a cold back on Sundays.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width