9/9/22, 3:32 PM SR Detail

SR 3-30572242871 : Datafile relocate and rename

Severity 1-Critical Status Customer Working

Escalation Status Never Escalated Opened Sep 8, 2022 10:52 AM (Thursday)
Last Updated Sep 9, 2022 2:38 AM (12+ hours ago)
Bug Reference No Related Bugs Attachments No Related Attachments
Related Articles No Related Articles Related SRs No Related SRs
Support Identifier 18440603
Account Name Ora-Tech Systems (Pvt) Ltd
Primary Contact Mukarram Khan Alternate Contact
System Host No Related Hosts
Product Oracle Database - Enterprise Edition
Product Version 19.14.0.0.0
Operating System Linux x86-64 OS Version Red Hat Enterprise 7
Hi,

Someone accidently created datafile in oracle dbs folder $ORACLE_HOME/dbs with name
C:APPSLAKICTORADATAKICTNEDRKICT_NEDR.DBF.
Problem Description
Can we rename and relocate file online to new location in production database,

we are using 19c database and linux 7.9

Regards,

History
Notes Oracle Support- Sep 8, 2022 1:42 PM (Thursday)
I shared you for the steps.

Please check my last test case i have done on 19c

Thanks & Best Regards,

HariHaran
Oracle Global Customer Support for Database, NET & NoSQL
Shift Timings ( 07:30 AM to 02:30 PM IST / 10:00 PM to 04:30 AM EST / 07:00 PM to 01:30 AM PST )
Please do not hesitate to contact us through hot line - http://www.oracle.com/support/contact.html
Update from Customer MUHAMMAD.TAHIR@ORA-TECH.COM- Sep 8, 2022 12:53 PM (Thursday)
Hi,

But we are on 19c and you have mistakenly shared Refer: 12C New Feature : Move a Datafile Online ( Doc ID 1566797.1 )

Regards,
ODM Action Plan Oracle Support- Sep 8, 2022 12:48 PM (Thursday)
yes its online.

Refer: 12C New Feature : Move a Datafile Online (Doc ID 1566797.1)

Please check first in non-prod proceed with PROD for the steps

Thanks & Best Regards,

HariHaran
Oracle Global Customer Support for Database, NET & NoSQL
Shift Timings ( 07:30 AM to 02:30 PM IST / 10:00 PM to 04:30 AM EST / 07:00 PM to 01:30 AM PST )
Please do not hesitate to contact us through hot line - http://www.oracle.com/support/contact.html
Update from Customer MUHAMMAD.TAHIR@ORA-TECH.COM- Sep 8, 2022 11:23 AM (Thursday)
Hi,

This is running on Linux environment "Red Hat Enterprise Linux Server release 7.9 (Maipo)"
Database version 19c --- 19.14

This steps work in online, no database downtime?

Regards,
ODM Answer Oracle Support- Sep 8, 2022 11:10 AM (Thursday)
-- Kindly confirm and check if this is on Linux or Windows platform.

https://support.oracle.com/epmos/faces/SrDetailPrint?sysmsg=true&_afrLoop=1037794859675717&srNumber=3-30572242871&print=true&sortBy=N… 1/4
9/9/22, 3:32 PM SR Detail
-- We can use Online move option ( Test the steps in Pre-prod and proceed in PROD )

TEST CASE:
++++++++++

SQL> create tablespace test datafile '/refresh/home/app/19.8.0.0/oracle/oradata/ORCL19800CDB/test01.dbf' size 100m autoextend on next 10m
maxsize 200m;

Tablespace created.

SQL> select file_name from dba_data_files;

FILE_NAME
-------------------------------------------------------------------------
/refresh/home/app/19.8.0.0/oracle/oradata/ORCL19800CDB/test01.dbf

SQL> !ls -ltr /refresh/home/app/19.8.0.0/oracle/oradata/ORCL19800CDB/

-rw-r-----. 1 oracle oinstall 104865792 Sep 8 06:07 test01.dbf

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL> ALTER DATABASE MOVE DATAFILE '/refresh/home/app/19.8.0.0/oracle/oradata/ORCL19800CDB/test01.dbf' TO

'/refresh/home/app/19.8.0.0/oracle/oradata/test01_new.dbf';

Database altered.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/refresh/home/app/19.8.0.0/oracle/oradata/test01_new.dbf

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

SQL> !ls -ltr /refresh/home/app/19.8.0.0/oracle/oradata

total 102416
-rw-r-----. 1 oracle oinstall 104865792 Sep 8 06:08 test01_new.dbf
drwxr-x---. 5 oracle oinstall 4096 Sep 8 06:08 ORCL19800CDB

Thanks & Best Regards,

HariHaran
Oracle Global Customer Support for Database, NET & NoSQL
Shift Timings ( 07:30 AM to 02:30 PM IST / 10:00 PM to 04:30 AM EST / 07:00 PM to 01:30 AM PST )
Please do not hesitate to contact us through hot line - http://www.oracle.com/support/contact.html
Notes Oracle Support- Sep 8, 2022 11:02 AM (Thursday)

**************** General Advice ****************

**** You could simplify and streamline your data collection by downloading the
**** latest TFA Support Tools Bundle (See Doc:1594347.1) and using the command:
**** $TFA_HOME/bin/tfactl diagcollect -srdc DBTABLESPACEGENERIC
************************************************
ODM Question Oracle Support- Sep 8, 2022 11:02 AM (Thursday)
Hi,

Someone accidently created datafile in oracle dbs folder $ORACLE_HOME/dbs with name C:APPSLAKICTORADATAKICTNEDRKICT_NEDR.DBF.

Can we rename and relocate file online to new location in production database,

https://support.oracle.com/epmos/faces/SrDetailPrint?sysmsg=true&_afrLoop=1037794859675717&srNumber=3-30572242871&print=true&sortBy=N… 2/4
9/9/22, 3:32 PM SR Detail

we are using 19c database and linux 7.9

Regards,
Notes Oracle Support- Sep 8, 2022 11:02 AM (Thursday)
Based on the options chosen during creation, the Service Request has been submitted as a Table and Tablespace Fragmentation Issues. Diagnostic
data is needed for troubleshooting the issue.

Execute the action plan described in [DOC ID 2560287.1] "SRDC - Table and Tablespace Fragmentation and Related Issues : Checklist of Evidence to
Supply" and upload the information collected to ensure rapid resolution.

(If this information has already been provided please ignore this action request.)

This SR will go through some automatic checks to:

- verify that the required data has been attached to the SR
Information Oracle Support- Sep 8, 2022 11:00 AM (Thursday)
My Oracle Support has performed a Knowledge search using your Service Request details (Summary, Error codes, Product) and located the following
documents which may be related to your issue.

Search Results
============================================================================================
99% - Doc ID 191540.1 How to Relocate and Rename SYSTEM datafiles
99% - Doc ID 191541.1 How to Relocate and Rename NON-SYSTEM Datafiles
99% - Doc ID 115424.1 How to Rename or Move Datafiles and Logfiles
99% - Doc ID 2258871.1 Rename database and then move datafile online in 12.2
99% - Doc ID 430181.1 How to Rename an OMF Datafile

Notes Oracle Support- Sep 8, 2022 11:00 AM (Thursday)

Your Service Request (SR) is being analyzed. We will update the SR shortly.
Learn more about Oracle automation at Doc ID 166650.1.
Update from Customer MUHAMMAD.TAHIR@ORA-TECH.COM- Sep 8, 2022 10:52 AM (Thursday)
Hi,

Someone accidently created datafile in oracle dbs folder $ORACLE_HOME/dbs with name C:APPSLAKICTORADATAKICTNEDRKICT_NEDR.DBF.

Can we rename and relocate file online to new location in production database,

we are using 19c database and linux 7.9

Regards,
Customer Problem Description MUHAMMAD.TAHIR@ORA-TECH.COM- Sep 8, 2022 10:52 AM (Thursday)
Customer Problem Description
---------------------------------------------------

Problem Summary
---------------------------------------------------
Datafile relocate and rename

Problem Description
---------------------------------------------------
Hi,

Someone accidently created datafile in oracle dbs folder $ORACLE_HOME/dbs with name C:APPSLAKICTORADATAKICTNEDRKICT_NEDR.DBF.

Can we rename and relocate file online to new location in production database,

we are using 19c database and linux 7.9

Regards,

Error Codes
---------------------------------------------------

Problem Category/Subcategory
---------------------------------------------------
d) Storage (Compression, Corruption, Partitioning, LOBS, Tablespace, Files)/Database Storage: Segment and Tablespace Space Management

Uploaded Files
---------------------------------------------------

https://support.oracle.com/epmos/faces/SrDetailPrint?sysmsg=true&_afrLoop=1037794859675717&srNumber=3-30572242871&print=true&sortBy=N… 3/4
9/9/22, 3:32 PM SR Detail
Global Problem Definition Details
---------------------------------------------------
Question: What type of system is impacted?
Answer: Production system

Question: What is the current system status?

Answer: Working with no limitation, but need RCA

Question: Describe whether workarounds are available:

Answer: No workaround available

Question: Do you want the solution for a specific issue or ask a query?
Answer: Reporting an incident or a problem. I want Oracle Support to review the data and provide solution accordingly

Question: Select the relevant symptoms or the situation related to your issue
Answer: Permanent tablespace and related issues

Question: Select the relevant symptoms or the situation related to your issue
Answer: Inconsistent data in the space dictioanry views. Ex: dba_tablespace_usage_metrics,DBA_SEGMENTS and dba_free_space. etc..

Question: Select the relevant symptoms or the situation related to your issue
Answer: Inconsistent or wrong data in dba_tablespace_usage_metrics

Diagnosis: If the above solution does not resolve your issue, follow the steps detailed in the document below:

Read Note:2560291.1 SRDC - Generic Tablespace and Segment Management : Checklist of Evidence to Supply

We recommend saving this session as a draft Service Request (SR). Once data gathering is complete, proceed with the next step to upload requested
data and submit SR.

https://support.oracle.com/epmos/faces/SrDetailPrint?sysmsg=true&_afrLoop=1037794859675717&srNumber=3-30572242871&print=true&sortBy=N… 4/4