oracle 控制文件

1、查看控制文件

SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u01/app/oracle/oradata/orcl/c
                                                 ontrol01.ctl, /u01/app/oracle/
                                                 flash_recovery_area/orcl/contr
                                                 ol02.ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING

2、添加控制文件（方式一，使用pfile）

A。关闭数据库

SQL> shutdown immediate
B.将新的控制文件加到pfile
[root@localhost dbs]# vim initorcl.ora 
orcl.__shared_pool_size=301989888
orcl.__streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/flash_recovery_area/orcl/control02.c
tl'
*.db_block_size=8192
*.db_domain='oracle.com'
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=5218762752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=1000
c.使用cp命令将控制文件复制到指定位置
d.startup数据库
e.查到v$controlfile

 

3、移动控制文件

 

4、备份控制文件