![]() |
< Previous | Next > |
Product: Storage Foundation for Databases Guides | |
Manual: Storage Foundation 4.1 for Oracle Administrator's Guide |
Creating a Snapshot (dbed_vmsnap)The dbed_vmsnap command creates a snapshot of an Oracle database by splitting the mirror volumes used by the database into a snapshot database. You can use the snapshot image on either the same host as the database or on a secondary host provided storage is shared by the two hosts. The snapshot image created by dbed_vmsnap is a frozen image of an Oracle database's datafiles. dbed_vmsnap ensures that a backup control file is created when the snapshot database is created, which allows for complete data recovery, if needed. For a complete list of all snapshot and database statuses, see VERITAS Database FlashSnap Status Information. ![]()
The snapshot volumes now represent a consistent backup copy of the database. You can backup the database by copying the snapshot volumes to tape or other backup media. For details, see Backing Up the Database from Snapshot Volumes (dbed_vmclonedb). You can also create another Oracle database for decision-support purposes. See Cloning a Database (dbed_vmclonedb) for more information. For information on creating a snapshot using the GUI, see Using the VERITAS Storage Foundation for Oracle Graphical User Interface. In this example, a snapshot image of the database, PROD, is created for a single-host configuration. In this case, the SECONDARY_HOST parameter is set the same as the PRIMARY_HOST parameter in the snapplan. $ /opt/VRTS/bin/dbed_vmsnap -S PROD -f snap1 -o snapshot dbed_vmsnap started at 2004-04-02 14:15:27 VxDBA repository is up to date. The database is running in archivelog mode. A snapshot of ORACLE_SID PROD is in DG SNAP_PRODdg. Snapplan snap1 is used for the snapshot. If -r <relocate_path> is used in dbed_vmclonedb, make sure <relocate_path> is created and owned by Oracle DBA. Otherwise, the following mount points need to be created and owned by Oracle DBA: /prod_db. /prod_ar. dbed_vmsnap ended at 2004-04-02 14:16:11 In this example, a snapshot image of the primary database, PROD, is created for a two-host configuration. In this case, the SECONDARY_HOST parameter specifies a different host name than the PRIMARY_HOST parameter in the snapplan. $ /opt/VRTS/bin/dbed_vmsnap -S PROD -f snap2 -o snapshot dbed_vmsnap started at 2004-04-09 23:01:10 VxDBA repository is up to date. The database is running in archivelog mode. A snapshot of ORACLE_SID PROD is in DG SNAP_PRODdg. Snapplan snap2 is used for the snapshot. VxDBA repository volume is SNAP_arch. If -r <relocate_path> is used in dbed_vmclonedb, make sure <relocate_path> is created and owned by Oracle DBA. Otherwise, the following mount points need to be created and owned by Oracle DBA: dbed_vmsnap ended at 2004-04-09 23:02:58 |
^ Return to Top | < Previous | Next > |
Product: Storage Foundation for Databases Guides | |
Manual: Storage Foundation 4.1 for Oracle Administrator's Guide | |
VERITAS Software Corporation
www.veritas.com |