Veritas Storage Foundation for Oracle 5.
Legal Notices © Copyright 2008 Hewlett-Packard Development Company, L.P. Publication Date: 2008 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 Chapter 1 Using the VERITAS Storage Foundation for Oracle graphical user interface About GUI components ................................................................... 9 About GUI functions ..................................................................... 13 Using Veritas Enterprise Administrator Service ................................. 14 Adding users to the Veritas Enterprise Administrator .................... 15 Removing users from the Veritas Enterprise Administrator ............
6 Contents Chapter 2 Managing your database Database management tasks in the Veritas Storage Foundation for Oracle GUI ............................................................................ About setting up a disk group ......................................................... Disk group configuration guidelines .......................................... About selecting a volume layout ...................................................... How to choose appropriate stripe unit sizes ...............
Contents Rolling back datafiles to a Storage Checkpoint ............................. 71 Chapter 5 Managing snapshots using Database FlashSnap Database FlashSnap in the GUI ....................................................... Creating a snapplan ...................................................................... Validating or modifying a snapplan ................................................. Removing a snapplan ....................................................................
8 Contents 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 ........................... Chapter 8 Maintaining your system configuration System configuration maintenance .........................
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 ■ Performing tasks in the Storage Foundation for Oracle Web GUI About GUI compon
10 Using the VERITAS Storage Foundation for Oracle graphical user interface About GUI components 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 platform, Windows NT, Windows 98, Windows 2000, Windows Me, and Windows XP machine that supports the Java Runtime Environment.
Using the VERITAS Storage Foundation for Oracle graphical user interface About GUI components Figure 1-1 Veritas Storage Foundation for Databases Java GUI 11
12 Using the VERITAS Storage Foundation for Oracle graphical user interface About GUI components Figure 1-2 Veritas Storage Foundation for Databases Web GUI Sections of the main window for the Java GUI: ■ Menu bar: enables you to perform various SFDB operations. The options in the Menu Bar vary according to the object in the object tree that you have selected. To access online help from the Menu Bar, click Help > Contents.
Using the VERITAS Storage Foundation for Oracle graphical user interface About GUI functions from the Object Tree. When you use your mouse to point at an icon, a description of the icon appears. ■ Information tabs: enable you to view different information about the same object in the Object Tree. For example, if you are viewing details about a database, you can click a different tab to view different information about that database.
14 Using the VERITAS Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service ■ 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. Please read all “Prerequisites” and “Usage notes” before starting a procedure.
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 15. ■ You must have superuser (root) privileges to execute the vxsvcctrl command.
16 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.
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 user_name [-h fully_qualified_host_name -d domain_name -t domain_type] See the table for command usage details.
18 Using the VERITAS Storage Foundation for Oracle graphical user interface Using Veritas Enterprise Administrator Service 4 To add a user without root privileges, use the vxdbedusr command: # /opt/VRTS/bin/vxdbedusr -a user -n user_name 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 added.
20 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 AIX lslpp -L VRTSorgui HP-UX swlist | grep VRTSorgui Linux rpm -qi VRTSorgui -common Solaris pkginfo -l 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 21 To remove a user, use the vxdbedusrcommand as follows. # /opt/VRTS/bin/vxdbedusr -r user -n user_name [-h fully_qualified_host_namee -d domain_name -t domain_type] See the table for command usage details.
22 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 Initializing Storage Foundation Provider 5.0 for Oracle If you are using AIX, press to continue after the output is displayed.
Using the VERITAS Storage Foundation for Oracle graphical user interface Starting the DBED agent 3 23 Again verify the status of the VEA Service: # /opt/VRTSob/bin/VxSVCctrl status Current state of server : NOT RUNNING 4 To stop the Web Console: for the /opt/VRTSob/webgui/veaw stop 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.
24 Using the VERITAS Storage Foundation for Oracle graphical user interface Opening and closing the Veritas Storage Foundation for Oracle GUI For the Java GUI, you must have the client software installed before you can use the Java GUI. For the Web GUI, supported browsers are: Solaris Mozilla 1.6 HP-UX Mozilla 1.6 AIX Mozilla 1.6 Linux Netscape 7.2 or greater, Firefox 1.07 or greater, Mozilla 1.6 Windows Internet Explorer 5.5, Netscape 7.2 or greater, Firefox 1.07 or greater, Mozilla 1.
Using the VERITAS Storage Foundation for Oracle graphical user interface Opening and closing the Veritas Storage Foundation for Oracle GUI Opening the Veritas Storage Foundation for Oracle Java GUI from a Windows client The VEA Service and DBED agent must be running on the server. If you need to start the VEA Service or DBED agent: See “Starting the Veritas Enterprise Administrator Service” on page 21. See “Starting the DBED agent” on page 23.
26 Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI Performing tasks in the Veritas Storage Foundation for Oracle Java GUI You can perform the following tasks in the Veritas Storage Foundation for Oracle Java GUI.
Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI Accessing clone database tasks in the Java GUI You can use the Veritas Storage Foundation for Oracle Java GUI for: ■ Creating a clone database ■ Removing a clone database To access the Create Clone Database wizard in the Java GUI 1 Click the database in the object tree.
28 Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI ■ Rolling back a Storage Checkpoint 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.
Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI To access the snapplan wizards in the Java GUI 1 Click the Snapplans 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 Snapshot wizard. 3 ■ From the menu bar, select Snapplans. ■ Right click the Snapshot Plans icon to display a pop-up menu. Select a wizard option.
30 Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI ■ In the menu bar, click Oracle > Database Dynamic Storage Tiering Management. ■ Right click the database object to display a pop-up menu. Then, click Database Dynamic Storage Tiering Management. Select the appropriate wizard from the list presented. The wizard displays. See “To set up Database Dynamic Storage Tiering parameters” on page 88.
Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Veritas Storage Foundation for Oracle Java GUI See “To move tablespaces” on page 95. See “To move datafiles” on page 96. See “To move table partitions” on page 96. 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.
32 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.
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 110. See “Rescanning the database instance” on page 110. See “Displaying and rescanning tablespace information” on page 110. See “Viewing Storage Mapping” on page 111.
34 Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Storage Foundation for Oracle Web GUI Performing tasks in the Storage Foundation for Oracle Web GUI You can perform the following tasks in the Veritas Storage Foundation for Oracle Web GUI.
Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Storage Foundation for Oracle Web GUI Accessing database tasks in the Web GUI You can use the Veritas Storage Foundation for Oracle Web GUI for: Clone tasks: ■ Creating a clone database ■ Removing a clone database Storage Checkpoint tasks: ■ Creating a Storage Checkpoint ■ Viewing a Storage Checkpoint ■ Mounting a Storage Checkpoint ■ Unmounting a Storage Checkpoint ■ removing a Storage Checkpoint
36 Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Storage Foundation for Oracle Web GUI 4 Select a database task in the clone drop down list to display the corresponding wizard. See “To create a clone database using a Storage Checkpoint” on page 52. See “Creating a clone database using Database FlashSnap” on page 52. See “To remove a Storage Checkpoint clone database” on page 60. See “To remove a Storage Checkpoint clone database” on page 60.
Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Storage Foundation for Oracle Web GUI ■ Viewing Storage Mapping ■ Viewing I/O statistics ■ Viewing Oracle datafile topology or statistics ■ Determining the datafile file type ■ Converting regular datafiles to Quick I/O Files ■ Converting Quick I/O files to regular datafiles ■ Updating rescan intervals ■ Checking your system configuration ■ Saving the system configuration Note: Quick I/O is not
38 Using the VERITAS Storage Foundation for Oracle graphical user interface Performing tasks in the Storage Foundation for Oracle Web GUI
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 ■ Restarting an Oracle database instance Database management tasks in the Verit
40 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 73. Create the VxFS file systems you need on the See “File system creation guidelines” volumes on page 44. Install and configure your database.
Managing your database About setting up a disk group For off-host processing or backup, you can See “Database FlashSnap in the GUI” use the Database FlashSnap feature to create on page 73. a volume snapshot for the database. Database FlashSnap lets you capture an online image of an actively changing database at a given instant, known as a snapshot. You can perform backups and off-host processing tasks on snapshots while providing continuous availability of your critical data.
42 Managing your database About selecting a volume layout See the “Tuning for Performance” chapter of the Veritas Storage Foundation for Oracle Administrator's Guide. For more about disk groups and disk group procedures, see the Veritas Enterprise Administrator Guide. For more about disk groups and disk group procedures, see the Volume Manager Web GUI Online Help.
Managing your database About selecting a volume layout same controller or across multiple disks on multiple controllers. By striping across multiple controllers, disk I/O can be balanced across multiple I/O channels. The decision is based on the disk and controller bandwidth and the database workload. In general, for most OLTP databases, use the default stripe unit size of 64 K or smaller for striped volumes and 16 K for RAID-5 volumes.
44 Managing your database File system creation guidelines ■ When system availability is critical, use RAID-5 for read-intensive OLTP workloads to improve database performance and availability. Use RAID-5 logs to allow fast volume resynchronization in the event of a system crash. ■ For most decision support system (DSS) workloads, where sequential scans are common, experiment with different striping strategies and stripe-unit sizes.
Managing your database Controlling fragmentation if your database block size is 32K and your file system block size is 8k, VxFS can put four 8K blocks together to perform one 32K database I/O operation. When creating the file system, set the number of file system blocks in the intent log so that the log size is 16MB. For example, if the file system block size is 8K (that is, 8192), it will take 2000 blocks to make a 16MB log (2000 x 8192 = ~16MB).
46 Managing your database Starting an Oracle database instance ■ Extent fragmentation As files are created and removed, the free extent map for an allocation unit changes from having one large free area to having many smaller free areas. Extent fragmentation occurs when files cannot be allocated in contiguous chunks and more extents must be referenced to access a file. In a case of extreme fragmentation, a file system may have free space that cannot be allocated.
Managing your database Shutting down an Oracle database instance To start an Oracle snapshot database instance 1 Access the Oracle Start Instance Start Up Snapshot Database wizard. See “To access Oracle database wizards in the Java GUI” on page 26. See “Accessing database management tasks in the Web GUI” on page 34. 2 In the “connect as” section, enter the local Oracle home information. Then, enter your UNIX user name and password.
48 Managing your database Shutting down an Oracle database instance To shut down an Oracle database instance 1 Access the Oracle Shutdown Database wizard. See “To access Oracle database wizards in the Java GUI” on page 26. See “Accessing database management tasks in the Web GUI” on page 34. 2 Verify the database information, such as the Oracle SID and Oracle Home. Then, click Next to continue. 3 Verify your UNIX user name, then enter your password in the Password field.
Managing your database Restarting an Oracle database instance and the instance is terminated without closing the files. The next database start up requires an instance recovery. In this release, the option to shutdown or unmount the FlashSnap clone database has been removed. Use the Remove Clone Database option to shutdown or unmount the FlashSnap clone database. See cloning a database in the Storage Foundation for Oracle Administrator's Guide. 5 Click Shutdown instance at the bottom of the screen.
50 Managing your database Restarting an Oracle database instance
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.
52 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 27.
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.
54 Using a clone database Creating a clone database ■ See “To start up a snapshot using the Create Clone Database wizard” on page 57. 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 Original plex and DCO log for ORACLE1 is on PRODdg02. Snapshot plex and DCO log for ORACLE1 is on PRODdg01. 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.
56 Using a clone database Creating a clone database 5 Click the Show details checkbox to view the actions taken. A sample of the snapplan details: dbed_vmsnap started at 2004-05-13 17:09:40 SFDB repository is up to date. The database is running in archivelog mode. A snapshot of ORACLE_SID PROD is in DG SNAP_PRODdg. Snapplan sp2 is used for the snapshot. SFDB repository volume is SNAP_ORACLE1. If -r is used in dbed_vmclonedb, make sure is created and owned by Oracle DBA.
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 57. Start up snapshot for a clone database You can start up the clone after creating a clone snapshot.
58 Using a clone database Creating a clone database 5 For the snapshot database information section, verify the snapplan file and Snapshot disk group name. These are read-only fields. Enter the new Oracle SID and Relocate path in the appropriate fields. To start an on-host snapshot database, the Relocate path is required. Make sure the Relocate path has the database owner's permission.
Using a clone database Removing a clone database 3 Select a snapplan from the drop-down list with INIT_FULL status. The Create Snapshot dialog displays. 4 Use the following dialog procedures in order: ■ See “To create a snapshot using the Create Clone Database wizard” on page 55. ■ See “To start up a snapshot using the Create Clone Database wizard” on page 57. To create a clone database with an existing snapplan using INIT_DB 1 Access the Create Clone Database wizard.
60 Using a clone database Removing a clone database Removing a Storage Checkpoint clone database Removing a Storage Checkpoint clone database enables you to unmount the clone database with the option of removing the checkpoint. 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 27. See “Accessing database tasks in the Web GUI” on page 35.
Using a clone database Removing a clone database 3 Click the Remove Clone Database button. 4 In the Confirmation dialog, click Yes to proceed with removing the clone database.
62 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.
64 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 offline Storage Checkpoint, click the Offline button. ■ 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.
66 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 27. See “Accessing database tasks in the Web GUI” on page 35. 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 To unmount a Storage Checkpoint 1 Click a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.
68 Managing Storage Checkpoints Rolling back to a Storage Checkpoint Rolling back to a Storage Checkpoint You can roll back a database file, a list of database files, a single tablespace, or the entire database to a Storage Checkpoint. To perform a Storage Rollback, you must have a valid Storage Checkpoint. This option is not available with an instant Storage Checkpoint. The GUI does not automatically roll back the control file associated with a Storage Checkpoint.
Managing Storage Checkpoints Rolling back to a Storage Checkpoint While the Storage Rollback process is running, it creates a temporary file, /filesystem/.VRTSstrb.lock, in each file system. Do not remove these temporary lock files. To rollback the database to a Storage Checkpoint 1 Shut down the Oracle database from the GUI. 2 Click the a specific Storage Checkpoint in the object tree. (You may need to expand the tree view to find the Storage Checkpoint.
70 Managing Storage Checkpoints Rolling back to a Storage Checkpoint Rolling back a tablespace to a Storage Checkpoint If a tablespace is corrupted or removed due to a software error or a human mistake, this operation rolls back all of the files of the corrupted or removed tablespace to a Storage Checkpoint. This option is only available for offline and online Storage Checkpoints. You cannot roll back a tablespace to an instant Storage Checkpoint.
Managing Storage Checkpoints Rolling back to a Storage Checkpoint 7 Click the Rollback a Tablespace button to indicate that you are rolling back the tablespace to the Storage Checkpoint. 8 Click Next to continue. Select the tablespace, or tablespaces, you would like to roll back by clicking the appropriate checkbox in the Tablespace list. 9 Click Roll Back to continue. 10 If the Storage Rollback was successful, a confirmation message displays. Click OK to continue.
72 Managing Storage Checkpoints Rolling back to a Storage Checkpoint 6 Use the drop-down menu to select the appropriate number of threads in the Number of Threads field. The default number of threads is four. Depending on the number of CPUs available on your system and the type of volume on which the file system is located, this default setting may specify too few or too many threads. 7 Click the Roll back a Datafile button to indicate that you are rolling back the datafile to the 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
74 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.
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.
76 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.
78 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 snapshot Usage notes ■ See the dbed_vmsnap(1M) manual page for more information. ■ If you are creating an offhost snapshot, perform these steps on the secondary host. To create a snapshot 1 Access the Create Snapshot wizard. See “Accessing FlashSnap tasks in the Java GUI” on page 28. See “Accessing database tasks in the Web GUI” on page 35. 2 Verify the snapplan location. (This is a read-only field.
80 Managing snapshots using Database FlashSnap Creating a snapshot 5 If the snapshot creation was successful, you will receive a confirmation message. Click the Show details checkbox to view the actions taken. You should see information similar to the following: dbed_vmsnap started at 2004-05-13 17:09:40 repository is up to date. The database is running in archivelog mode. A snapshot of ORACLE_SID PROD is in DG SNAP_PRODdg. Snapplan sp2 is used for the snapshot. repository volume is SNAP_ORACLE1.
Managing snapshots using Database FlashSnap Creating a clone database with a snapshot Creating a clone database with a snapshot After having created a snapshot, you can use the snapshot to create a clone database. The cloned database can be used for decision-making and testing that cannot be done on your production database. Prerequisites Make sure you have enough disk space to create a clone database on your system. ■ You must have an existing snapshot.
82 Managing snapshots using Database FlashSnap Resynchronizing a snapshot to a database 7 Click Start Database. 8 At the confirmation prompt, click Yes to confirm that you want to start the database. If the snapshot database was successfully started, confirmation message displays. Click OK to continue. Resynchronizing a snapshot to a database Resynchronizing a snapshot to a database will refresh the snapshot so that it contains the most recent changes made to your production database.
Managing snapshots using Database FlashSnap Resynchronizing a database to a snapshot Resynchronizing a database to a snapshot Resynchronizing your database to a snapshot, also known as reverse resynchronization, reverts your database to a snapshot. Use this option if your database becomes corrupted and you need to restore your database to a previous point-in-time. Prerequisites Usage notes ■ You must be logged in as the Oracle database administrator.
84 Managing snapshots using Database FlashSnap Aborting the reverse resychronization operation 8 9 Select one of the following methods to access the Reverse Resync wizard: ■ 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.
Managing snapshots using Database FlashSnap Viewing the snapplan log The Abort option performs the following actions: ■ Unmounts the snapshot volumes. ■ 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.
86 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 28. See “Accessing database tasks in the Web GUI” on page 35. A pop-up window appears displaying the path of the Snapplan and the 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
88 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.
90 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.
92 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.
94 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 30. 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.
96 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 30. 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 31. 2 Select the time period. 3 Click Next.
98 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 29. 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.
100 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
102 Automating database tasks Adding a scheduled task Adding a scheduled task To automate a database task, you must add it to the scheduler. To add a task to the scheduler 1 Access the scheduler wizard in GUI. See “Accessing scheduled tasks in the Java GUI” on page 31. 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.
Automating database tasks Modifying a scheduled job task To view a sortable summary of scheduled jobs 1 Access a scheduled job in the GUI. See “Accessing scheduled tasks in the Java GUI” on page 31. 2 Right-click the scheduled job and select View Jobs. The View Jobs page displays. 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 Details. By default, the Job Details tab is collapsed.
104 Automating database tasks Automating creation of a database checkpoint ■ 5 Clone a database using snapshot Click Next to modify the appropriate task. See “To create a database checkpoint” on page 104. See “To create a database snapshot” on page 104. See “To clone a database using checkpoint” on page 105. See “To clone a database using snapshot” on page 105. Automating creation of a database checkpoint You can automate the creation of a database checkpoint using the scheduler.
Automating database tasks Automating cloning of a database using a checkpoint 3 Select the name of the snapplan that will be used for creating the snapshot. 4 Click Next to set the schedule parameters. See “Set the schedule parameters for an automated task” on page 106. Automating cloning of a database using a checkpoint You can automate the cloning of a database from a checkpoint using the scheduler. To clone a database using checkpoint 1 Access the scheduler wizard in GUI.
106 Automating database tasks Set the schedule parameters for an automated task 7 In the Create Snapshot Database page, set Oracle home. 8 Enter the target database information: 9 ■ New Oracle SID ■ Relocate path Click Next to set the schedule parameters. See “Set the schedule parameters for an automated task” on page 106.
Automating database tasks Set the schedule parameters for an automated task 4 To set days of the month, click Days of Month and check the days you want the automated task to run. 5 To include or exclude specific days, click Specific Dates and select the dates you want to include or exclude running the automated task. Use the right and left arrows as needed to adjust the Include dates and Exclude dates. 6 When the scheduling information is complete, click Finish. The automated task is created.
108 Automating database tasks Set the schedule parameters for an automated task
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 regular datafiles to Quick I/O Files ■ Converting Quick I/O files to regular datafiles ■ Updating rescan intervals ■ Checking your system
110 Maintaining your system configuration Resynchronizing the SFDB repository or refresh, database instances, datafiles, and tablespaces to make sure system information is up-to-date. 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 Viewing Storage Mapping To display tablespace information 1 Access the wizard for this task. See “Accessing system maintenance tasks in the Java GUI” on page 32. See “Accessing system maintenance tasks in the Web GUI” on page 36. 2 Expand your view to display the tablespace information. 3 Select the rescan option. 4 Click OK to continue. Viewing Storage Mapping The Storage Foundation for Oracle GUI enables you to view Storage Mapping topology.
112 Maintaining your system configuration Determining the datafile file type ■ 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. The progress status bar displays the percentage of sampling that is being completed.
Maintaining your system configuration Converting Quick I/O files to regular datafiles To convert Oracle datafiles to Quick I/O files 1 Shut down the database from the GUI. 2 Select the datafile in the GUI. 3 Select the conversion option in the GUI to generate datafile statistics. 4 At the prompt, click Yes to convert to a Quick I/O file. 5 In the confirmation dialog, click OK to view the information.
114 Maintaining your system configuration Checking your system configuration To update a rescan interval 1 Select the database icon in the GUI. 2 Select the Update Rescan Intervals option in the GUI to update the rescan interval times. 3 To update a partial rescan interval, enter a new time (in seconds) in the appropriate field. To update a full rescan interval, enter a new time (in seconds) in the appropriate field. 4 Click Save to save your changes. A confirmation dialog displays.
Maintaining your system configuration Checking your system configuration NOTICE: 0 files are fragmented. Examining File System tunable settings. NOTICE: Parameters for all VxFS file systems used by TEST9i.
116 Maintaining your system configuration Saving the system configuration WARNING: Control files are not spread over multiple file systems. Spread control files over multiple file systems for better redundancy. Examining Oracle automatic extension of datafiles. Total of 0 datafiles are configured to autoextend. Total of 2 datafiles are defined to the database. Examining Oracle log modes. The database is running in archivelog mode. The database is running in automatic log archiving mode.
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.
118 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.
120 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.
122 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
124 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
126 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.
128 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
130 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. Show or hide the list using F4.
132 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 ■ 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 preferences ■
134 Accessibility and Veritas Storage Foundation for Oracle Menu hot keys Table B-11 Menu hot keys (continued) Action Keyboard Input DB2 Instances ALT+D to open the menu, then: ■ S–Start the DB2 instance U–Update the rescan intervals to be faster or slower ■ E–Rescan system information ■ ■ DB2 Instance DB2 Database Tablespaces Container R-View properties ALT+D to open the menu, then: ■ C–Create Snapshot Database ■ D–Shut down the DB2 Instance ■ E–Rescan system information ■ S–Start th
Accessibility and Veritas Storage Foundation for Oracle Menu hot keys Table B-11 Menu hot keys (continued) Action Keyboard Input Oracle Instance ALT+ O to open the menu, then: Monitoring Agent Snapplans Snapplan Storage Checkpoints ■ S– Startup the database instance ■ D– Shut down the database ■ C–Create Clone Database ■ o–Resync Repository ■ h– Check System configuration ■ a– Save system configuration ■ R–Rescan Oracle instance ALT+M to open the menu, then: ■ S–Start the monitorin
136 Accessibility and Veritas Storage Foundation for Oracle Support for accessibility settings and assistive technologies Table B-11 Menu hot keys (continued) Action Keyboard Input Storage Checkpoint ALT+S to open menu, then: Tablespaces ■ B–Rollback a storage checkpoint ■ M–Mount a storage checkpoint ■ U–Unmount a storage checkpoint ■ R–Remove a storage checkpoint ■ C–Create a Clone Database ALT+ S to open the menu, then: ■ Datafile R–Rescan tablespaces ALT+D to open the menu, then: T
Index A accessibility assistive technology support 136 dialog boxes 126, 129 keyboard navigation 125, 129 keyboard shortcuts 131 ARCHIVELOG mode 64 assistive technology support 136 automating tasks adding a scheduled task 102 creating checkpoint database 104 creating clone database using checkpoint 105 creating clone database using FlashSnap 105 creating FlashSnap database 104 modifying a scheduled task 103 set schedule parameters 106 viewing scheduled tasks 102 B browsers, supported for Web GUI 23 C clo
138 Index disk group naming a disk group 41 disk groups configuration guidelines 41 DRL 43 DSS workloads guidelines 44 Dynamic Database Storage Tiering getting reports 96 moving files and volumes 95 setting automatic policy 91 setting up parameters 88 F fast recovery 43–44 file locks during Storage Rollback 69 file systems configuration guidelines 44 fragmentation 45 controlling 45 types 45 free space 67 G guidelines creating file systems 44 disk groups 41 for DSS workloads 44 for OLTP workloads 43 stri
Index S scheduling tasks adding a scheduled task 102 creating checkpoint database 104 creating clone database using checkpoint 105 creating clone database using FlashSnap 105 creating FlashSnap database 104 modifying a scheduled task 103 set schedule parameters 106 viewing scheduled tasks 102 selecting volume layouts 42 SFDB repository resynchronizing 110 snapplan abort reverse resync 84 creating 74 modifying 76 removing 78 validating 76 view the snapplan log 85 snapshot creating 78 creating a clone with a
