Rename System tablespace file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Rename System tablespace file

  1. #1
    Join Date
    Mar 2003
    Location
    Gujarat
    Posts
    19

    Rename System tablespace file

    Dear all,

    I hv created new DB SID : maxlive
    and also create tablespace system ---> file "/oracle/maxprd1/system01.dbf"
    Now I will try to change path from

    file "/oracle/maxprd1/system01.dbf" to

    file "/oracle/maxprd1/maxlive/system01.dbf"

    after database creation
    How to change system file path ?
    Please Advice
    Regs
    ramji

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    1. SQL> Shutdown immediate
    2. $ cp /oracle/maxprd1/system01.dbf to /oracle/maxprd1/maxlive/system01.dbf
    3. SQL> startup mount
    4. SQL> alter database rename file '/oracle/maxprd1/system01.dbf' to '/oracle/maxprd1/maxlive/system01.dbf';
    5. SQL> alter database open.
    6. $ rm /oracle/maxprd1/system01.dbf

    and do RTFM and STFW before asking.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Mar 2003
    Location
    Gujarat
    Posts
    19

    Re: Rename System tablespace file

    Originally posted by ramji
    Dear all,

    I hv created new DB SID : maxlive
    and also create tablespace system ---> file "/oracle/maxprd1/system01.dbf"
    Now I will try to change path from

    file "/oracle/maxprd1/system01.dbf" to

    file "/oracle/maxprd1/maxlive/system01.dbf"

    after database creation
    How to change system file path ?
    Please Advice
    Regs
    ramji
    i have done as per yr advice but at the time of db open
    following error

    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: '/oracle/maxprd1/maxlive/system01.dbf'
    Please advice

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    did you do it properly ??

    Code:
    SQL*Plus: Release 9.2.0.3.0 - Production on Sat May 10 12:43:29 2003
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    Enter user-name: sys as sysdba
    Enter password:
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
    With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - Production
    
    sys@ACME.WORLD> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    sys@ACME.WORLD> startup mount
    ORACLE instance started.
    
    Total System Global Area  101784796 bytes
    Fixed Size                   453852 bytes
    Variable Size              75497472 bytes
    Database Buffers           25165824 bytes
    Redo Buffers                 667648 bytes
    Database mounted.
    sys@ACME.WORLD> select name from v$datafile
      2  ;
    
    NAME
    ----------------------------------------------------------------------------------------------------
    E:\ORACLE\ORADATA\ACME\SYSTEM01.DBF
    E:\ORACLE\ORADATA\ACME\UNDOTBS01.DBF
    E:\ORACLE\ORADATA\ACME\EXAMPLE01.DBF
    E:\ORACLE\ORADATA\ACME\INDX01.DBF
    E:\ORACLE\ORADATA\ACME\TOOLS01.DBF
    E:\ORACLE\ORADATA\ACME\USERS01.DBF
    E:\TEST01.DBF
    E:\ORACLE\ORADATA\ACME\MNT_S.DBF
    
    8 rows selected.
    
    sys@ACME.WORLD> alter database rename file 'E:\ORACLE\ORADATA\ACME\SYSTEM01.DBF' to 'E:\ORACLE\ORADATA\SYSTEM01.DBF';
    
    Database altered.
    
    sys@ACME.WORLD> alter database open;
    
    Database altered.
    
    sys@ACME.WORLD>
    sys@ACME.WORLD> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    sys@ACME.WORLD> startup mount
    ORACLE instance started.
    
    Total System Global Area  101784796 bytes
    Fixed Size                   453852 bytes
    Variable Size              75497472 bytes
    Database Buffers           25165824 bytes
    Redo Buffers                 667648 bytes
    Database mounted.
    sys@ACME.WORLD> alter database rename file'E:\ORACLE\ORADATA\SYSTEM01.DBF'  to 'E:\ORACLE\ORADATA\ACME\SYSTEM01.DBF';
    
    Database altered.
    
    sys@ACME.WORLD> alter database open;
    
    Database altered.
    
    sys@ACME.WORLD>
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Mar 2003
    Location
    Gujarat
    Posts
    19

    Re: Re: Rename System tablespace file

    Originally posted by ramji
    i have done as per yr advice but at the time of db open
    following error

    alter database open
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: '/oracle/maxprd1/maxlive/system01.dbf'
    Please advice
    Problem resolved.
    thanks
    regards
    ramji

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width