1.查询系统当前SCN两条命令
sql> select current_scn from v$database;
sql> select dbms_flashback.get_system_change_number from dual;
sql> select dbid,checkpoint_change# from v$database;
sql> select name,checkpoint_change# from v$datafile;
sql> select name,checkpoint_change# from v$datafile_header;
实例恢复就是在打开数据库时检查此参数确定是否需要恢复。
sql> select GROUP#,sequence#,STATUS,FIRST_CHANGE#,to_char(FIRST_TIME,‘yyyy/mm/dd:hh24:mi:ss‘) time from V$log;
