Rename System tablespace file

[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

[adewri]

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.

[ramji]

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

[adewri]

did you do it properly ??

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>

[ramji]

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