delete obsolete in oracle 8
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: delete obsolete in oracle 8

  1. #1
    Join Date
    Apr 2006
    Posts
    35

    delete obsolete in oracle 8

    Hello there,
    could some one tell me how to delete obsolete backup in oracle 8
    my report look like this

    RMAN> report obsolete;

    RMAN-03022: compiling command: report
    RMAN-06280: Report of obsolete backup sets and datafile copies
    RMAN-06281: Type Recid Stamp Filename
    RMAN-06282: -------------------- ------ --------- --------------------------
    RMAN-06284: Backup Set 11 602527592
    RMAN-06285: Backup Piece 11 602527580 C:\BKPL0602527575
    RMAN-06284: Backup Set 8 602339721
    RMAN-06285: Backup Piece 8 602339711 C:\TESTBACKUP602339707
    RMAN-06284: Backup Set 5 602178252
    RMAN-06285: Backup Piece 5 602178242 C:\0_602178238


    thanks for ur help

  2. #2
    Join Date
    Apr 2006
    Posts
    35
    i found one way


    MAN> allocate channel for delete type disk;

    MAN-03022: compiling command: allocate
    MAN-03023: executing command: allocate
    MAN-08030: allocated channel: delete
    MAN-08500: channel delete: sid=10 devtype=DISK

    MAN> change backuppiece 'c:\0_602178238' delete;

    MAN-03022: compiling command: change
    MAN-03023: executing command: change
    MAN-08073: deleted backup piece
    MAN-08517: backup piece handle=C:\0_602178238 recid=5 stamp=602178242
    MAN-03023: executing command: partial resync
    MAN-08003: starting partial resync of recovery catalog
    MAN-08005: partial resync complete

    MAN> report obsolete;

    MAN-03022: compiling command: report
    MAN-06280: Report of obsolete backup sets and datafile copies
    MAN-06281: Type Recid Stamp Filename
    MAN-06282: -------------------- ------ --------- --------------------------
    MAN-06284: Backup Set 11 602527592
    MAN-06285: Backup Piece 11 602527580 C:\BKPL0602527575
    MAN-06284: Backup Set 8 602339721
    MAN-06285: Backup Piece 8 602339711 C:\TESTBACKUP602339707


    if u know a way where one need not give backuppiece name explicitly,plz let me know
    thanks for ur support

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    delete obsolete;

  4. #4
    Join Date
    Apr 2006
    Posts
    35
    Sir,
    but this is what i get

    C:\>rman80 rcvcat a/a@adm

    Recovery Manager: Release 8.0.6.0.0 - Production

    RMAN-06008: connected to recovery catalog database

    RMAN> connect target internal/oracle@orc0

    RMAN-06005: connected to target database: ORC0

    RMAN> report obsolete;

    RMAN-03022: compiling command: report
    RMAN-06280: Report of obsolete backup sets and datafile copies
    RMAN-06281: Type Recid Stamp Filename
    RMAN-06282: -------------------- ------ --------- --------------------------
    RMAN-06284: Backup Set 11 602527592
    RMAN-06285: Backup Piece 11 602527580 C:\BKPL0602527575
    RMAN-06284: Backup Set 8 602339721
    RMAN-06285: Backup Piece 8 602339711 C:\TESTBACKUP602339707

    RMAN> delete obsolete;

    RMAN-00569: ================error message stack follows================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "obsolete": expecting one of: "script"
    RMAN-01007: at line 1 column 8 file: standard input

    RMAN-00569: ================error message stack follows================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found ";": expecting one of: "allocate, beginline, cat
    alog, change, connect, create, delete, exit, endinline, host, {, library, list,
    print, register, release, replace, report, reset, resync, rman, rpctest, run, se
    t, sql, test"
    RMAN-01007: at line 1 column 16 file: standard input

    RMAN>

    Thanks for ur support

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