|
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|