备份控制文件

oracleoneone

为什么在数据库的物理结构发生变化(如：将一个表空间置为只读状态)前后,都要对控制文件进行备份，若不备份会怎么样？

miloluo

A control file contains information about the associated database that is required for access by an instance,both at startup and during noraml operatioin.Control file information can be modified only by Oracle; no database administrator or user can edit a control file.

Among other things a control file contains information such as:
The database name;
The timestamp of database creation;
The names and locations of associated datafiles and redo log files;
Tablespace information;
Datafile offline ranges;
The log history;
Archived log information;
Backup set and backup piece information;
Backup datafile and redo log information;
Datafile copy information;
The current log sequence number;
Checkpoint  information;

renxiao2003

不备份随便改控制文件容易造成数据库无法启动。

ning_lianjie

如果你对操作有“十分”的把握，就可以不备份。。。

yoyosys

不备份 也没有关系，可以通过表等手工创建出来，不过对操作员的专业要求较高

luckrui001

不备份，对自己有很大挑战，呵呵