1 Reply Latest reply: Jul 15, 2013 12:35 AM by Mihael RSS

    Moving system tablespace from FRA diskgroup to DATA in RAC

    LANCERIQUE

      Hi Gurus,

       

      We are having an 11gR2 environment on RHEL 6.3.

       

      One of the DBA mistakenly while adding space added a system data file in FRA disk group. Now task is to move the system data file from FRA to DATA1 without impact. I tried RMAN method of copying as backup but it failed. Since its System I do not want to do try and error. So if someone could please help me with the steps.

       

      I just need to move +FRA/test/datafile/system.262.820686057 to DATA 1 diskgroup.

       

      SQL>

      SQL> select name from v$datafile;

       

       

      NAME

      --------------------------------------------------------------------------------

      +DATA1/test/datafile/system.256.820685431

      +DATA1/test/datafile/sysaux.257.820685431

      +DATA1/test/datafile/undotbs1.258.820685431

      +DATA1/test/datafile/users.259.820685431

      +DATA1/test/datafile/example.264.820685503

      +DATA1/test/datafile/undotbs2.265.820685579

      +FRA/test/datafile/system.262.820686057