RMAN基于时间点回复数据

1、查看数据库是否归档

[oracle@DG1 ~]$sqlplus / as sysdba

SQL> archive log list

2、实验过程

2.1创建测试用户

CREATE TABLESPACE qqqDATAFILE'/u01/app/oradata/yyy/qqq01.dbf' SIZE 50M

create user qqq identified by qqq defaultTABLESPACE qqq;

grant resource,connect,dba to qqq;

conn qqq/qqq

create table tb_SalGra(

pk_SalGra_ID number primary key,

losal number,

hisal number

);

insert into tb_SalGra values (1,700,1200);

insert into tb_SalGra values (2,1201,1400);

2.2在归档下对数据库做RMAN全备

[oracle@oracle scripts]$ ./rman_bak_level0.sh

2.3删除tb_SalGra表及qqq用户

查看当前时间

SQL> select to_char(sysdate,'yyyy-mm-ddhh24:mi:ss') time from dual;

TIME