RMAN Tablespaces Backup
Published by : Obay Salah , November 19, 2024
RUN{ ALLOCATE CHANNEL D1 DEVICE TYPE DISK MAXPIECESIZE 1G; BACKUP AS COMPRESSED BACKUPSET TABLESPACE USERS; }
We created a backup copy for the USERS TABLESPACE of the type Compressed Backupset, which is a compressed copy of the Backupset type.
We manually created the Channel and specified that the largest size of a backup piece should not exceed 1GB.
In general, the Compressed Backupset option is available for backing up all files supported by RMAN, and the advantage of this option is that it reduces the size of the backup files.
Of course, a backup copy for the Tablespace can also be created as an Image Copy.
RMAN>BACKUP AS COPY TABLESPACE USERS;
You can confirm the success of the backup operation above by using the command:
LIST BACKUPSET OF TABLESPACE USERS
This will display information about the backup of the type Users Tablespace Backupset.
To display information about the backup of the type Users Tablespace Image Copy, use the command:
LIST COPY OF TABLESPACE USERS
Comments
no comment yet!