Tag: rman

what is your backup and recovery strategy?

what is your backup and recovery strategy?

December 11, 2010 | By | Add a Comment

Hello friends, Yes our title is explaining every thing. What backup and recovery plan you are using? There are lot of alternatives find out in Oracle database server.  Take example replication, advance replication, oracle stream, dataguard, physical standby, logical standby, datapump, export/import, user managed cold backup, user managed hot backup and RMAN etc. Recovery manager […]

Read More

Delete archives using RMAN in Oracle

Delete archives using RMAN in Oracle

October 11, 2010 | By | 1 Comment

Hi friends, Today we see how to delete archive forcefully using RMAN. When some of archives are being deleted from disk and RMAN still consider those archives due to retention period. Then we can delete those archives from rman metadata using following command. RMAN>delete unavailable; If we are getting some specific archive related error or […]

Read More

To solve  RMAN-06207, RMAN-06208, RMAN-06210 errors

To solve RMAN-06207, RMAN-06208, RMAN-06210 errors

July 21, 2010 | By | Add a Comment

Hi friends, Sometimes we are facing errors from RMAN for Oracle backup as following. RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN-06211: ========================== RMAN-06212:   Object Type   Filename/Handle RMAN-06213: ————— ————————————————— RMAN-06214: Archivelog      /ocfs2/arch/SPTELCO/SPTELCO_1_18272_647314401.arc RMAN-06214: Archivelog      […]

Read More