-
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
-
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."
-
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
-
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."
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|