Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file ?
(Choose two.)
A.adding a new user to the database
B.dropping a user from the database
C.dropping a table from the database
D.dropping a data file from a tablespace
E.adding a new tablespace to the database Answer : D , E 难道ABC三个选项的操作就不会在CTR FILES里标记吗?
不是说控制文件记录了数据库中的所有变动吗
(Choose two.)
A.adding a new user to the database
B.dropping a user from the database
C.dropping a table from the database
D.dropping a data file from a tablespace
E.adding a new tablespace to the database Answer : D , E 难道ABC三个选项的操作就不会在CTR FILES里标记吗?
不是说控制文件记录了数据库中的所有变动吗
而data file及tablespace的删除与添加则不一样,control文件要记载每个数据文件及tablespace中的SCN号,多了或者少了,都会出问题。