Home » RDBMS Server » Backup & Recovery » Is there a way to compress an existing uncompressed backupset (11.2.0.4 SLES SP3)
Is there a way to compress an existing uncompressed backupset [message #646687] Wed, 06 January 2016 17:44 Go to next message
juniordbanewbie
Messages: 176
Registered: April 2014
Senior Member
Dear all,

I've a done a uncompressed backup of archivelog and later wanted to compressed it, how do i do it?



show device type;

RMAN configuration parameters for database with db_unique_name ORCLEE are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;



backup backupset 169828 tag 'ORCLEE_20160105_backupset_arc' delete input;



list backup of archivelog all completed between "to_Date('2016-01-06 15:00', 'YYYY-MM-DD HH24:MI')" and  "to_Date('2016-01-06 16:30','YYYY-MM-DD HH24:MI')";

List of Backup Sets
===================


BS Key  Size
------- ----------
169828  1.14G

.....
Backup Set Copy #2 of backup set 169828
  Device Type Elapsed Time Completion Time     Compressed Tag
  ----------- ------------ ------------------- ---------- ---
  DISK        00:00:13     2016-01-06 15:44:23 NO         ORCLEE_20160105_BACKUPSET_ARC

    List of Backup Pieces for backup set 169828 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    170064  1   AVAILABLE   +FRA/orclee/backupset/2016_01_06/annnf0_orclee_20160105_backupset_arc_0.4254.900431053

  Backup Set Copy #1 of backup set 169828
  Device Type Elapsed Time Completion Time     Compressed Tag
  ----------- ------------ ------------------- ---------- ---
  DISK        00:00:13     2016-01-06 15:25:48 NO         ORCLEE_20160106_ARC

    List of Backup Pieces for backup set 169828 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    169831  1   AVAILABLE   +FRA/orclee/backupset/2016_01_06/annnf0_orclee_20160106_arc_0.4489.900429935



many thanks in advance!
Re: Is there a way to compress an existing uncompressed backupset [message #646701 is a reply to message #646687] Thu, 07 January 2016 01:06 Go to previous message
John Watson
Messages: 7212
Registered: January 2010
Location: Global Village
Senior Member
backup as compressed backupset backupset all delete input;
Previous Topic: Restore and migration from Windows32bit to Linux64bit
Next Topic: RMAN Backup
Goto Forum:
  


Current Time: Thu Jan 18 00:56:25 CST 2018

Total time taken to generate the page: 0.01751 seconds