Storing Windows-based Oracle Databases on the HP NAS 8000

for more information..................................................................................................................2
hp solution overview..................................................................................................................4
storage management and definition guide..............................................................................5
defining NAS 8000 storage for Oracle databases...............................................................5
NAS 8000 security level guidelines...........................................................................................6
installation of Oracle software..................................................................................................6
installation of Oracle on NAS 8000.......................................................................................6
location of alert logs and trace files ...................................................................................7
installation of Oracle on the Oracle server...........................................................................7
creating new database(s)...........................................................................................................7
share level security..................................................................................................................7
creating a database with the Oracle Database Administration Assistant (dbassist) ....7
setting service owner in share level security.....................................................................7
user level security ....................................................................................................................8
creating a database with the Oracle Database Administration Assistant (dbassist) ...8
creating a database with command and SQL files ...........................................................8
setting service owner ...........................................................................................................9
moving data files from already existing databases ...............................................................9
database administrative method for moving control files ..................................................9
database administrative method for moving active redo log files ....................................9
database management ............................................................................................................10
performance tuning ..................................................................................................................10
increasing available storage in the NAS 8000 ......................................................................10
adding hard drive(s) to the VA 7xxx array .......................................................................11
backups and snapshots............................................................................................................11
hot backups using NAS 8000 snapshots ............................................................................12
hot backups without NAS 8000 snapshots.........................................................................12
cold backups using NAS 8000 snapshots ...........................................................................12
cold backups without NAS 8000 snapshots .......................................................................12
nvram usage and nvram failures............................................................................................12
problems, challenges, and constraints ...................................................................................13
storage diagram for VA 7100.................................................................................................14
storage diagram for VA 7400 (single volume group)...........................................................15
storage diagram for VA 7400 (extra fault tolerance)...........................................................16
glossary .....................................................................................................................................17
3