Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Backup and recovery Technology of Oracle 12c Database (1)

2025-02-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

The method of querying SCN

SQL > select current_scn from v$database

2 union

3 select current_scn from v$database

CURRENT_SCN31267053126706 SQL > select current_scn from v$database

2 union all

3 select dbms_flashback.get_system_change_number from dual

CURRENT_SCN31269783126978

Enable Archive Log

If you want to enable archive mode, use the alter database archivelog command here.

If you want to turn off archive mode, use the alter database noarchivelog command here.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report