Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

To back up an SFDB repository

Verify that the database is online and that the backup location directory has

write permission enabled for the DBA Oracle user.

Verify the SFDB repository is up to date:

$ dbed_update -S $ORACLE_SID -H $ORACLE_HOME

As Oracle DBA user, run the backup command with the appropriate options.

For example:

$ /opt/VRTS/bin/sfua_rept_util -S Prod -o backup

Backing up Repository for SID='Prod'

Copying Repository for SID=Prod to '/etc/vx/vxdba/Prod/.sfdb_rept'

Backup Repository for SID='Prod' Completed

To restore an SFDB repository

As Oracle DBA user, run the list command to display the SFDB repository

backup files.

$ /opt/VRTS/bin/sfua_rept_util -S Prod -o list

Listing Repository Backups for SID='Prod'

TIME SIZE NAME

2009-08-11@15:53 925696 rept.PROD.db_2009-08-11@15:53

2009-08-11@15:54 925696 rept.PROD.db_2009-08-11@15:54

As Oracle user, run the restore command with the appropriate options.

For example:

$ /opt/VRTS/bin/sfua_rept_util -S Prod -o restore -f rept.PROD.db_2009-08-11@15:54

Restoring Repository for SID='Prod'

Restore Repository for SID='Prod' Completed

Migrating Storage Foundation for Databases (SFDB)

objects from single instance Oracle to Oracle RAC

After migrating from Storage Foundation HA to Storage Foundation for Oracle

RAC, the Storage Foundation for Databases (SFDB) objects created in a single

instance Oracle environment will not be available in the Oracle RAC environment.

Administering Storage Foundation for Databases (SFDB) tools

Migrating Storage Foundation for Databases (SFDB) objects from single instance Oracle to Oracle RAC