Skip to main content
SnapManager Oracle

Protecting database backups on secondary or tertiary storage

Contributors

You can use SnapManager to protect the backup copies on secondary or tertiary storage systems.

  1. Enter the following command: smo backup create -profile profile_name {[-full {-online | -offline | -auto} [-retain {-hourly | -daily | -weekly | -monthly | -unlimited}] [-verify] | [-data [[-filesfiles [files]] | [-tablespaces-tablespaces [-tablespaces]] [-datalabellabel] {-online | -offline | -auto} [-retain {-hourly | [-daily | -weekly | -monthly | -unlimited]} [-verify] | [-archivelogs [-labellabel] [-commentcomment] [-snapvaultlabelSnapVault_label][-protect | -noprotect | -protectnow] [-backup-destpath1 [,[path2]]] [-exclude-destpath1 [,path2]]] [-prunelogs {-all | -untilSCNuntilSCN | -until-date yyyy-MM-dd:HH:mm:ss | -before {-months | -days | -weeks | -hours}} -prune-destprune_dest1,[prune_dest2]] [-taskspectaskspec]} [-dump] [-force] [-quiet | -verbose]

    If you want to…​ Then do this…​

    Create a backup of an online or offline database, rather than allowing SnapManager to manage whether it is online or offline

    Specify the -offline or -online option to create a backup of the offline database or online database. If you use the -offline or -online option, you cannot use the -auto option.

    Let SnapManager manage backing up a database, regardless of whether it is online or offline

    Specify the -auto option. If you use the -auto option, you cannot use the -offline or -online option.

    Add a comment about the backup

    Specify the -comment option, followed by the description string.

    Force the database into the state in which you have specified to back it up, regardless of the state it is currently in

    Specify the -force option.

    Verify the backup at the time of creation

    Specify the -verify option.

    Create a backup on secondary storage

    Specify the -protect option.

    • If you are using ONTAP and want to protect the backup immediately to the secondary storage, specify the -protect option.

      Note The -protectnow option is not applicable in clustered Data ONTAP.
    • If you are using Data ONTAP operating in 7-Mode and want to protect the backup immediately to secondary storage overriding the Protection Manager protection schedule, specify the -protectnow option.

    • To prevent the backup to secondary storage, specify the -noprotect option. If you are using ONTAP and you selected the SnapManager_cDOT_Vault protection policy while creating the profile, you must specify the -snapvaultlabel option. You must provide the SnapMirror label that you specified in the rules of the SnapMirror policy while setting up the SnapVault relationship as the value.

    Specify the retention class values

    Specify the -retain option and indicate whether the backup should be retained depending on one of the following retention classes:

    • -hourly

    • -daily

    • -weekly

    • -monthly

    • -unlimited If you do not specify the retention class, SnapManager uses -hourly by default.

Examples

The following command protects a database backup:

smo backup create -profile PAYDB -protect -retain -daily -full auto -label full_bkup_sales

The following command immediately protects a database backup:

smo backup create -profile PAYDB -protectnow -retain -daily -full auto -label full_bkup_sales