- Connect to RMAN and perform a drop catalog
- Delete all the RMAN backed up files
- Create the catalog again
EXECUTE dbms_rcvcat.unregisterdatabase(1, 1487421514);The first parameter is '1' and the second parameter is your db id as seen when you connect RMAN to the database as follows:
C:\>rman catalog=rman/rman@dba1 target=sys/password@w2k1 Recovery Manager: Release 184.108.40.206.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: W2K1 (DBID=1487421514) connected to recovery catalog databaseRMAN>After you have unregistered the database, reregister it. Then immediately take a good backup of your database on the new NFS mounts.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.