Backup error on RMAN after tablespace creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Backup error on RMAN after tablespace creation

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    Hi there,
    I managed to perform level 0 backup successfully. I created a new tablespace, with a datafile. I tried doing a level 1 backup and it complained 'no parent record'. SO I did a level 0 backup and it crashes when it comes to that tablespace's datafile:

    RMAN> run {
    2> allocate channel tbsdsk type disk;
    3> backup
    4> incremental level 0
    5> tag incr_tbs0
    6> setsize=2097142
    7> format '/u07/tapebackup/tape0/fndry_p/%d_%u'
    8> (database include current controlfile);
    9> release channel tbsdsk;
    10> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: tbsdsk
    RMAN-08500: channel tbsdsk: sid=11 devtype=DISK

    RMAN-03022: compiling command: backup
    RMAN-03024: performing implicit full resync of recovery catalog
    RMAN-03023: executing command: full resync
    RMAN-08002: starting full resync of recovery catalog
    RMAN-08004: full resync complete
    RMAN-03023: executing command: backup
    RMAN-08008: channel tbsdsk: starting incremental level 0 datafile backupset
    RMAN-08502: set_count=66 set_stamp=415650606 creation_time=06-DEC-00
    RMAN-08010: channel tbsdsk: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00003 name=/u03/oradata/fndry_p/rbs01.dbf
    RMAN-08522: input datafile fno=00006 name=/u04/oradata/fndry_p/indx01.dbf
    RMAN-08522: input datafile fno=00015 name=/u04/oradata/fndry_p/test_ts1.dbf
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00601: fatal error in recovery manager
    RMAN-03004: fatal error during execution of command
    RMAN-10038: database session for channel tbsdsk terminated unexpectedly
    bash$

    I even did a manual resync. Please help.
    Thanks,
    Nirasha

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Give a try with this!!
    To peform this your RMAN should operate using RECOVERY CATALOG

    Use CATALOG command at RMAN prompt

    Add your new datafile after connecting to RMAN

    RMAN>catalog datafile '/u04/oradata/fndry_p/<NEW DATA FILENAME>' level 0;

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