DATAFILE_BLOCKS The number of data blocks in the datafile
BLOCKS The number of data blocks written to the backup
BLOCK_SIZE The size of the data blocks in bytes
So BLOCKS * BLOCK_SIZE will give the number of bytes written for this
particular datafile and hence the size of the backup piece may be calculated.
SQL> select bs_key, sum(blocks*block_size)
from rc_backup_datafile
group by bs_key;
If you do not use catalog (controlfile):
SQL>select bs_key, sum(blocks*block_size)
from v$backup_datafile
group by bs_key;
To get Availability Domain oci iam availability-domain list #!/bin/bash OCI_AD="hQsi:SA-SAOPAULO-1-AD-1" OCI_COMPARTMENT="ocid1.compartment.oc1..aaaaaaaavgyjpoffz5qliieawamjaksfb6juxejurtduclqjkvv66ookcxja" #Get Silver policy ocid funct_get_policy(){ OCI_POL_OCID=$(oci bv volume-backup-policy list | jq -r '.data[] | select(."display-name"|contains("silver"))' | jq -r '.id') } funct_boot_vol (){ #Create a file with all boot volume ocid oci bv boot-volume list --availability-domain ${OCI_AD} -c ${OCI_COMPARTMENT} | jq -r '.data[].id' > boot-vol.txt while IFS="" read -r p || [ -n "$p" ] do printf 'Seeting backup policy for %s\n' "$p" oci bv volume-backup-policy-assignment create --asset-id $p --policy-id ${OCI_POL_OCID} done < boot-vol.txt } funct_block_vol (){ #Create a file with all block volume ocid oci bv volume list -c ${OCI_COMPARTMENT} | jq -r '.data[].id' ...
Comentários
Postar um comentário