- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Make a RESYNC of RMAN Catalog Database Include Any On-Line Move of a Datafile
After performing an online datafile move from one volume to another, the data file name in the Control File does not match the data file name in the Recovery Catalog. A resync of the Catalog does not change the datafile name on the catalog.
This is the file and the command used for the online datafile move :
alter database move datafile 11 to '/u03/sand1/ap_web_d01.dbf'
I have only been offered "workarounds" to this issue. ALTHOUGH, the documentation states that CHANGES to the Control File will be effected to the RMAN Catalog when a RESYNC CATALOG is issued. An online datafile move (alter database move datafile) is a new feature of Oracle 12c. Seems like a safeguard to be sure and effect the move of a datafile to purpose it to the RMAN catalog. When using an RMAN catalog, a failure occurs because the catalog is looking for the datafile at its old location when in reality it was moved.
PLEASE change the logic of the RESYNC to include changes to the location/name of the data file.