RE: ArchiveLogs on NetApps ?

This is how I had our archivelog mount to Netapps filer and such for all our databases, Unix and NT.

When I was first testing this... I did have some backup slowness issues which I resolved... I believed it was a netapp configuration setting. Since then it great..unless the network has issues.. (Hence we use dual archivelog location which works fine.)

Brian S.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
Sent: Monday, December 06, 2004 11:18 AM To: oracle-l_at_freelists.org
Subject: ArchiveLogs on NetApps ?

We've just begun our first NetApps [9iRAC on Linux] implementation.

What I've found in testing so far is

1. Writing ArchiveLogs to a NetApps Filer volume seems to be very slow [5min for a 100MB logfile against 30seconds on local disks] Do the ArchiveLog Dest volumes have to be mounted with the same NFS options as the Database Files volumes ?
2. Testing recoveries using SNAP CREATE and SNAP RESTORE we find that we frequently encounter a corrupt block in the last ArchiveLog being written to the ArchiveLog Dest volume. Any ideas why ?

Backup :

     BEGIN BACKUP
      Snap Create Database Files Volume
    END BACKUP ;;  ARCHIVE LOG CURRENT a few times
      Snap Create ArchiveLog Files Volume

Recovery :
      Snap Restore Database Files Volume
      Snap Restore ArchiveLog Files Volume
     RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 06 2004 - 10:48:01 CST