Is there any RMAN wildcards (%, *) to search for files from rman autobackup?

1 vote

0 answers

32 views

                          I've created a controlfile autobackup like it

    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '${ORACLE_SID}_autobackup_${data}_CONTROL%F';

how to find it when restoring the autobackup using the command

    run{
    set controlfile autobackup format for device type sbt to '%F';
    allocate channel c1 device type sbt parms='SBT_LIBRARY=/u01/app/oci/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oci/configfile.ora)';
    restore controlfile from autobackup;
    }

the command set controlfile autobackup format for device type sbt to '%F' does not work, it does not find anything.

It only works when a pass the full file name like:

    run{
    set controlfile autobackup format for device type sbt to 'testesolaire_autobackup_20250314_0931_CONTROL%F'
    allocate channel c1 device type sbt parms='SBT_LIBRARY=/u01/app/oci/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oci/configfile.ora)';
    restore controlfile from autobackup;
    }

Is there any wildcards to seach any file?

something like * (from linux)

    set controlfile autobackup format for device type sbt to '*%F'

Asked by Astora (841 rep)

Mar 14, 2025, 01:06 PM

Is there any RMAN wildcards (%, *) to search for files from rman autobackup?

Related Questions