RE: Giving RMAN amnesia

From: Siva Valiveru <SValiveru_at_looksmart.net>
Date: Wed, 11 Oct 2006 17:07:01 -0700
Message-ID: <8F8AA525BF5CCB40BF4FA4A6156D6F270BB6BABE@sfex3k2.looksmart_sf.ad.looksmart.com>

$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 Received on Wed Oct 11 2006 - 19:07:01 CDT