In this Topics i will post how to move control file to another detestation , i will post other ORACLE FILES :
To move or rename a controlfile do the following.
SQL> select name from v$controlfile;
NAME ------------------------------------------------------------- C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL01.CTL C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL02.CTL C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL03.CTL 3 rows selected. SQL>
OR
SQL> show parameter control_files
NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ control_files string C:\ORACLE\ORADATA\DB10G\CONTRO L01.CTL, C:\ORACLE\ORADATA\ORCL \CONTROL02.CTL, C:\ORACLE\OR ADATA\ORCL\CONTROL03.CTL SQL>
To move or rename a controlfile do the following.
- Alter the
control_files
parameter using theALTER SYSTEM
comamnd. - Shutdown the database.
- Rename the physical file on the OS.
- Start the database.
SQL> ALTER SYSTEM SET control_files='C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\RENAME_CONTROL01.CTL', - > 'C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL02.CTL', - > 'C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL03.CTL' SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down.
RE-NAME CONTROL FILE TO THE SAME WE DID ON ALTER STATMENT .
SQL> STARTUP ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 787968 bytes Variable Size 61864448 bytes Database Buffers 104857600 bytes Redo Buffers 262144 bytes Database mounted. SQL>
SQL> select name from v$controlfile; NAME ------------------------------------------------------------- C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\RENAME_CONTROL01.CTL C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL02.CTL C:\ORACLE\PRODUCT\11.2.0\ORADATA\ORCL\CONTROL03.CTL 3 rows selected. SQL>
the same steps for move control file .
W
We will continue
Enjoy osama mustafa
No comments:
Post a Comment