Results 1 to 6 of 6

Thread: RMAN problem

  1. #1
    Join Date
    Sep 2006
    Posts
    30

    Unanswered: RMAN problem

    I am having problems using RMAN to backup my database. I added a new tablespace. Ever since then, the RMAN backup has been failing. It seems to be trying to backup that tablespace seperately after everything else is backed up. The RMAN backup file is already there, so the backup is failing. Any hints on how to integrate this tablespace in with the rest of the backup?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    Maybe if you post the ERRORS we would not have to use a crystal ball to interpret your post.


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2006
    Posts
    30

    Got it

    I think I found it. I was reading the documentation and I had to add this line:
    configure controlfile autobackup on;

    Thanks for the help.

    Does anyone out there have a good way to drop the EXAMPLE tablespace? Using the DROP tablespace command gives me erros about dropping queue tables.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Using the DROP tablespace command gives me erros about dropping queue tables.
    Errors? What errors? I don't see any errors.
    Why do you insist on trying to describe what you think is happening; rather than use CUT & PASTE so we can see what you are ACTUALLY doing & exactly how Oracle is responding?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2006
    Posts
    30
    SQL> drop tablespace EXAMPLE including contents and datafiles cascade constraints;
    drop tablespace EXAMPLE including contents and datafiles cascade constraints
    *
    ERROR at line 1:
    ORA-24008: queue table QS.QS_ORDERS_PR_MQTAB must be dropped first

    All I want to do is to get rid of the EXAMPLE tablespace.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    24008, 00000, "queue table %s.%s must be dropped first"
    // *Cause: An error was detected when dropping a queue table in a cluster,
    // tablespace, or schema.
    // *Action: Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the specified
    // queue table first; then, retry the operation.
    //
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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