How to restore volume by using SMO ?

[3GISSMORACLE]

Hi ,

I'm using SMO        3.1

              OracleDB 10.2.0

              OS           HP-UX

I took a offlinebackup on a entrire database . When I restored database everything worked well. And I don't know if we can use SMO to restore volume (where database is installed/created)  from the snapshot/backup or do I need to configure 'smo.conf'  to make volume restoring function available ?

I 've got these errors below when I tried to restore volume:

-[ INFO] SD-00053: Finished preview of volume restore of [stona01:/vol/test_SMO] (with host-side resources [vgnetapp_SMO]) from snapshots [[smo_testsmo_testsmo_f_c_1_8a2aa0b23068f82f013068f83ad00001_0]]
--[ERROR] FLOW-11019: Failure in CheckVolumeRestoreMode: Volume restore is required, but cannot be performed.
--[ERROR] FLOW-11008: Operation failed: Volume restore is required, but cannot be performed.
--[ERROR] SMO-03041: The restore plan is: Restore Plan:
  Preview:

    The following components will be restored completely via: host side file copy restore
      /SMO/oracle/oradata/TESTSMO/sysaux01.dbf
      /SMO/oracle/oradata/TESTSMO/system01.dbf
      /SMO/oracle/oradata/TESTSMO/test01.dbf
      /SMO/oracle/oradata/TESTSMO/undotbs01.dbf
      /SMO/oracle/oradata/TESTSMO/users01.dbf

  Analysis:

    The following reasons prevent certain components from being restored completely via: storage side file system restore
      * Files in file system /SMO not part of the restore scope will be reverted.
      * File systems in volume group vgnetapp_SMO not part of the restore scope will be reverted: [/SMO]
    Components not in restore scope:
      /SMO/oracle/oraInventory/sessionContext.ser
      /SMO/oracle/oraInventory/install.platform
      /SMO/oracle/oraInventory/oraInstaller.properties

Best Regard

Tien

[jakub_wartak · Accepted solution]

Hi Tien,

It prevents you from doing storage side restore (a very fast one) because you would overwrite/loose files that are not part of the Oracle database image (are not data files, e.g. OraInventory here is part of "Oracle installer"). You should be able to relocate oraInventory to some directory outside of /SMO/ mount point/VG.

In short: strictly following best-practices for storage layouts should help prevent this from happening.

-J.

[3GISSMORACLE]

Thank you , Jakub,

Now It works perfectly .

Case's closed

Best Regard

Tien