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.
  1. 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
  1. 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.
  1. 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: