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

《Oracle 19C 闪回6 ORCL2-ORACLE OCP认证考试.docx》由会员分享，可在线阅读，更多相关《Oracle 19C 闪回6 ORCL2-ORACLE OCP认证考试.docx（4页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、19c 闪回 6 orcl2L orcl2上开启归档2、设置闪回区大小、指定路径alter system set db_recovery_file_dest_size=14g;alter system set db_recovery_fiIe_dest=7u01/app/oracle/fast_recovery_area;3、切换日志alter system switch logfile;SQL alter system switch logfile; System altered.4、开启闪回alter database flashback on;SQL |alter database fl

2、ashback on;Database altered.5、开启hr用户并修改密码alter user hr identified by oracle_4u account unlock;SQL alter user hr identified by oracle_4u account unlock;User altered.6、以hr用户链接，建立表tl并向tl表内插入数据 create table tl ( a number);insert into tl values (1);commit;SQL conn hr/oracle_4u Connected.SQL create table

3、tl ( a number ); L L L QQQ s s sTable created.insert into tl values Cl)；1 row created.SQL commit;Commit complete.7、查询当前的时间select to_char( sysdate ,yyyy-mm-dd:hh24:mi:ss,) from dual;SQL select to_charC sysdate ,YYYY-MM-DD:HH24:MI:SS) from dual;TO_CHAR(SYSDATE,YY2023-06-22:10:01:158、模拟破坏insert into tl

4、 values (2); commit;SQL insert into tl values (2);1 row created.连续插入3、4、5后并提交SQL insert i nto tl values (4);1 row created.SQL commit;Commit complete.SQL insert 1nto tl values (5);1 row created.SQL commi t;Commi t complete.另开一个窗口，以sys身份登录并切换日志。su - oracle.oraenvorcl2sqlplus / as sysdbaalter system sw

5、itch logfile;SQL alter system switch 1ogfi1e;System altered.9、模拟删除tl表drop table tl purge;SQL drop table tl purge;Table dropped.SQLssh2: AES-256-CTR 24, 6 24 行,80 列 Linux大写数字select * from tl;这时发现tl表已经被删除了 ；SQL select 寺 from tl;select % from tlERROR at line 1:ORA-00942: table or vi ew does not existSQ

6、L10、 利用闪回6恢复rman target /list incarnation of database;RMAN list 1ncarnati on of database;using target database control file instead of recovery catalogList of Database IncarnationsDB Key Inc Key DB Name DB IDSTATUS Reset SCN Reset Time0RCL20RCL20RCL2112085400611208540061120854006PARENT 1928875PARENT

7、 2103854CURRENT 2105760ll-JUN-21 2O-JUN-23 2O-JUN-23shutdown immediate; startup mount;SQL shutdown immediate;Database closed.Database di smounted.ORACLE instance shut down.SQL startup mount;ORACLE instance started.Total System Global Fixed Si zeVari able Si ze Database Buffers Redo Buffers Database

8、mounted.Area2566913256889981655364812819964887047876608bytes bytes bytes bytes bytes11、 查看闪回的时间，默认是1440分钟，也就是1天show parameter flashback;SQL show parameter flashbackNAMETYPEVALUEdb_f1ashback_retenti on_targeti nteger1440SOL查看闪回日志desc v$flashback_database_log;SQL desc v$f1ashback_database_logNameNull?

9、TypeOLDEST_FLASHBACK_SCNNUMBEROLDEST_FLASHBACK_TIMEDATERETENTION_TARGETNUMBERFLASHBACK_SIZENUMBERESTIMATED_FLASHBACK_SIZENUMBERCON_IDNUMBERSQL12、 闪回flashback database to timestamp to_timestamp( ,2023-06-22:10:01:15,: yyyy-mm- dd:hh24:mi:ss);SQL flashback database to timestamp to_timestamp(202 3-06-2

10、2:10:01:15 ,1YYYY-MM -DD:HH24:MI:SS);Flashback complete.13、 以只读方式打开数据库并查看闪回时间点是否正确，如果不正确可以重新再做alter database open read only;conn hr/oracle_4u select * from tl;SQL alter database open read only;Database altered.SQL conn hr/oracle_4U Connected.SQL select * from tl;A1SQL这时看到，tl表已经恢复14、 换化身shutdown imme

11、diate;startupmount;alter database open resetlogs;SQL shutdown immediate;Database closed.Database di smounted.ORACLE instance shut down.SQL startup mount;ORACLE i nstance started.Total System G1obal Area Fi xed Si zeVari able Si ze Database Buffers Redo Buffers Database mounted. SQL alter database open25669132568899816 553648128 19964887047876608bytes bytes bytes bytes bytesreset1ogs;Database altered.SQL