ORACLE 12C Database New Features

Online Data-file Move

Online Datafile Move is the very helpful technique implemented by oracle corporation in its 12C release.You need not to be worry about taking the tablespace offline to move the datfile...

wowla!!!  Lets see how this magic work...


SELECT file_id, file_name FROM dba_data_files ORDER BY file_id;
FILE_ID FILE_NAME
---------- ----------------------------------------------------------------------
1 /u01/app/oracle/oradata/cdb1/system01.dbf
3 /u01/app/oracle/oradata/cdb1/sysaux01.dbf
4 /u01/app/oracle/oradata/cdb1/undotbs01.dbf
6 /u01/app/oracle/oradata/cdb1/users01.dbf
SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' TO '/tmp/system01.dbf';
Database altered.
SQL>
　
SQL> SELECT file_id, file_name FROM dba_data_files WHERE file_id = 1;
FILE_ID FILE_NAME
---------- ----------------------------------------------------------------------
1 /tmp/system01.dbf
SQL>
　
SQL> HOST ls -al /u01/app/oracle/oradata/cdb1/system01.dbf
ls: cannot access /u01/app/oracle/oradata/cdb1/system01.dbf: No such file or directory
SQL> HOST ls -al /tmp/system01.dbf
-rw-r-----. 1 oracle oinstall 838868992 Oct 8 22:48 /tmp/system01.dbf

Comments

  1. काठ का उल्लू13 November 2013 at 10:34

    its sounds good... :)

    ReplyDelete
  2. Samir Behera13 January 2025 at 23:24

    I had a requirement of renaming few datafiles and also move their location. This note helped me.

    ReplyDelete
  3. Rohit Dubey19 February 2025 at 12:19

    Thank you for taking the time to research and write this article. It's much appreciated.

    ReplyDelete

Post a Comment

Popular posts from this blog

Image
 USER TYPES in SNOWFLAKE   "Securing is better than sorry"  It's always wiser to take precautions and secure something properly, even if it seems unnecessary, rather than risk potential problems or regret later by not being careful enough;  Snowflake have TYPE property for the USER object. This is one of the long-awaited no-brainer features we all wanted! Make sure to secure your data by securing your user first. Key things to remember  Never rely on one factor authentication(Always enroll at least in 2nd factor authentication) Old-fashioned password logins are vulnerable in today's digital world, so configure strong authentication, such as OAuth, Key pair, and federated authentications. In snowflake there are 4 properties of the user that can be set PERSON | SERVICE | LEGACY_SERVICE | NULL PERSON: Users do not have restrictions when the TYPE property is set to PERSON, NULL, or when TYPE is unset. NULL: See PERSON. SERVICE: To improve the security posture of ...
Read more

DATA MOVEMENT: CHALLENGE OR STRENGTH ?

  Organizations in highly regulated industries go through many business events that trigger the need for a data migration. The typical “lift and shift” approach to data migration, however, results in a considerable amount of time and resource allocation—without any concrete business value to show for it. Adlib goes beyond just automating the process of moving your data between repositories. We add value to your content before, during, and after migration, for enriched content that’s easier to find and easier to use. Oracle Data Pump  is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables. In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. You would login to SQL*Plus as system and enter the following ...
Read more

Oracle RAC Split Brain/ Node Eviction

Many people asks this question why and how nodes are evicted from cluster... Here is the simple answer.. It occurs when the instance members in a RAC fail to ping/connect to each other via this private interconnect, but the servers are all pysically up and running and the database instance on each of these servers is also running. These individual nodes are running fine and can conceptually accept user connections and work independently. So basically due to lack of commincation the instance thinks that the other instance that it is not able to connect is down and it needs to do something about the situation. The problem is if we leave these instance running, the sane block might get read, updated in these individual instances and there would be data integrity issue, as the blocks changed in one instance, will not be locked and could be over-written by another instance. Oracle has efficiently implemented check for the split brain syndrome. In RAC if any node becomes inactive, or if ot...
Read more