Oracle：控制文件的备份与v$database

直接看代码：

SQL> select controlfile_type "Ctrl file type",controlfile_created "Ctrl file created",controlfile_time "Last Ctrl file time",controlfile_change# "Last Ctrl file SCN",controlfile_sequence# "Ctrl file Sequence"
  2  from v$database;

Ctrl fi Ctrl file created   Last Ctrl file time Last Ctrl file SCN Ctrl file Sequence
------- ------------------- ------------------- ------------------ ------------------
CURRENT 2016-01-07 03:15:28 2016-01-09 06:17:52             619705                359

SQL> 
SQL> !date                       
Sat Jan  9 06:28:48 CST 2016

SQL> alter database backup controlfile to '/home/oracle/controlfile.20160109.backup';

Database altered.

SQL> select controlfile_type "Ctrl file type",controlfile_created "Ctrl file created",controlfile_time "Last Ctrl file time",controlfile_change# "Last Ctrl file SCN",controlfile_sequence# "Ctrl file Sequence"
  2  from v$database;

Ctrl fi Ctrl file created   Last Ctrl file time Last Ctrl file SCN Ctrl file Sequence
------- ------------------- ------------------- ------------------ ------------------
CURRENT 2016-01-07 03:15:28 2016-01-09 06:29:21             620092                360

SQL>

SQL> select controlfile_type "Ctrl file type",controlfile_created "Ctrl file created",controlfile_time "Last Ctrl file time",controlfile_change# "Last Ctrl file SCN",controlfile_sequence# "Ctrl file Sequence"

2 from v$database;