Rman Report Schema Reports Old Path When Connect to Recovery Catalog After Alter database Move Command was issued
(Doc ID 2799715.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Alter database move datafile '<Existing path>' to '<new path>' was issued.
Recovery catalog is been used. When Connecting to target and catalog Report schema still shows the Old patch
Datafile Involved is from read only tablespace
Changes
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
In this example we are assuming there are Primary database two node and Standby database one node
Dbname :- ORCL
Original datafile path :- /u01/app/12.2.0.1/oracle/oradata/orcl
Destination datafile path : /tmp
Tablespace name is USERS
Datafile names :- system.dbf,sysaux.dbf,undotbs.dbf,users.dbf
Step 1 :- Before move of datafile
rman target <>/<> catalog <>/<>@<Connect string of catalog>
List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 870 SYSTEM YES /u01/app/12.2.0.1/oracle/oradata/orcl/system.dbf
3 1610 SYSAUX NO /u01/app/12.2.0.1/oracle/oradata/orcl/sysaux.dbf
4 275 UNDOTBS1 YES /u01/app/12.2.0.1/oracle/oradata/orcl/undotbs.dbf
7 13 USERS NO /u01/app/12.2.0.1/oracle/oradata/orcl/users.dbf ============================> Moving this datafile to new path /tmp
Step 2 :- Move the datafile using Alter database move datafile
SQL> Alter database move datafile '/refresh/home/app/12.2.0.1/oracle/oradata/orcl12201/users.dbf' to '/tmp/users.dbf' ;
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/12.2.0.1/oracle/oradata/orcl/system.dbf
/u01/app/12.2.0.1/oracle/oradata/orcl/sysaux.dbf
/u01/app/12.2.0.1/oracle/oradata/orcl/undotbs.dbf
/tmp/users.dbf =====================================================================> Move Successful
Step 3 :- After move Connect to target and recovery catalog
rman target <>/<> catalog <>/<>@<Connect string of catalog>
Rman> reysnc catalog ;
Rman> report schema ;
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 870 SYSTEM YES /u01/app/12.2.0.1/oracle/oradata/orcl/system.dbf
3 1610 SYSAUX NO /u01/app/12.2.0.1/oracle/oradata/orcl/sysaux.dbf
4 275 UNDOTBS1 YES /u01/app/12.2.0.1/oracle/oradata/orcl/undotbs.dbf
7 13 USERS NO /u01/app/12.2.0.1/oracle/oradata/orcl/users.dbf ==============> Still pointing to Old path
When you connect just to target (Without Any Catalog) It reports the correct path
Rman target /
Rman> Report schema ;
List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 870 SYSTEM YES /u01/app/12.2.0.1/oracle/oradata/orcl/system.dbf
3 1610 SYSAUX NO /u01/app/12.2.0.1/oracle/oradata/orcl/sysaux.dbf
4 275 UNDOTBS1 YES /u01/app/12.2.0.1/oracle/oradata/orcl/undotbs.dbf
7 13 USERS NO /tmp/users.dbf ------------------------------------------------------->Shows Correct path when just connected to target
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |