DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2001

    Hotbackup Issues

    Hello all,

    I got two ORA-1146's signalled during backing up two datafiles. I noticed when querying v$backup after the backup finished:

    SQL> select * from v$backup;

    ---------- ------------------ ---------- ---------
    1 NOT ACTIVE 115001425 10-MAY-06
    2 NOT ACTIVE 115001443 10-MAY-06
    3 NOT ACTIVE 115001494 10-MAY-06
    4 NOT ACTIVE 115001505 10-MAY-06
    5 NOT ACTIVE 114373811 09-MAY-06
    6 NOT ACTIVE 115001544 10-MAY-06
    7 NOT ACTIVE 115001443 10-MAY-06
    8 NOT ACTIVE 114373842 09-MAY-06
    9 NOT ACTIVE 115002590 10-MAY-06

    The ora-1146 happened for files 5 and 8 respectively. I looked up the error and this was the explanation given:

    // *Cause: When starting an online backup it was noticed that an online backup
    // was already started for one of the data files.
    // *Action:End the first backup before beginning another.

    However, i checked at the time and no other backup was going on. Also does this mean that the current backup I have is not valid as the dates for the two dbfs are not current? How do i resolve this?

    Confused and will be grateful for some advise,

    Thanks in advice,

  2. #2
    Join Date
    Apr 2006
    What process is kicking off the backup? Do you have a copy of the script?

  3. #3
    Join Date
    Dec 2001

    It is a script that has 100% worked before. The script is kicked of via a crontab entry. I have also noticed that the backup of the 9th generated 2 backups for the same file id 8. I dont know how this could have happened. Today it backed up just one copy, however v$backup showed last nights timestamp. I am tempted to run another backup just to make sure everything is ok.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.