This discussion is archived
1 Reply Latest reply: Jul 14, 2013 10:35 PM by Mihael RSS

Moving system tablespace from FRA diskgroup to DATA in RAC

LANCERIQUE Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points