NEC Storage NV Series NAS Device Guide for Oracle Storage Compatibility Program Snapshot Technologies is-wp-04-001 Rev-1.00(J) Oct, 2004 NEC Solutions NEC Corporation. - 1 -
Copyright 2004 NEC Corporation ALL rights reserved. NEC Storage NV Series NAS Device OracleOracle9iSQL\Plus SunSun MicrosystemsSolaris Sun Microsystems, Inc. MicrosoftWindows Microsoft Corporation / - 2 -
Contents 1 Introduction...4 2...4 3 The Overview of NAS...8 3.1 NAS...8 3.2 NEC Storage NV Series NAS Device...8 4... 11 4.1... 11 4.2... 11 4.3... 11 4.4...12 5 OSCP...13 5.1...13 5.2...13 6 OSCP...14 6.1 Backup and Restore...14 7 OSCP...15 7.1 DatabaseSnapshot...15 7.2 Backup and Restore...15 8...31-3 -
1 Introduction OS NAS(Network Attached Storage) NAS NEC Storage NV Series NAS Device TOE(TCP/IP Offload Engine) NAS OS(NVRAM) NAS NEC Storage NV Series NAS Device Oracle RDBMS Oracle White paperguidelines for Using Snapshot Storage System for Oracle Database Oracle Oracle Storage Compatibility Program(OSCP) Snapshot test kit(stk) NEC 2 CIFS Microsoft Windows Windows Windows unix OS Cold Backup File Lock NAS Device NFS ) lock NFS lock Oracle RDBMS File Lock NEC Storage NV Series NAS Device NFS RPC lockd - 4 -
Snapshot LVM LVMLogical Volume Manager Hard mount ( Soft mount) NFS I/O Hot Backup iscsi ( NAS, SAN) Network (LAN, Ethernet)( FCIP ifcp NAS SCSI TCP/IP Fibre-Channel SAN / Link Aggregation () IEEE803.2ad NEC Storage NV Series NAS Device IEEE802.3ad (LACP: Link Aggregation Control Protocol) NAS ( iscsi, SAN) Network Attached Storage Network(LAN, Ethernet) NFS, CIFS OS / WebDAV HTTP, FTP Storage Network Network Access Server NAS - 5 -
NFS Sun Microsystems TCP/IP unix Windows NTP Network Time Protocol LAN NVRAM Non-Volatile Random Access Memory Static RAM Flash ROM (S-RAM)(F-ROM) SAN( iscsi, NAS) Storage Area Network Fibre-Channel / Soft mount( Hard mount) NFS I/O Stale Cache HDD NEC Storage Series Synchronous Writes () (Asynchronous Write) - 6 -
Synchronous Write TOE TCP/IP Offload Engine OS TCP/IP NAS OS (: iscsi) Network Accelerator - 7 -
3 The Overview of NAS 3.1 NAS NAS Network Attached Storage 3.1.1 () Disk Array SAN - Storage Area Network NAS Ethernet TCP/IP 3.1.2 NAS 3.1.3 OS SAN OS NAS NAS Device NFSCIFS OS 3.2 NEC Storage NV Series NAS Device NEC Storage NV Series NAS Device NAS 3.2.1 TOE(TCP/IP Offload Engine) TCP/IP OS CPU/Memory Ethernet CPU - 8 -
TCP/IP CPU TOE TOE Network Accelerator (iscsi NIC ) NEC Storage NV Series NAS Device TOE chip Gigabit Ethernet port TOE chip NAS OS 3.2.2 NAS OS NEC Storage NV Series NAS Device NAS Linux 3.2.3 RAID LSI NEC Storage NV Series NAS Device NEC Storage S Series Disk Array RAID LSI 2Gbps Fibre-Channel HDD 3.2.4 (NVRAM) NEC Storage NV Series NAS Device I/O 3.2.5 NEC Storage NV Series NAS Device Active-Active 2 () 3.2.6 NEC Storage NV Series NAS Device () 3.2.7 NEC Storage NV Series NAS Device 3.2.8 NEC Storage NV Series NAS Device - 9 -
- 10 -
4 NEC Storage NV Series NAS Device 4.1 4.2 4.3 istoragemanager IP - 11 -
4.4 ssh/rsh snap snap create snap copyback snap delete snap list - 12 -
5 OSCP 5.1 Primary Oracle host/secondary Oracle host Host:Sun Fire 280R(1CPU,1024MB memory,36.4gbx2 local disk) Storage: Storage NV8210 NAS Host:NEC Express 5800/100 5.2 Primary Oracle host/ Secondary Oracle host OS:Solaris 9 04/02 Database:Oracle9iR2(9.2.0.5.0) Storage:SC-LX OS Version 2.1.202 NAS OS:Microsoft(R) Windows 2000 server SP4-13 -
6 OSCP Oracle Database Database OSCP 6.1 Backup and Restore / Oracle Database remote Location Backup Method local cold hot remote cold hot 6.1.1 Database Database Database Oracle Database Backup Method cold backup hot backup - 14 -
OSCP 6.2 Database Snapshot 6.2.1 Oracle Database Oracle Database Oracle Oracle Database Database SID SID Database 6.2.2 NEC Storage NV Series NAS Device rsh NAS NAS rsh 6.3 Backup and Restore Oracle Database NEC Storage NV Series NAS Device Oracle Database - 15 -
cx206 NAS device NFS NFS cx206 / LVM01 datafile rbs datafile datafile datafile rbs datafile datafile - 16 -
LD name usage mount point LVM01 datafile/rbs/temp/system /export/oradata10 LVM02 control 1/Online REDO1 /export/oradata11 LVM03 control 2/Online REDO2 /export/oradata12 LVM04 init<sid>.ora/archived log /export/oradata13-17 -
6.3.1 Cold Backup Cold Backup NFS Cold Backup Cold Backup Oracle Database Cold Backup Database Oracle Database SQL/Plus SQL/Plus Oracle Database Cold Backup a) - 18 -
b) Oracle Database Database SQL/Plus Cold backup a) before_copyback b) Oracle Database Database Oracle Database Oracle Database Online REDO SQL a) Database b) c) Database Online REDO Database Cold Backup Database Cold Backup Online REDO - 19 -
Cold Backup Cold Backup Oracle Database Online REDO Online REDO - 20 -
6.3.2 Hot backup Hot Backup NFS Hot Backup Hot backup Hot Backup Database Hot Backup SQL/Plus Hot Backup a) - 21 -
b) Hot Backup Database Hot Backup SQL/Plus Hot Backup Snapshot Backup Hot Backup SQL/Plus Hot Backup Hot Backup Database Database a) before_copyback b) Oracle Database Database Oracle Database Oracle Database Online REDO SQL a) Database b) c) Database Online REDO - 22 -
6.3.3 Database Database Database Database Database Database Database Database Tape Database Backup Database Backup Database Database Database Database Database Tape Backup Database istoraga NV Snapshot Database Hot Backup Database Database cx206,cx207 NAS device NFS NFS cx206 / cx206 cx207 Database - 23 -
cx206 LVM05LVM08 NFS cp cx207 LVM05LVM08 NFS Database LD name usage mount point LVM01 datafile/rbs/temp/system /export/oradata10 LVM02 control 1/Online REDO1 /export/oradata11 LVM03 control 2/Online REDO2 /export/oradata12 LVM04 init<sid>.ora/archived log /export/oradata13 LVM05 LVM01 /export/oradata14 LVM06 LVM02 /export/oradata15 LVM07 LVM03 /export/oradata16 LVM08 LVM04 /export/oradata17 LVM01LVM05 Oracle LVM01 NFS LVM5 cp Database NFS - 24 -
6.3.3.1 Cold Backup Database Oracle Database istorage NV Snapshot Database Snapshot Database Database Oracle Database Cold Backup Online REDO Snapshot Oracle Database Database Snapshot Oracle Database Cold Backup Database Snapshot 6.3.1 Cold Backup Online REDO Snapshot Snapshot Copyback Database Oracle Cold Backup Cold Backup Database Database Database Database Database Database Cold Backup Database Database Database Database - 25 -
Database Database Database init<sid>.ora PATH Database init<sid>.ora Database Database Database PATH Database PATH SQL/Plus Online REDO PATH SQL a) Database b) Online REDO PATH c) Database Database - 26 -
6.3.3.2 Hot Backup Database Oracle Database Hot Backup istorage NV Snapshot Database Snapshot Oracle Database Hot Backup Database Database Database Oracle Database Hot Backup Online REDO Snapshot Oracle Database Database Snapshot Oracle Database Hot Backup Database 6.3.2 Hot Backup Online REDO Snapshot Snapshot Copyback Database Oracle Hot Backup Cold Backup Database Database SCN(System Change Number) Database Snapshot Database Hot Backup Database Hot Backup / Snapshot Hot Backup SQL a) b) - 27 -
2501 Database Database Database Database Cold Backup Snapshot Database Cold Backup Database Database Database init<sid>.ora PATH Cold Backup Database Database Database Database PATH SQL/Plus Online REDO PATH Database Database RESETLOGS SQL a)database b) c)database d)resetlogs Database - 28 -
- 29 -
2501 (arc.0001)database CANCEL RESETLOGS Oracle Database - 30 -
7 NEC Storage NV Series NAS Device Oracle Storage Compatibility Program(OSCP) Snapshot Technologies NEC Storage NV Series NAS Device Oracle DB - 31 -