Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

In recovery catalog no found backups obsolete

3401456Oct 22 2018 — edited Nov 27 2018

RMAN> connect target /

connected to target database: XXXXXXXX (DBID=2761987891)

RMAN> connect catalog USER/PASSWORD@CATALOG

connected to recovery catalog database

RMAN> report obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 17 days

no obsolete backups found

---------------------------------------------

WITHOUT CONNECTION TO CATALOG

RMAN> connect target /

connected to target database: xxxxxx (DBID=2761987891)

RMAN> report obsolete;

using target database control file instead of recovery catalog

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 17 days

Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           11434  30-SEP-18

  Backup Piece       12796  30-SEP-18          /zfssa/xxxxxx/backup1/lutecco6_1_1

Backup Set           11436  30-SEP-18

  Backup Piece       12798  30-SEP-18          /zfssa/xxxxxx/backup1/lvtecco9_1_1

Backup Set           11437  30-SEP-18

  Backup Piece       12799  30-SEP-18          /zfssa/xxxxxx/backup1/m0teccob_1_1

Backup Set           11439  30-SEP-18

  Backup Piece       12801  30-SEP-18          /zfssa/xxxxxx/backup1/m1teccoe_1_1

Backup Set           11438  30-SEP-18

  Backup Piece       12800  30-SEP-18          /zfssa/xxxxxx/backup1/m2teccoh_1_1

Backup Set           11440  30-SEP-18

  Backup Piece       12802  30-SEP-18          /zfssa/xxxxxx/backup1/m3teccoj_1_1

....

...

...

Backup Set           11516  03-OCT-18

  Backup Piece       12878  03-OCT-18          /zfssa/xxxxxx/backup1/ogtemupk_1_1

RMAN> show all;

RMAN configuration parameters for database with db_unique_name XXXXXX are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 17 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE DB_UNIQUE_NAME 'XXXXXX' CONNECT IDENTIFIER  'XXXXXXX';

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/zfssa/xxxxxxx/backup1/snapcf_XXXXXXX.f';

¿¿¿???

Comments
Post Details
Added on Oct 22 2018
14 comments
2,253 views