Forum Stats

  • 3,825,765 Users
  • 2,260,558 Discussions
  • 7,896,665 Comments

Discussions

rman backup

User_U9EN2
User_U9EN2 Member Posts: 20 Blue Ribbon
edited Jan 13, 2020 8:07AM in Recovery Manager (RMAN)

Hi All,

Using Oracle 11gR2 on RHEL 6.

I had to kill a rman job as it was very slow. It was taking a rman hot backup at tablespace level. There are 120 .dbf files and it backed till 60.

> BACKUP AS COMPRESSED BACKUPSET TAG 'PRODDAT_TBLSPC_BK' TABLESPACE PRODDTA;

My RMAN RETENTION - RETENTION POLICY TO REDUNDANCY 1

Crosschecked the backup;

CROSSCHECK BACKUPPIECE TAG = 'PRODDAT_TBLSPC_BK';

deleted the files;

DELETE BACKUP OF TABLESPACE PRODDTA;

When I run the backup job it starts from 61 number. How to clear all files and start the job from 1st file..

Thanks

Answers

  • Sunny kichloo
    Sunny kichloo Member Posts: 2,459 Gold Trophy
    edited Jan 13, 2020 6:57AM

    What option you used to kill the RMAN Jobs?

    You said it ran slow and now did you change anything for getting performance?

  • User_U9EN2
    User_U9EN2 Member Posts: 20 Blue Ribbon
    edited Jan 13, 2020 8:00AM

    Kill -9 <processid>

    To improve performance I added using 4 channels with parallel 4

    ..

    anyways the job is running fine now, file sequence back to 1.

    I didn't understand why it started at 61..

    Will monitor the job and keep posted..

  • Joerg.Sobottka
    Joerg.Sobottka Senior Consultant and Oracle Ace Member Posts: 597 Bronze Trophy
    edited Jan 13, 2020 8:07AM

    Well, normally I say, don't think too much and let RMAN handle that for you.

    Typically RMAN starts with datafiles that were not touched longer (so longer not backed up files first, newer backed up files later) at the latest runs, but this also depends, especially if you have more than one channel. The only thing you need to know is that, after RMAN has finished the backup, all files should have been backed up. The order of the files don't matter.