Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Giving RMAN amnesia

Re: Giving RMAN amnesia

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 12 Oct 2006 09:34:31 +0200
Message-ID: <486b2b610610120034g2bdb0926s9a4d4745a25a5e3b@mail.gmail.com>


delete backup;

Stefan

On 10/12/06, Siva Valiveru <SValiveru_at_looksmart.net> wrote:
>
> $rman target /
>
> # these commands should take care of all backups entires in the cf not
> sure if there is one single command to clean up all entries
> list backup;
> DELETE FORCE NOPROMPT BACKUP OF DATABASE COMPLETED BEFORE 'SYSDATE';
> delete force noprompt obsolete;
> DELETE FORCE NOPROMPT BACKUP OF ARCHIVELOG ALL COMPLETED BEFORE
> 'SYSDATE';
>
> ( more examples on delete to delete specific backupset
> delete FORCE noprompt backup tag standby_db_backup;
> delete FORCE noprompt backup tag TAG20060924T161151;
> delete force noprompt obsolete;
> DELETE force noprompt BACKUPSET 1054,1064;
> )
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bob
> Sent: Wednesday, October 11, 2006 4:12 PM
> To: oracle-l
> Subject: Giving RMAN amnesia
>
> 10.1.0.4 on RH Linux using a control file instead of catalog.
> How can I reset the control file so rman looses all its configuration
> and I can start with a clean plate. I can manually hack away file
> references and settings but, is there a way (command) to re set the
> control file. I know I can rebuild the cf by hand but was looking for a
> more elegant method. Ive looked in the reset database command through
> rman but that doesnt do what I want.
>
>
> Ideas?
> Thanks
> Bob
>
> --
> "Oracle error messages being what they are, do not highlight the correct
> cause of fault, but will identify some other error located close to
> where the real fault lies."
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 12 2006 - 02:34:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US