| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN: nocatalog; remove backed up archived redos
Leng,
If you dont use a catalog with rman you wouldn't be able to store scripts
to make automated backups and restore. Also that means that all the
information about your backups will be stored in the control file of the
target database, if you loose your controlfiles will loose all the
information
of your backups, so they will be useless.
Allocate channel for delete type disk;
change datafilecopy 'yourfile' delete;
release channel;
This would work for you
Luck (Suerte)
Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do>
809-565-3121
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Leng Kaing
Enviado el: Tuesday, 23 October, 2001 6:10 PM
Para: Multiple recipients of list ORACLE-L
Asunto: RMAN: nocatalog; remove backed up archived redos
Hello everyone,
Env: 8i and 8.0
I've been digging around the rman manuals and metalink but can't seem to find anything decent on this so thought I'd try this forum...
Firstly, what functionality do you loose when you don't use a catalog?
2ndly, how does one delete old backups? I'm backing up to disk. All is fine with the backup. But now I need to delete the backups from disk, and remove the information about the backup from the controlfile.
Tried doing this but failed:
RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: delete_05 RMAN-08500: channel delete_05: sid=15 devtype=DISK
RMAN> change backuppiece 70 delete;
RMAN-03022: compiling command: change RMAN-03026: error recovery releasing channel resources RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: change RMAN-06091: no channel allocated for maintenance (of an appropriatetype)
What's wrong here? I've allocated a channel and RMAN acknowledges that it's for delete. But can't do it.
Help!!
Thanks,
Leng.
http://briefcase.yahoo.com.au - Yahoo! Briefcase - Manage your files online.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= INET: lkaing_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Oct 24 2001 - 09:05:03 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez INET: com.banilejas_at_codetel.net.do Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |