-
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?
-
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
-
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...
-
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.
-
Sorry I do a daily hot backup and a cold back on Sundays.
