pdb move OMF datafile online strange behaviour

From: <grzegorzof_at_interia.pl>
Date: Fri, 05 Jul 2019 13:05:40 +0200
Message-Id: <zabmqdxgnmqnndatbncm_at_kgoa>

Hi,&nbsp;recently I was surprised by strange online move of data file behaviour, it is on 12.1.0.2:SQL&gt; _at_ls appdataTABLESPACE_NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILE_ID FILE_NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EXT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MB&nbsp; &nbsp; &nbsp; MAXSZ------------------------------ ---------- -------------------------------------------------------------------------------- --- ---------- ----------APPDATA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14 /oracle/oradata/PDDB/52F0946836BC6D67E055025056965D6F/datafile/o1_mf_appdata_ YES&nbsp; &nbsp;32767.98&nbsp; &nbsp;32767.98&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; do4kbcns_.dbf										&nbsp;&nbsp;SQL&gt; alter system set db_create_file_dest='/oracle/oradata/PDDB' ;System altered.SQL&gt; alter tablespace APPDATA add datafile size 100m ;Tablespace altered.SQL&gt; _at_ls appTABLESPACE_NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILE_ID FILE_NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EXT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MB&nbsp; &nbsp; &nbsp; MAXSZ------------------------------ ---------- -------------------------------------------------------------------------------- --- ---------- ----------APPDATA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14 /oracle/oradata/PDDB/52F0946836BC6D67E055025056965D6F/datafile/o1_mf_appdata_ YES&nbsp; &nbsp;32767.98&nbsp; &nbsp;32767.98&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; do4kbcns_.dbfAPPDATA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21 /oracle/oradata/PDDB/PDDB/52F0946836BC6D67E055025056965D6F/datafile/o1_mf_ NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; appdata_gkxxsyj5_.dbf						&nbsp;&nbsp;SQL&gt; alter system set db_create_file_dest='/oracle/oradata' ;System altered.SQL&gt; alter database move datafile 21 ;Database altered.SQL&gt; @ls appTABLESPACE_NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILE_ID FILE_NAME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EXT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MB&nbsp; &nbsp; &nbsp; MAXSZ------------------------------ ---------- -------------------------------------------------------------------------------- --- ---------- ----------APPDATA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14 /oracle/oradata/PDDB/52F0946836BC6D67E055025056965D6F/datafile/o1_mf_appdata_ YES&nbsp; &nbsp;32767.98&nbsp; &nbsp;32767.98&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; do4kbcns_.dbfAPPDATA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21 /u01/app/oracle/product/12.1.0/db_1/dbs/PDDB/datafile/o1_mf_appdata_gkxxxfvk_ NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .dbfSo it looks like file goes to $ORACLE_HOME/dbs instead of /oracle/oradata/.... and so on.Any ideas ?Regards.Grzegorz

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 05 2019 - 13:05:40 CEST

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Out of morbid curiosity - can you straddle datafiles using Filesystem + ASM DGs"
Previous message: Dominic Brooks: "Re: Manually Creation of an Interval partition"
In reply to: Mark W. Farnham: "RE: Manually Creation of an Interval partition"
Next in thread: GG: "Re: pdb move OMF datafile online strange behaviour"
Reply: GG: "Re: pdb move OMF datafile online strange behaviour"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message