ORACLE --- add control file

ORACLE --- adding control files will be unfamiliar without any technical skills. ORACLE control files are crucial. Next I will write an article on how to add control files to ORACLE. First, view the information of the current control file:

1SQL> show parameter control23NAME TYPE VALUE4 certificate ----------- commandid integer 76control_files string/u01/oradata/sansom/control01.7 ctl,/u01/oradata/sansom/contr8 ol02.ctl, /u01/oradata/sansom/9 control03.ctl there are currently three control files. Next we will use the method of creating PFILE to directly modify the content of the PFILE file to add the control file, and put it in different paths 1 [oracle @ gard3 dbs] $ pwd2/u01/oracle/dbs3 [oracle @ g Ard3 dbs] $ ll4-rw-r ----- 1 oracle oinstall 1536 Nov 4 orapwsansom5-rw-r ----- 1 oracle oinstall 2560 Nov 22 spfilesansom. ora currently does not have a PFILE File in/u01/oracle/dbs. Let's create it 01SQL> create pfile from spfile; 0203 File created1_405sql>! 06 [oracle @ gard3 dbs] $ ll07total 760809-rw-r -- r -- 1 oracle oinstall 974 Nov 22 initsansom. ora10-rw-r ----- 1 oracle oinstall 1536 Nov 4 orapwsansom11-rw-r ----- 1 oracle oinstall 2560 Nov 22 spfilesansom. ora opens initsansom. add '/u01/oradata/backup/control04.ctl' to the ora file and save 01sansom. _ db_cache_size = 17616076802sansom. _ java_pool_size = 41910000403sansom. _ large_pool_size = 419213404sansom. _ shared_pool_size = 9227468805sansom. _ streams_pool_size = 419430406 *. audit_file_dest = '/u01/admin/sansom/adump' 07 *. background_dump_dest = '/u01/admin/sansom/bdump' 08 *. compatible = '10. 2.0.1.0 '09 *. control_files = '/u01/oradata/sansom/control01.ctl', '/u01/oradata/sansom/control02.ctl', '/u01/oradata/sansom/control03.ctl ', '/u01/oradata/backup/control04.ctl' 10 *. core_dump_dest = '/u01/admin/sansom/cdump '11 *. db_block_size = 8192 copy any control file to the backup directory and close the database: 1 [oracle @ gard3 dbs] $ cp/u01/oradata/sansom/control01.ctl/u01/oradata/backup/control04.ctl2 [oracle @ gard3 dbs] $ response> shutdown immediate6Database closed.7Database restart instance shut down. use pfile to restart the database: 01SQL> startup pfile = '/u01/oracle/dbs/initsansom. ora '02oracle instance partition System Global Area 285212672 bytes Size 1218992 bytes Size 104859216 bytes07Database Buffers 176160768 bytes Buffers 2973696 bytes09Database mounted.10Database tables> show parameter control1213NAME TYPE VALUE14 bytes ----------- commandid integer 716control_files string/u01/ oradata/sansom/control01.17 ctl, /u01/oradata/sansom/contr18 ol02.ctl,/u01/oradata/sansom/19 control03.ctl,/u01/oradata/ba20 ckup/control04.ctl21SQL>

 

Added successfully. You can delete the old spfile and use the current pfile to create the spfile. The control file has been added!