SQL> CREATE TABLE test01 AS SELECT * FROM scott.emp;  Table created    SQL> select count(*) from test01;    COUNT(*)  ----------          14

--創建表test02  create table test02  (      col1      number,      col2      number,      col3      varchar2(30),      col4      date,      col5      varchar2(100)  );    --創建隨機數據插入存儲過程  create or replace procedure p_insert_test02 is  BEGIN    FOR i IN 1..10000 LOOP    insert into test02(col1,col2,col3,col4,col5)    values      ((select round(dbms_random.value(1, 100000000)) from dual),       (select round(dbms_random.value(10000, 100000000)) from dual),       (select dbms_random.string('a', 25) from dual),       sysdate,       (select dbms_random.string('a', 85) from dual));    commit;    END LOOP;  end  p_insert_test02;    --制定job，沒隔30s執行一次上面的存儲過程  declare  job1 number;  begin  sys.dbms_job.submit(job => job1,  what => 'p_insert_test02;',  next_date => sysdate,  interval => 'sysdate + 30/(1440*60)');                --每隔30s向test02表插入10000筆隨機數據  commit;  end;  /

rman target /    RMAN> run {  allocate channel c1 type disk;  allocate channel c2 type disk;  sql' alter system archive log current';  backup database format '/databaseBackup/full_db_%U';  sql' alter system archive log current';  backup archivelog all format '/databaseBackup/archlog_%U';  backup current controlfile format '/databaseBackup/controlfile_%U';  backup spfile format '/databaseBackup/spfile_%U';  release channel c1;  release channel c2;  }

SELECT *  FROM  (SELECT thread#,         SEQUENCE#,         NAME,         ROW_NUMBER() OVER(PARTITION BY thread# ORDER BY SEQUENCE# DESC) rn    FROM V$ARCHIVED_LOG)  WHERE rn=1;

SQL> select sysdate from dual;    SYSDATE  -------------------  2019-09-27 19:37:31    SQL>  SQL> truncate table test01;    Table truncated.

[oracle@node1 databaseBackup]$ scp * 192.168.10.66:/databaseBackup/

run {  allocate channel c1 type disk;  sql' alter system archive log current';  backup archivelog all format '/databaseBackup/archlog_20190927_%U';  release channel c1;  }

[oracle@test dbs]$ pwd  /u01/app/oracle/product/11.2.0/db_1/dbs    [oracle@test dbs]$ vim init initprodb.ora  # 添加如下資訊  audit_file_dest='/u01/app/oracle/admin/prodb/adump'  audit_trail='db'  compatible='11.2.0.4.0'  control_files='+DATA/prodb/controlfile/current.260.1019830577'  db_block_size=8192  db_create_file_dest='+DATA'  db_domain=''  db_name='prodb'  diagnostic_dest='/u01/app/oracle'  dispatchers='(PROTOCOL=TCP) (SERVICE=prodbXDB)'  enable_ddl_logging=TRUE  log_archive_dest_1='LOCATION=+arch'  log_archive_format='%t_%s_%r.dbf'  open_cursors=300  pga_aggregate_target=399507456  processes=200  remote_login_passwordfile='exclusive'  sessions=225  sga_target=1199570944  prodb.undo_tablespace='UNDOTBS1'    [oracle@test dbs]$ ls  hc_prodb.dat  hc_testdb1.dat  hc_testdb.dat  init.ora  initprodb.ora  lkTESTDB

[oracle@test ~]$ mkdir -p /u01/app/oracle/admin/prodb/adump

[oracle@test ~]$ export ORACLE_SID=prodb  [oracle@test ~]$ sqlplus / as sysdba    SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 27 20:58:15 2019    Copyright (c) 1982, 2013, Oracle.  All rights reserved.    Connected to an idle instance.    SQL> startup nomount;  ORACLE instance started.    Total System Global Area 1202556928 bytes  Fixed Size            2252704 bytes  Variable Size          402653280 bytes  Database Buffers      788529152 bytes  Redo Buffers            9121792 bytes  SQL>

[oracle@test ~]$ srvctl add database -d prodb -o /u01/app/oracle/product/11.2.0/db_1

RMAN> restore controlfile from "/databaseBackup/controlfile_0lucr7m2_1_1";

ASMCMD> pwd  +data/prodb/controlfile  ASMCMD> ls -lt  Type         Redund  Striped  Time             Sys  Name  CONTROLFILE  UNPROT  FINE     SEP 27 21:00:00  Y    current.256.1020114329

[oracle@test ~]$ cd $ORACLE_HOME/dbs  [oracle@test dbs]$ vim initprodb.ora  # 改control_files位置  control_files='+data/prodb/controlfile/current.256.1020114329'

[oracle@test ~]$ sqlplus / as sysdba    SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 27 21:17:26 2019    Copyright (c) 1982, 2013, Oracle.  All rights reserved.      Connected to:  Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production  With the Partitioning, Automatic Storage Management, OLAP, Data Mining  and Real Application Testing options    SQL> shutdown immediate  ORA-01507: database not mounted      ORACLE instance shut down.  SQL> startup mount  ORACLE instance started.    Total System Global Area 1202556928 bytes  Fixed Size            2252704 bytes  Variable Size          402653280 bytes  Database Buffers      788529152 bytes  Redo Buffers            9121792 bytes  Database mounted.  SQL>

RMAN> catalog backuppiece "/databaseBackup/archlog_20190927_0nucrcd2_1_1";  RMAN> catalog backuppiece "/databaseBackup/archlog_20190927_0oucrcg5_1_1";  RMAN> catalog backuppiece "/databaseBackup/archlog_20190927_0pucrcjj_1_1";

RMAN＞SQL"ALTER SESSION SET NLS_LANGUAGE=''AMERICAN''";  RMAN＞SQL"ALTER SESSION SET NLS_DATE_FORMAT=''YYYY-MM-DD HH24:MI:SS''";  RUN{  SET UNTIL TIME '2019-09-27 19:37:31';  RESTORE DATABASE;  RECOVER DATABASE;  }

--先以只讀方式打開資料庫，如果有問題，還可以重新執行恢復  SQL> alter database open read only;  Database altered.    --確認數據是否找回來  SQL> select count(*) from lijiaman.test01;    COUNT(*)  ----------      14

SQL> shutdown immediate;  Database closed.  Database dismounted.  ORACLE instance shut down.    SQL> startup mount  ORACLE instance started.    Total System Global Area 1202556928 bytes  Fixed Size            2252704 bytes  Variable Size          402653280 bytes  Database Buffers      788529152 bytes  Redo Buffers            9121792 bytes  Database mounted.    SQL> alter database open resetlogs;    Database altered.