-
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
-
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
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|