Oracle 19C 闪回6 ORCL2-ORACLE OCP认证考试.docxVIP

19c闪回6orcl2

Lorcl2上开启归档

2、设置闪回区大小、指定路径

altersystemsetdb_recovery_file_dest_size=14g;

altersystemsetdb_recovery_fiIe_dest=7u01/app/oracle/fast_recovery_area;

3、切换日志

altersystemswitchlogfile;

SQLaltersystemswitchlogfile;Systemaltered.

4、开启闪回

alterdatabaseflashbackon;

SQL|alterdatabaseflashbackon;

SQL|

Databasealtered.

5、开启hr用户并修改密码

alteruserhridentifiedbyoracle_4uaccountunlock;

SQLalteruserhridentifiedbyoracle_4uaccountunlock;

Useraltered.

6、以hr用户链接，建立表tl并向tl表内插入数据createtabletl(anumber);

insertintotlvalues(1);

commit;

SQLconnhr/oracle_4uCo