SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/ALMD1213/CONTROL01.CTL,
/u01/ALMD1213/CONTROL02.CTL,
/u01/ALMD1213/CONTROL03.CTL
SQL> alter system set control_files='/u01/ALMD1213/CONTROL01.CTL',
'/u01/ALMD1213/CONTROL02.CTL',
'/u01/ALMD1213/CONTROL03.CTL',
'/u01/ALMD1213/CONTROL04.CTL' scope=spfile;
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ! cp /u01/ALMD1213/CONTROL03.CTL /u01/ALMD1213/CONTROL04.CTL
SQL> startup
ORACLE instance started.
Total System Global Area 448790528 bytes
Fixed Size 1291096 bytes
Variable Size 201329832 bytes
Database Buffers 239075328 bytes
Redo Buffers 7094272 bytes
Database mounted.
Database opened.
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/ALMD1213/CONTROL01.CTL,
/u01/ALMD1213/CONTROL02.CTL,
/u01/ALMD1213/CONTROL03.CTL,
/u01/ALMD1213/CONTROL04.CTL
...........!!!!
No comments:
Post a Comment