Get the App
SLTechnology News&Howtos  ›  Database  › 

Configure the default backup types backupset and image copy

Shulou Source: shulou.com Published: 2022-06-01 06:43:35 11月12日 Update

The backup command can create backup sets or mirror copies of two backup types. On disk

We can back up as a backup set or a mirror copy. The default backup type is an uncompressed backup set. "on disk, the backup type can only be a backup set, not a mirrored copy."

Configure the default backup type

1. Default image file to disk

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY

two。 Default backup set to disk

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET

3. Default compression backup set to disk

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

4. Compress the backup set to tape by default

CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COMPRESSED BACKUPSET

Try to change the default configuration to mirror copy to disk

RMAN > show device type

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

RMAN > CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY

New RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1

New RMAN configuration parameters are successfully stored

Released channel: ORA_DISK_1

RMAN > show device type

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1

Try to change the default configuration to mirror copy to tape

RMAN > CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO COPY

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of configure command at 07/23/2017 22:50:47

RMAN-06609: AS COPY can be configured only for disk device

Fail

Change the default configuration to backup set to tape

RMAN > CONFIGURE DEVICE TYPE sbt BACKUP TYPE TO BACKUPSET

New RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO BACKUPSET PARALLELISM 1

New RMAN configuration parameters are successfully stored

RMAN > configure default device type to sbt

Old RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'

New RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'

New RMAN configuration parameters are successfully stored

Both statements were modified successfully, and the statement configure default device type to xxx that configures the default backup device actually specifies the backup set whose default backup type is uncompressed.

Tags: Backup disk Mirror Type configuration copy Tape statement attempt success two Command File device Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS OPPO Reno Huawei Linux Microsoft