Oracle 12c数据库备份与恢复技术(一)

https://blog.51cto.com/shurk/
https://s1.51cto.com/images/blog/201712/27/8f0dac93feb7eb46fc7ce5854eb89ee8.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=" alt="Oracle 12c数据库备份与恢复技术(一)">

查询SCN的方法
sql> select current_scn from v$database
2 uNIOn
3 select current_scn from v$database;

CURRENT_SCN

3126705
3126706
    SQL> select current_scn from v$database

2 union all
3 select dbms_flashback.get_system_change_number from dual;

CURRENT_SCN

3126978
3126978

启用归档日志


如果要启用归档模式，此处使用alter database arcHivelog 命令。
如果要关闭归档模式，此处使用alter database noarchivelog 命令。
Https://blog.51cto.com/shurk/
https://s1.51cto.com/images/blog/201712/29/00ffd3224b2bcc9adb71a07a88678ce7.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=" alt="Oracle 12c数据库备份与恢复技术(一)">