Veritas Storage Foundation™ for Oracle 5.0.1 Graphical User Interface Guide HP-UX 11i v3 HP Part Number: 5900-0091 Published: November 2009 Edition: 1.
© Copyright 2009 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Contents Technical Support ............................................................................................... 4 Chapter 1 Using the Veritas Storage Foundation for Oracle graphical user interface ............................................... 11 About GUI components ................................................................. About GUI functions ..................................................................... Using Veritas Enterprise Administrator Service ...........................
8 Contents How to choose appropriate stripe unit sizes ................................ How to choose between mirroring and RAID-5 ............................. Volume configuration guidelines .............................................. File system creation guidelines ....................................................... Controlling fragmentation ............................................................ Fragmentation utilities in VxFS ................................................
Contents Removing a snapplan .................................................................... Creating a snapshot ...................................................................... Creating a clone database with a snapshot ........................................ Resynchronizing a snapshot to a database ........................................ Resynchronizing a database to a snapshot ........................................ Aborting the reverse resychronization operation ...........................
10 Contents Chapter 8 Maintaining your system configuration ......................... 95 System configuration maintenance ................................................. 95 Resynchronizing the SFDB repository .............................................. 96 Rescanning the database instance ................................................... 96 Displaying and rescanning tablespace information ............................. 97 Viewing Storage Mapping ......................................................
Chapter 1 Using the Veritas Storage Foundation for Oracle graphical user interface This chapter includes the following topics: ■ About GUI components ■ About GUI functions ■ Using Veritas Enterprise Administrator Service ■ Starting the DBED agent ■ Stopping the DBED agent ■ Opening and closing the Veritas Storage Foundation for Oracle GUI ■ Performing tasks in the Veritas Storage Foundation for Oracle Java GUI About GUI components You can access Veritas Storage Foundation for Oracle, Veritas
12 Using the Veritas Storage Foundation for Oracle graphical user interface About GUI functions The GUI runs in a client-server environment. The server is located on a host that runs Veritas Storage Foundation for Oracle. The client can run on any UNIX and Windows platform that supports the Java Runtime Environment. Within the Java GUI, you can perform tasks from the main menu bar or you can right-click an object in the navigational pane on the left side of the screen.
Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service the instance or database highlighted in the tree, you can open it from the Oracle menu. To access the GUI functions: ■ Your user or group name must be added to the Veritas Enterprise Administrator (VEA) Authorization Database (AZDB). To make the necessary changes: ■ Some operations require that you must be logged in as root.
14 Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service Prerequisites ■ Use the /opt/VRTS/bin/vxdbedusr utility to create login names for any user, other than root, who needs to run the GUI. To run /opt/VRTS/bin/vxdbedusr, you must have superuser (root) privileges. For more information: See “Adding users to the Veritas Enterprise Administrator” on page 14. You must have superuser (root) privileges to execute the vxsvcctrl command.
Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service -h fully_qualified_host_name Specifies a fully qualified host name on which you want to add a user. For a stand alone installation, the command is run on the local host and the host name is optional. For a centrally managed server installation, you must be logged in as root and specify the host name. -d domain_name Specifies the domain to which the user belongs.
16 Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service 3 To give rootprivileges within the GUI to the database administrator, use the vxdbedusrcommand: # /opt/VRTS/bin/vxdbedusr -a user [-A] [-f] -n name -h hostname [-d domain_name -t domain_type] See the table for command usage details.
Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service Removing users from the Veritas Enterprise Administrator You may need to restrict access to the VEA authorization database (AZDB). You can remove users or user groups from the AZDB if they have been previously added. Use the commands in the table to remove users. -r Removes a user or group to the registry. user -n user_name Specifies the user to be removed.
18 Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service To remove users other than root from the Veritas Enterprise Administrator AZDB 1 2 Make sure that the optional GUI package was installed. OS Command HP-UX swlist | grep VRTSorgui Check if VxSVC is online. Bring it online if it is offline.
Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service 3 19 To remove a user, use the vxdbedusr command as follows. # /opt/VRTS/bin/vxdbedusr -r user [-A] [-f] -n name -h hostname [-d domainname -t domaintype] See the table for command usage details. For example: To remove a UNIX login “oracle” from the local host, enter: # /opt/VRTS/bin/vxdbedusr -r user -n oracle -h test.example.com To remove a NIS login “oracle” in domain example.
20 Using the Veritas Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service To manually start Veritas Enterprise Administrator Service 1 Verify the status of the VEA Service: # /opt/VRTSob/bin/vxsvcctrl status Current state of server : NOT RUNNING 2 Start the VEA Service: # /opt/VRTSob/bin/vxsvcctrl start Starting Veritas Enterprise Administrator Service (vxsvc) .
Using the Veritas Storage Foundation for Oracle graphical user interface Starting the DBED agent Starting the DBED agent The DBED agent should be running before you access the Veritas Storage Foundation for Oracle GUI. You may need to start the DBED agent manually. To start the DBED agent 1 Verify if the DBED Agent is running: # /opt/VRTSobc/pal33/bin/vxpal -a DBEDAgent -c status Agent State: NOT RUNNING 2 Start the DBED Agent # /sbin/init.d/ vxpal.
22 Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI Prerequisites ■ Use the /opt/VRTS/bin/vxdbedusr utility to create login names for anyone (other than root) who needs to run the GUI. To run /opt/VRTS/bin/vxdbedusr, you must have superuser (root) privileges. ■ The dbed_update command must be run at least once before you can manage a database through the GUI.
Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI ■ Managing your database ■ Using a clone database ■ Managing Storage Checkpoints ■ Managing snapshots ■ Using tiered storage ■ Automating tasks ■ Maintaining your configuration Accessing database management tasks in the Java GUI You can use the Veritas Storage Foundation for Oracle Java GUI for setting up a database.
24 Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI To access the Create Clone Database wizard in the Java GUI 1 Click the database in the object tree. 2 Select one of the following methods to access the Create Clone Database wizard: 3 ■ In the menu bar, click Oracle > Create Clone Database. ■ Right click the database object to display a pop-up menu. Then, click Create Clone Database.
Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI To access the Storage Checkpoint wizards in the Java GUI 1 Click the Storage Checkpoints icon in the object tree. (You may need to expand the tree view to find the icon.) 2 Select one of the following methods to access the Create Storage Checkpoint wizard. 3 ■ From the menu bar, select Storage Checkpoints.
26 Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI 3 ■ From the menu bar, select Snapplans. ■ Right click the Snapshot Plans icon to display a pop-up menu. Select a wizard option. See “Creating a snapplan” on page 62. See “Validating or modifying a snapplan” on page 64. See “Removing a snapplan” on page 66. See “Resynchronizing a snapshot to a database” on page 68.
Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI See “To set up Database Dynamic Storage Tiering parameters” on page 76. See “To modify Database Dynamic Storage Tiering parameters” on page 77. See “To classify volumes” on page 79. To access the tiered storage policy wizards in the Java GUI 1 In the object tree, select the database object. You may need to expand the tree view to find the database object.
28 Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI To access the tiered storage report wizards in the Java GUI 1 In the object tree, select the database object. You may need to expand the tree view to find the database object. 2 Select one of the following methods to access the Database Dynamic Storage Tiering report wizards: ■ In the menu bar, click Oracle > Database Dynamic Storage Tiering Management.
Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI 3 Existing tasks are listed in the scheduler directory. Select the task in the scheduler directory to display it in the right pane or right-click it to display additional options. 4 To access modification options for existing tasks, select the task in the scheduler directory and right-click it. Select the appropriate option.
30 Using the Veritas Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI ■ 3 Right click the Oracle database icon to display a pop-up menu. Select the appropriate maintenance option. See “Resynchronizing the SFDB repository” on page 96. See “Rescanning the database instance” on page 96. See “Displaying and rescanning tablespace information” on page 97. See “Viewing Storage Mapping” on page 97.
Chapter 2 Managing your database This chapter includes the following topics: ■ Database management tasks in the Veritas Storage Foundation for Oracle GUI ■ About setting up a disk group ■ About selecting a volume layout ■ File system creation guidelines ■ Controlling fragmentation ■ Starting an Oracle database instance ■ Starting an Oracle snapshot database instance ■ Shutting down an Oracle database instance Database management tasks in the Veritas Storage Foundation for Oracle GUI If you
32 Managing your database Database management tasks in the Veritas Storage Foundation for Oracle GUI If you plan to create volume snapshots for the database and use them on either the same host or a secondary one, ensure that your volume layout is consistent with Database FlashSnap requirements. See “Database FlashSnap in the GUI” on page 61.
Managing your database About setting up a disk group About setting up a disk group Before creating file systems for a database, set up a disk group for each database. A disk group lets you group disks, volumes, file systems, and files that are relevant to a single database into a logical collection for easy administration.
34 Managing your database About selecting a volume layout An important factor in database performance is the tablespace placement on the disks. Disk I/O is one of the most important determining factors of your database's performance. Having a balanced I/O load usually means optimal performance. Designing a disk layout for the database objects to achieve balanced I/O is a crucial step in configuring a database.
Managing your database File system creation guidelines I/O and CPU overhead. This overhead can cause considerable performance penalties in online transaction processing (OLTP) workloads. If the database has a high read ratio, however, RAID-5 performance is similar to that of a striped volume.
36 Managing your database Controlling fragmentation ■ Specify the maximum log size when creating file systems for databases. ■ Except for specifying the maximum log size and support for large files as required, use the VxFS defaults when creating file systems for databases. ■ Never disable the intent logging feature of the file system. ■ For redo logs, create a single file system using a simple (and mirrored, if necessary) volume.
Managing your database Starting an Oracle database instance free space becomes broken into fragments. This means that space must be assigned to files in smaller and smaller extents. This process is known as fragmentation. Fragmentation leads to degraded performance and availability. The degree of fragmentation depends on file system usage and activity. Fragmentation utilities in VxFS Allocation units in VxFS are designed to help minimize and control fragmentation.
38 Managing your database Starting an Oracle snapshot database instance To start an Oracle database instance or a cloned Oracle database instance 1 Access the Oracle Start Up Database wizard. See “To access Oracle database wizards in the Java GUI” on page 23. 2 Enter the Oracle SID, Oracle home, and Owner information. Click Next to continue. 3 Enter your password and optionally enter Oracle pfile information, then click Start Database.
Managing your database Shutting down an Oracle database instance 5 Enter the snapshot database information in the appropriate fields: ■ The new Oracle SID ■ Snapplan file ■ The volume name is required to start an off-host snapshot database. ■ Snapshot disk group name ■ The Relocate path is required to start an on-host snapshot database. ■ You can obtain this information by viewing the details after you create a snapshot.
40 Managing your database Shutting down an Oracle database instance ■ Transactional Use this option to shut down the Oracle database instance immediately upon completion of all transactions in progress. If you shut down using this option, no client can start a new transaction on this instance, and a client is disconnected when the transaction in progress ends. The next database start up does not require an instance recovery.
Chapter 3 Using a clone database This chapter includes the following topics: ■ Creating a clone database ■ Removing a clone database Creating a clone database Cloning a database enables you to perform operations without affecting your production database. The Storage Foundation for Oracle GUI provides the Create Clone Database wizard to enable you to create a clone of your database.
42 Using a clone database Creating a clone database Prerequisite The Oracle database must have at least one mandatory archive destination. See Using Database FlashSnap for Backup and Off-Host Processing in the Veritas Storage Foundation for Oracle Administrator's Guide. To create a clone database using a Storage Checkpoint 1 Access the Create Clone Database wizard and select Storage Checkpoint as the method for creating a clone. See “Accessing clone database tasks in the Java GUI” on page 23.
Using a clone database Creating a clone database If you create a clone database using an existing snapplan, you use a portion of the Create Clone Database wizard depending on the status of the snapplan you select: ■ SNAPSHOT_END status: picks up at Create Snapshot point in the process. This status uses the default snapplan settings. ■ INIT_FULL status: picks up at Validate/Modify Snapplan. This status enables selection of forced snapshot creation, authentication settings, and primary database settings.
44 Using a clone database Creating a clone database ■ See “To start up a snapshot using the Create Clone Database wizard” on page 46. Validating or modifying a snapplan for a clone database After creating a new snapplan or selecting an existing snapplan, validate or modify it before proceeding to create a snapshot. To validate or modify a snapplan using the Create Clone Database wizard 1 Access the Validate/Modify dialog of the Create Clone Database wizard.
Using a clone database Creating a clone database Volume oracon on PRODdg is ready for snapshot. Original plex and DCO log for oracon is on PRODdg02. Snapshot plex and DCO log for oracon is on PRODdg01. SNAP_PRODdg for snapshot will include: PRODdg01 ALLOW_REVERSE_RESYNC is yes The snapplan sp3 has been created. Creating snapshot for a clone database After your snapplan is validated, you can create a snapshot for your clone database.
46 Using a clone database Creating a clone database 6 Click OK to continue. You can now use the snapshot as a database backup. Save this information for when you start your snapshot database. 7 The Startup Snapshot dialog displays. proceed to the procedure for starting up a snapshot. See “To start up a snapshot using the Create Clone Database wizard” on page 46. Start up snapshot for a clone database You can start up the clone after creating a clone snapshot.
Using a clone database Creating a clone database 6 See creating and working with snapplans using dbed_vmchecksnap in the Veritas Storage Foundation for Oracle Administrator's Guide. 7 Click Create Clone Database. If the snapshot database was successfully started, you will receive a confirmation message. Click OK to continue. Create snapshot for clone database If you are using an existing snapplan to create the clone database, some parameters are required.
48 Using a clone database Removing a clone database ■ See “To start up a snapshot using the Create Clone Database wizard” on page 46. To create a clone database with an existing snapplan using INIT_DB 1 Access the Create Clone Database wizard. See “Accessing clone database tasks in the Java GUI” on page 23. 2 In the Create Clone Database dialog, select Existing Snapplan The snapplan displays its status. For example, sp00 [init_db], where INIT_DB is the status of the snapplan.
Using a clone database Removing a clone database To remove a Storage Checkpoint clone database 1 Access the Remove Clone Database wizard. See “Accessing clone database tasks in the Java GUI” on page 23. 2 Check the Remove Storage Checkpoint option if you want to remove the Storage Checkpoint along with removing the cloned database. 3 Click the Remove Clone Database button. 4 In the Confirmation dialog, click Yes to proceed.
50 Using a clone database Removing a clone database
Chapter 4 Managing Storage Checkpoints This chapter includes the following topics: ■ About Storage Checkpoints ■ Creating a Storage Checkpoint ■ Viewing Storage Checkpoint details ■ Mounting a Storage Checkpoint ■ Unmounting a Storage Checkpoint ■ Removing a Storage Checkpoint ■ Rolling back to a Storage Checkpoint About Storage Checkpoints A Storage Checkpoint is like an online backup of a database that contains a point-in-time database image.
52 Managing Storage Checkpoints Creating a Storage Checkpoint Creating a Storage Checkpoint You can create a Storage Checkpoint that is: ■ offline ■ online ■ instant If the database is online when the Storage Checkpoint is created, Storage Foundation for Oracle switches the database to online backup mode before creating the Storage Checkpoint. Once the Storage Checkpoint is created, Storage Foundation for Oracle switches the database back to its normal operation mode.
Managing Storage Checkpoints Viewing Storage Checkpoint details ■ 4 To create an instant Storage Checkpoint, click the Instant button. If you want to remove the Storage Checkpoint when the file system becomes full, click the Remove This Storage Checkpoint button. If you want to retain the Storage Checkpoint when the file system becomes full, click the Retain This Storage Checkpoint button. 5 Click Create to continue. 6 At the prompt, click Yes to proceed with creating the Storage Checkpoint.
54 Managing Storage Checkpoints Unmounting a Storage Checkpoint To mount a Storage Checkpoint 1 Access the Mount a Storage Checkpoint wizard. See “Accessing Storage Checkpoint tasks in the Java GUI” on page 24. 2 Verify that you are mounting the correct Storage Checkpoint and click Next to continue. If you selected the wrong Storage Checkpoint, click Cancel. The information on this screen is read-only.
Managing Storage Checkpoints Removing a Storage Checkpoint 3 Verify that you are unmounting the correct Storage Checkpoint and click Unmount to continue. If you selected the wrong Storage Checkpoint, click Cancel. The information on this screen is read-only. 4 At the prompt, click Yes to proceed with unmounting the Storage Checkpoint. 5 A confirmation dialog is displayed. Click OK to continue.
56 Managing Storage Checkpoints Rolling back to a Storage Checkpoint this situation, Veritas Storage Foundation for Oracle checks to see if the target database objects are offline before proceeding. Storage Checkpoints can only be used to roll back files that are damaged due to a software error or a human error (for example, accidental deletion of a table).
Managing Storage Checkpoints Rolling back to a Storage Checkpoint 5 On the second screen, use the drop-down menu to select the appropriate buffer size in the Rollback Buffer Size field. The default buffer size is 128K. The buffer size configured for reads and writes when performing a Storage Rollback can affect performance. Vary the size to determine the optimal setting for your system. 6 Use the drop-down menu to select the appropriate number of threads in the Number of Threads field.
58 Managing Storage Checkpoints Rolling back to a Storage Checkpoint To roll back a tablespace to a Storage Checkpoint 1 Verify that the tablespace to which you want to roll back is offline. 2 Access the Rollback a Storage Checkpoint wizard. See “Accessing Storage Checkpoint tasks in the Java GUI” on page 24. 3 If the database is online, you will receive a prompt asking you if you want to continue. Click Yes to continue the Storage Rollback.
Managing Storage Checkpoints Rolling back to a Storage Checkpoint This option is only available for offline and online Storage Checkpoints. You cannot roll back a datafile to an instant Storage Checkpoint. Prerequisites ■ You can perform this operation while the database is online as long as the datafile is offline. To roll back datafiles to a Storage Checkpoint 1 Verify that the datafile to which you want to roll back is offline. 2 Access the Rollback a Storage Checkpoint wizard.
60 Managing Storage Checkpoints Rolling back to a Storage Checkpoint
Chapter 5 Managing snapshots using Database FlashSnap This chapter includes the following topics: ■ Database FlashSnap in the GUI ■ Creating a snapplan ■ Validating or modifying a snapplan ■ Removing a snapplan ■ Creating a snapshot ■ Creating a clone database with a snapshot ■ Resynchronizing a snapshot to a database ■ Resynchronizing a database to a snapshot ■ Aborting the reverse resychronization operation ■ Viewing the snapplan log Database FlashSnap in the GUI With Veritas Databas
62 Managing snapshots using Database FlashSnap Creating a snapplan ■ Resynchronize snapshots to your database. ■ Resynchronize your database to a snapshot. Database FlashSnap functionality is not supported on duplicated (cloned) databases. Creating a snapplan A snapplan specifies snapshot scenarios for the Oracle database (such as online, offline, and instant). The snapplan is used as a basis for creating a snapshot. You must create and validate the snapplan before you can create the snapshot image.
Managing snapshots using Database FlashSnap Creating a snapplan 7 If needed, modify any incorrect settings. Then, click Validate to ensure that the settings have been configured correctly. For more information regarding the snapplan parameters: See “Creating and Working with Snapplans Using dbed_vmchecksnap” in the Veritas Storage Foundation for Oracle Administrator's Guide. 8 At the confirmation prompt, click Yes to confirm that you want to validate the snapplan.
64 Managing snapshots using Database FlashSnap Validating or modifying a snapplan Volume oracon on PRODdg is ready for snapshot. Original plex and DCO log for oracon is on PRODdg02. Snapshot plex and DCO log for oracon is on PRODdg01. SNAP_PRODdg for snapshot will include: PRODdg01 ALLOW_REVERSE_RESYNC is yes The snapplan sp3 has been created.
Managing snapshots using Database FlashSnap Validating or modifying a snapplan 6 At the confirmation prompt, click Yes to confirm that you want to validate the snapplan. If the snapplan was successfully validated, you will receive a confirmation message. 7 To see the snapplan details, click the Show details checkbox. The snapplan details are displayed in the pop-up window. When you have finished reviewing them, click OK.
66 Managing snapshots using Database FlashSnap Removing a snapplan The snapplan sp3 has been created. Removing a snapplan You may need to remove a snapplan that is no longer necessary. However, you cannot create a snapshot if you do not have a snapplan. Prerequisites ■ You must be logged in as the Oracle database administrator. To remove a snapplan 1 Click the snapplan you want to remove in the object tree. (You may need to expand the tree view to find the icon.
Managing snapshots using Database FlashSnap Creating a clone database with a snapshot 3 If you need to force the snapshot creation, click the Force snapshot creation checkbox. Force snapshot creation can be used after a snapshot operation has failed and the problem was fixed without using Veritas Storage Foundation for Oracle commands. (That is, the volumes were synchronized without using Veritas Storage Foundation for Oracle commands.
68 Managing snapshots using Database FlashSnap Resynchronizing a snapshot to a database Prerequisites Make sure you have enough disk space to create a clone database on your system. ■ You must have an existing snapshot. ■ To create a clone database with a snapshot 1 Click the database object Oracle icon in the object tree. (You may need to expand the tree view to find the icon.) 2 Access the Create Snapshot Database wizard. See “Accessing FlashSnap tasks in the Java GUI” on page 25.
Managing snapshots using Database FlashSnap Resynchronizing a database to a snapshot Prerequisites Usage notes ■ You must be logged in as the Oracle database administrator. ■ You must shut down the clone database and unmount the file systems. ■ See the dbed_vmsnap(1M) manual page for more information. 1 Click a snapplan, located under the Snapplans icon, in the object tree. (You may need to expand the tree view to find the icon.) 2 Access the Resync Snapshot wizard.
70 Managing snapshots using Database FlashSnap Resynchronizing a database to a snapshot To resynchronize a database to a snapshot 1 Click a snapplan, located under the Snapplans icon, in the object tree. (You may need to expand the tree view to find the icon.) 2 Access the Reverse Resync wizard. See “Accessing FlashSnap tasks in the Java GUI” on page 25. 3 Verify the Oracle SID and snapplan information. These are read-only fields.
Managing snapshots using Database FlashSnap Aborting the reverse resychronization operation 9 ■ From the menu bar, select Snapplan > Reverse Resync Snapshot. ■ Right-click the snapplan to bring up a pop-up menu. Then click Reverse Resync Snapshot. The Reverse Resync wizard displays. Click the Commit button, then click Finish to commit the reverse resynchronization process. 10 At the confirmation prompt, click Yes to continue.
72 Managing snapshots using Database FlashSnap Viewing the snapplan log ■ Mounts the original volumes back with the file systems that are configured to use the volume. This action can only be performed after a “begin” action has been completed and cannot be used after a reverse resynchronization has been committed. 6 If the abort action was successful, you will receive a confirmation message. Click Show details to see the actions completed. When you are through, click OK to continue.
Managing snapshots using Database FlashSnap Viewing the snapplan log To view a snapplan log 1 In the object tree, click the snapplan whose log you wish to see. (You may need to expand the tree view to find the icon.) 2 Access the View Log wizard. See “Accessing FlashSnap tasks in the Java GUI” on page 25. A pop-up window appears displaying the path of the Snapplan and the Log. The information displayed is similar to the following output: SNAPSHOT_VERSION=4.
74 Managing snapshots using Database FlashSnap Viewing the snapplan log
Chapter 6 Tiering storage for databases This chapter includes the following topics: ■ About Database Dynamic Storage Tiering in the GUI ■ Setting up Database Dynamic Storage Tiering parameters ■ Setting automatic policies for Database Dynamic Storage Tiering ■ Moving volumes and files ■ Getting reports for Database Dynamic Storage Tiering About Database Dynamic Storage Tiering in the GUI The Veritas Storage Foundation for Oracle GUI enables you to set up automated policies for Database Dynamic S
76 Tiering storage for databases Setting up Database Dynamic Storage Tiering parameters Setting up Database Dynamic Storage Tiering parameters Setting up Database Dynamic Storage Tiering requires some planning in advance.
Tiering storage for databases Setting up Database Dynamic Storage Tiering parameters 3 Set the storage classes or the GUI fills in default values. Click Add Class to specify each storage class in a separate row of the table. To sort table rows by Storage Class or Description, click the column headers. Empty classes are sorted to the bottom of the table. Pre-defined Storage Classes can not be modified or removed. 4 Click Finish when all storage classes are entered.
78 Tiering storage for databases Setting up Database Dynamic Storage Tiering parameters 4 Click Finish when all storage classes are entered. 5 If the parameter updates are successfully implemented, a confirmation message displays. Click OK to continue. Identifying tiered storage directories Set the Database Dynamic Storage Tiering parameters before identifying the directories to which they apply, or the action will fail.
Tiering storage for databases Setting automatic policies for Database Dynamic Storage Tiering ■ Click Yes in confirmation dialog. 6 Click Close. 7 If the directory is successfully converted, a confirmation message displays. Click OK to continue. Classifying volumes Classifying volumes enables you to set specific policies for them. You must define Database Dynamic Storage Tiering parameters before you can classify a volume.
80 Tiering storage for databases Setting automatic policies for Database Dynamic Storage Tiering To list policies 1 In the object tree, select the database object. You may need to expand the tree view to find the database object. 2 Select one of the following methods to access the Database Dynamic Storage Tiering List Policy wizard: 3 ■ In the menu bar, click Oracle > Database Dynamic Storage Tiering Management > List Policy. ■ Right click the database object to bring up a pop-up menu.
Tiering storage for databases Setting automatic policies for Database Dynamic Storage Tiering Setting archive log policy You can set policy for moving archive logs. You must define Database Dynamic Storage Tiering parameters before you can set movement policies for archive logs. Prerequisites ■ Enable Oracle's archive log mode. ■ Mount the archive log device on Veritas File System. To set policy for moving archive logs 1 Access the Database Dynamic Storage Tiering Archive Log Policy wizard.
82 Tiering storage for databases Setting automatic policies for Database Dynamic Storage Tiering To set policy for moving flashback files 1 Access the Database Dynamic Storage Tiering Flashback File Policy wizard. See “To access the tiered storage policy wizards in the Java GUI” on page 27. 2 Select Create or modify policy. 3 Click Next. 4 For each storage class, select the number of days the file is not accessed before it will be moved to that storage class.
Tiering storage for databases Moving volumes and files ■ Click Next. ■ Click Finish. ■ Click Yes to confirm. Moving volumes and files You can operate Database Dynamic Storage Tiering by moving volumes and files manually as needed from one storage class to another. You can move: ■ Tablespaces ■ Datafiles ■ Table partitions Moving tablespaces You can move tablespaces from one storage class to another. You must define Database Dynamic Storage Tiering parameters before you can move tablespaces.
84 Tiering storage for databases Getting reports for Database Dynamic Storage Tiering To move datafiles 1 Access the Database Dynamic Storage Tiering Move Datafiles wizard. See “To access the tiered storage movement wizards in the Java GUI” on page 27. The datafiles and their assigned storage classes display in the Move Datafiles wizard. To sort, click on column headings. 2 Select the datafiles to move. 3 Select the storage class to which the datafiles will be moved.
Tiering storage for databases Getting reports for Database Dynamic Storage Tiering ■ Show activities ■ Show volume usage ■ Show datafile statistics chart Showing activities You can display activities for selected date parameters. To show activities 1 Access the Database Dynamic Storage Show Activities wizard. See “To access the tiered storage report wizards in the Java GUI” on page 28. 2 Select the time period. 3 Click Next.
86 Tiering storage for databases Getting reports for Database Dynamic Storage Tiering Starting datafiles statistics collection 1 Access the Database Dynamic Storage Tiering Start/Stop Datafile Statistics Collection wizard. See “To access tiered storage parameters wizards in the Java GUI” on page 26. 2 Select a datafile for which statistics will be collected. 3 Click Start. 4 Click Finish when all datafiles are set appropriately.
Tiering storage for databases Getting reports for Database Dynamic Storage Tiering ■ Total read/write bytes ■ Average read/write response time 3 Select the time period. 4 Select the sorting parameters. 5 Select the datafiles. 6 Click Next. The statistics are displayed in a bar chart. 7 To display the statistical trend, click Show Statistic TrendThe Show Statistic Trend line chart displays. 8 To move the containers to different storage classes, click Move Container Classes.
88 Tiering storage for databases Getting reports for Database Dynamic Storage Tiering
Chapter 7 Automating database tasks This chapter includes the following topics: ■ About automating tasks using the Java GUI scheduler ■ Adding a scheduled task ■ Viewing scheduled jobs ■ Modifying a scheduled job task ■ Automating creation of a database checkpoint ■ Automating creation of a database snapshot ■ Automating cloning of a database using a checkpoint ■ Automating cloning of a database using FlashSnap ■ Set the schedule parameters for an automated task About automating tasks us
90 Automating database tasks Viewing scheduled jobs To add a task to the scheduler 1 Access the scheduler wizard in GUI. See “Accessing scheduled tasks in the Java GUI” on page 28. 2 Enter the required authorization information for the host on which you want to run the schedule: ■ User name ■ Password By default, authorization is set to the database owner. If you are logged in as the database owner, you do not need to specify a password.
Automating database tasks Modifying a scheduled job task 3 Select jobs to view by status, name, and date. Click Refresh to get the jobs that meet the conditions. 4 To view additional details, click Detail. By default, the Job Detail tab is collapsed. To display job attributes and values, expand the Detail tab. 5 To view command line interface output for a job, click the CLI Output tab in the Detail view. 6 Click Closewhen finished.
92 Automating database tasks Automating creation of a database checkpoint Automating creation of a database checkpoint You can automate the creation of a database checkpoint using the scheduler. To create a database checkpoint 1 Access the scheduler wizard in GUI. See “Accessing scheduled tasks in the Java GUI” on page 28. 2 Select the Create database checkpoint option. 3 Click Next.
Automating database tasks Automating cloning of a database using FlashSnap To clone a database using checkpoint 1 Access the scheduler wizard in GUI. See “Accessing scheduled tasks in the Java GUI” on page 28. 2 Select the Clone database using checkpoint option. 3 Click Next. 4 To restart the database, check the Restart database checkbox. 5 Enter the target database information: 6 ■ New Oracle SID ■ Mount Point Click Create Clone Database .
94 Automating database tasks Set the schedule parameters for an automated task Set the schedule parameters for an automated task The scheduler enables you to set or modify schedule parameters for automated tasks based on: ■ Specific routine ■ Week days ■ Days of the month ■ Specific dates To set schedule parameters 1 Select and configure a task. See “To create a database checkpoint” on page 92. See “To create a database snapshot” on page 92. See “To clone a database using checkpoint” on page 93.
Chapter 8 Maintaining your system configuration This chapter includes the following topics: ■ System configuration maintenance ■ Resynchronizing the SFDB repository ■ Rescanning the database instance ■ Displaying and rescanning tablespace information ■ Viewing Storage Mapping ■ Viewing I/O statistics ■ Determining the datafile file type ■ Converting Quick I/O files to regular datafiles ■ Updating rescan intervals ■ Checking your system configuration ■ Saving the system configuration
96 Maintaining your system configuration Resynchronizing the SFDB repository The GUI also allows you to check and save the configuration of each Oracle database instance on your system. Information on all volumes, file systems and their types, and disk groups can be displayed. Resynchronizing the SFDB repository You can resynchronize the SFDB repository to make sure system information is up-to-date.
Maintaining your system configuration Displaying and rescanning tablespace information Displaying and rescanning tablespace information You can rescan, or refresh, tablespaces to make sure system information is up-to-date. When a new tablespace is created or when existing tablespaces are deleted, the changes can be updated by selecting the option to rescan the database instance. By selecting the option to rescan the tablespace information, you can update the system with current information more quickly.
98 Maintaining your system configuration Determining the datafile file type ■ The number of times you wish to sample the data. You can enter a value from 0 to 9999. ■ The interval, in minutes, between sampling points. You can enter a value from 0 to 9999. The Total Sampling Period (in hours) displays the time used to perform the sampling of the data. The Display accumulated data checkbox is checked by default. The Time Elapsed (in minutes) displays the amount of time it took to sample the data.
Maintaining your system configuration Updating rescan intervals 3 Select the conversion option in the GUI to generate datafile statistics. 4 At the prompt, click Yes to convert to a regular datafile. 5 In the confirmation dialog, click OK to view the information. Updating rescan intervals VERITAS Storage Foundation for Oracle periodically scans the system for updated information. You can modify the rescan intervals to be faster or slower.
100 Maintaining your system configuration Checking your system configuration Checking for Oracle releases... Oracle Release 10 found. Checking for ODM package... WARNING: Could not save session selections in the file "/.sw/sessions/swlist.last": Permission denied (13). sure the "/.sw/sessions/" directory exists. VRTSodm 5.0.31.5.%20090719 Veritas Oracle Disk Manager Valid ODM package found. Checking Veritas ODM Library... Veritas ODM Library found.
Maintaining your system configuration Saving the system configuration 101 hsm_write_prealloc = 0 read_ahead = 1 inode_aging_size = 0 inode_aging_count = 0 fcl_maxalloc = 127099904 fcl_keeptime = 0 fcl_winterval = 3600 fcl_ointerval = 600 oltp_load = 0 Examining Oracle volume and file system layout. Data for database FLAS10r2 is contained in one volume group. Examining Oracle internal information. Oracle Version is 10.2.0.4.0. Control file /snap_data10r2/FLAS10r2/control01.
102 Maintaining your system configuration Saving the system configuration To save the system configuration of a database 1 Select the database icon in the GUI. 2 Select the Save System Configuration option in the GUI to view the database configuration information. 3 In the System Configuration wizard, enter a path name, or directory, in the Path field to indicate where you would like to save the system configuration information. 4 Click Save to save the configuration information.
Appendix A Veritas Database FlashSnap status information This appendix includes the following topics: ■ Obtaining database FlashSnap snapshot status and database status from the GUI Obtaining database FlashSnap snapshot status and database status from the GUI You can obtain both the snapshot status and the snapshot database status from the GUI. The tables in this section provide detailed information regarding the various status values.
104 Veritas Database FlashSnap status information Obtaining database FlashSnap snapshot status and database status from the GUI Table A-1 Snapshot status (as seen Completed Operations in the Snapplan State field) Allowed Operations Modify/Validate ■ Create Snapshot Snapplan (successful) ■ Resync Snapshot (successful) ■ Reverse Resync Snapshot with the commit option (successful) init_full ■ snapshot_start ■ Create Snapshot (failed) ■ If the Create Snapshot operation failed, contact your system adm
Veritas Database FlashSnap status information Obtaining database FlashSnap snapshot status and database status from the GUI Table A-1 (continued) Snapshot status (as seen Completed Operations in the Snapplan State field) resync_start ■ Allowed Operations Resync Snapshot (failed) ■ If the Resync Snapshot operation failed, contact your system administrator for help.
106 Veritas Database FlashSnap status information Obtaining database FlashSnap snapshot status and database status from the GUI Table A-1 (continued) Snapshot status (as seen Completed Operations in the Snapplan State field) Allowed Operations restartdb_end ■ Create Snapshot Database ■ Shut Down Database with with the Restart the unmount option database option (successful) restartdb_end ■ Create Snapshot Database ■ Unmount Snapshot with the Restart Database with the database option unmount option
Veritas Database FlashSnap status information Obtaining database FlashSnap snapshot status and database status from the GUI Table A-1 (continued) Snapshot status (as seen Completed Operations in the Snapplan State field) recoverdb_start ■ Allowed Operations Create Snapshot Database ■ Recover the snapshot with the Restart database manually, then database option (failed) run the db2ed_vmclonedb -o update_status command from the CLI Note: This option is not supported in the GUI.
108 Veritas Database FlashSnap status information Obtaining database FlashSnap snapshot status and database status from the GUI Table A-1 (continued) Snapshot status (as seen Completed Operations in the Snapplan State field) umount_end ■ db2ed_vmclonedb -o umount command from the CLI was successful Note: This option is not supported in the GUI.
Appendix B Accessibility and Veritas Storage Foundation for Oracle This appendix includes the following topics: ■ About Veritas Storage Foundation for Oracle accessibility ■ Keyboard conventions ■ Keyboard navigation and shortcuts in Veritas Storage foundation for Oracle ■ Keyboard shortcuts ■ Menu hot keys ■ Support for accessibility settings and assistive technologies About Veritas Storage Foundation for Oracle accessibility Veritas products meet federal accessibility requirements for softwa
110 Accessibility and Veritas Storage Foundation for Oracle Keyboard conventions accessible PDF files, and the online help is provided as HTML displayed in a compliant viewer.
Accessibility and Veritas Storage Foundation for Oracle Keyboard conventions Table B-2 VEA additions to Microsoft keyboard conventions (continued) Convention Mnemonic Accelerator Delete Now D ALT+ D Delete Temporary Files on Exit e ALT+ E Disconnect D None Help H ALT+ H Number of Items in History N ALT+ N Rescan R None Set to defaults S ALT+ S Remember Password R ALT+ R Password P ALT+P Username U ALT+ U Table B-3 VEA Help additions to Microsoft keyboard conventions Con
112 Accessibility and Veritas Storage Foundation for Oracle Keyboard conventions formed by dotted lines. These areas are said to have focus and will respond to commands. All Veritas GUIs use the following keyboard navigation standards: ■ Tab moves the focus to the next active area, field, or control, following a preset sequence. Shift+Tab moves the focus in the reverse direction through the sequence. ■ Ctrl+Tab exits any Console area that you internally navigate with Tab.
Accessibility and Veritas Storage Foundation for Oracle Keyboard navigation and shortcuts in Veritas Storage foundation for Oracle Tabbed dialog boxes Some dialog boxes use tabbed pages to subcategorize groups of many options. Each tabbed page contains different groups of controls. Use Tab to move the focus between tabs within a dialog box. Typing the mnemonic for a tab also moves the focus to the tab and displays its page of controls.
114 Accessibility and Veritas Storage Foundation for Oracle Keyboard navigation and shortcuts in Veritas Storage foundation for Oracle Veritas Enterprise Administrator (VEA) has the following exceptions and additions to the Microsoft Keyboard standard: Table B-5 VEA additions to Microsoft keyboard conventions Convention Mnemonic Accelerator Connect C None Contents C None Delete Now D ALT+ D Delete Temporary Files on Exit e ALT+ E Disconnect D None Help H ALT+ H Number of Items in Hi
Accessibility and Veritas Storage Foundation for Oracle Keyboard navigation and shortcuts in Veritas Storage foundation for Oracle Table B-7 VEA Help additions to Microsoft keyboard conventions (continued) Convention Mnemonic Accelerator Find Next n F3 Find Previous P None Hide Navigation Tabs H None Index I None Print P None Search S None Synchronize n None General keyboard navigation within the GUI You can navigate and use Veritas Storage Foundation for Oracle with only the keyb
116 Accessibility and Veritas Storage Foundation for Oracle Keyboard navigation and shortcuts in Veritas Storage foundation for Oracle ■ Tab moves focus between controls within the dialog box along a preset sequence. ■ Controls displaying a mnemonic (an underlined letter) can be selected regardless of focus by typing ALT and the underlined letter. ■ A dark border indicates the default command button. Press Enter at any time to choose the button with a dark border.
Accessibility and Veritas Storage Foundation for Oracle Keyboard shortcuts There are different kinds of listboxes with additional navigation conventions: ■ Drop-down listboxes by default show only the selected item. A small button to the right of the control shows a downward-pointing arrow. Select the arrow to display more items from the listbox. If there are more choices than can fit in the preset listbox area, a slider appears along the side of the listbox.
118 Accessibility and Veritas Storage Foundation for Oracle Menu hot keys Keyboard shortcuts are not case-sensitive. Mnemonic keystrokes may be pressed either sequentially or simultaneously. All menu items have mnemonics, but not all menu items have accelerators. Keyboard navigation The following table lists some of the keys frequently used to navigate with the keyboard: Table B-10 Keyboard navigation Keyboard input Result TAB Move forward between panes in the active Console window.
Accessibility and Veritas Storage Foundation for Oracle Menu hot keys Table B-11 Menu hot keys Action Keyboard Input File ALT+F to open the menu, then: ToolsTools Actions View Window Help Tablespaces ■ C– Display the connection dialog window ■ D-Display the disconnection dialog window ■ n-Create new window ■ r–Display the properties of the connected host ■ u–Page setup for print ■ w–Print preview ■ P–Print the page ■ x –Exit ALT+T to open the menu, then: ■ P–Set the display pre
120 Accessibility and Veritas Storage Foundation for Oracle Menu hot keys Table B-11 Menu hot keys (continued) Action Keyboard Input Container Alt+C to open the menu, then: C–Conversion, to convert oracle datafiles to Quick I/O files.
Accessibility and Veritas Storage Foundation for Oracle Support for accessibility settings and assistive technologies Table B-11 Menu hot keys (continued) Action Keyboard Input Snapplan ALT+ S to open menu, then: Storage Checkpoints Storage Checkpoint Tablespaces ■ M–Modify/Validate a snapplan ■ R–Remove a Snapplan ■ C–Create a snapshot using snapplan ■ y–Resync a snapshot ■ v–Reverse Resync a snapshot ■ L–View log for the Snapplan ALT+S to open menu, then: ■ C–Create a Storage Checkp
122 Accessibility and Veritas Storage Foundation for Oracle Support for accessibility settings and assistive technologies Note: Though all graphics in Veritas documentation can be read by screen readers, setting your screen reader to ignore graphics may improve performance.
Index A accessibility assistive technology support 121 dialog boxes 112, 115 keyboard navigation 111, 115 keyboard shortcuts 117 ARCHIVELOG mode 52 assistive technology support 121 automating tasks adding a scheduled task 89 creating checkpoint database 92 creating clone database using checkpoint 92 creating clone database using FlashSnap 93 creating FlashSnap database 92 modifying a scheduled task 91 set schedule parameters 94 viewing scheduled tasks 90 B browsers, supported for Web GUI 21 C clone datab
124 Index disk groups configuration guidelines 33 DRL 35 DSS workloads guidelines 35 Dynamic Database Storage Tiering getting reports 84 moving files and volumes 83 setting automatic policy 79 setting up parameters 76 maintaining your configuration (continued) resynchronizing the SFDB repository 96 saving the system configuration 101 updating rescan intervals 99 viewing I/O statistics 97 viewing storage mapping 97 menus Storage Rollback Administration 55 mirroring choosing 34 F O fast recovery 35 file
Index scheduling tasks (continued) creating FlashSnap database 92 modifying a scheduled task 91 set schedule parameters 94 viewing scheduled tasks 90 selecting volume layouts 33 SFDB repository resynchronizing 96 snapplan abort reverse resync 71 creating 62 modifying 64 removing 66 validating 64 view the snapplan log 72 snapshot creating 66 creating a clone with a snapshot 67 resynchronizing a snapshot to a database 68 reverse resync 69 Storage Checkpoint removing a clone Storage Checkpoint clone 48 Storag
