SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH3Z_.CTL,E:\ORCL\CONTROLFILE\O1_MF_JRR7NH4B_.CTL
control_management_pack_access string NONE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH3Z_.CTL,E:\ORCL\CONTROLFILE\O1_MF_JRR7NH4B_.CTL
control_management_pack_access string NONE
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
Move Controlfile from E drive to C Drive Path.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 5100272704 bytes
Fixed Size 9038912 bytes
Variable Size 905969664 bytes
Database Buffers 4177526784 bytes
Redo Buffers 7737344 bytes
ORACLE instance started.
Total System Global Area 5100272704 bytes
Fixed Size 9038912 bytes
Variable Size 905969664 bytes
Database Buffers 4177526784 bytes
Redo Buffers 7737344 bytes
SQL> alter system set control_files='C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH3Z_.CTL', 'C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH4B_.CTL' scope=spfile;
System altered.
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 5100272704 bytes
Fixed Size 9038912 bytes
Variable Size 905969664 bytes
Database Buffers 4177526784 bytes
Redo Buffers 7737344 bytes
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH3Z_.CTL,C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH4B_.CTL
control_management_pack_access string NONE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH3Z_.CTL,C:\APP\ORACLE\ORADATA\ORCL\CONTROLFILE\O1_MF_JRR7NH4B_.CTL
control_management_pack_access string NONE
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
SQL>
No comments:
Post a Comment