Renaming SYSTEM datafiles of Oracle Database

SQL> alter tablespace system offline;
alter tablespace system offline
ERROR at line 1:
ORA-01541: system tablespace cannot be brought offline; shut down if necessary
Renaming datafiles of SYSTEM tablespace:-
1. Shut down the database
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
2. Start the database in mount mode :
SQL> startup mount
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 226495364 bytes
Database Buffers 377487360 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> exit
bash-3.2$ cp /u01/app/oracle/product/11.2.0/db_1/dbs/system2 /data/ANARDB/data/OC055.dbf
3. Rename the system datafile of database:-
SQL> alter database rename file '/u01/app/oracle/product/11.2.0/db_1/dbs/system2' to '/data/ANARDB/data/OC055.dbf' ;
Database altered.
4. Open the database :
SQL> alter database open;
Database altered.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: