?
? ?試驗(yàn)計劃：先做一個0級備份，再創(chuàng)建一個表，插入幾條數(shù)據(jù)，最后刪除表，然后通過rman把該表的數(shù)據(jù)恢復(fù)。
?
試驗(yàn)環(huán)境：在歸檔模式，oracle10.2.0.1
?
開始試驗(yàn)：
1.rman level 0備份
RMAN> backup incremental level 0
database;
Starting backup at
02
-DEC-
13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid
=
154
devtype=
DISK
channel ORA_DISK_1: starting incremental level
0
datafile backupset
channel ORA_DISK_1: specifying datafile(s)
in
backupset
input datafile fno
=
00001
name=/u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
system01.dbf
input datafile fno
=
00003
name=/u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
sysaux01.dbf
input datafile fno
=
00002
name=/u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
undotbs01.dbf
input datafile fno
=
00006
name=/u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
yn.dbf
input datafile fno
=
00004
name=/u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
users01.dbf
channel ORA_DISK_1: starting piece
1
at
02
-DEC-
13
channel ORA_DISK_1: finished piece
1
at
02
-DEC-
13
piece handle
=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_12_02/o1_mf_nnnd0_TAG20131202T211658_99s22c7o_.bkp tag=TAG20131202T211658 comment=
NONE
channel ORA_DISK_1: backup
set
complete, elapsed time:
00
:
01
:
25
channel ORA_DISK_1: starting incremental level
0
datafile backupset
channel ORA_DISK_1: specifying datafile(s)
in
backupset
including current control file
in
backupset
including current SPFILE
in
backupset
channel ORA_DISK_1: starting piece
1
at
02
-DEC-
13
channel ORA_DISK_1: finished piece
1
at
02
-DEC-
13
piece handle
=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_12_02/o1_mf_ncsn0_TAG20131202T211658_99s252by_.bkp tag=TAG20131202T211658 comment=
NONE
channel ORA_DISK_1: backup
set
complete, elapsed time:
00
:
00
:
05
Finished backup at
02
-DEC-
13
2.創(chuàng)建表
SQL> create table t1(id
int
,name varchar2(
20
));
Table created.
SQL
> insert into t1 values(
1
,
'
first
'
);
1
row created.
SQL
>
commit;
SQL
> insert into t1 values(
2
,
'
second
'
);
1
row created.
SQL
>
commit;
Commit complete.
SQL
> alter system switch
logfile;
System altered.
SQL
>
select
*
from
t1;
ID NAME
---------- --------------------
1
first
2
second
3.查詢當(dāng)前系統(tǒng)時間
SQL>
select
to_char(sysdate,
'
yyyy-mm-dd hh24:mi:ss
'
)
from
dual;
TO_CHAR(SYSDATE,
'
YY
-------------------
2013
-
12
-
02
21
:
41
:
55
?
4.刪除表，關(guān)閉數(shù)據(jù)庫，重啟數(shù)據(jù)庫
SQL>
drop table t1;
Table dropped.
SQL
>
shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL
>
startup mount
ORACLE instance started.
Total System Global Area
599785472
bytes
Fixed Size
2022632
bytes
Variable Size
243270424
bytes
Database Buffers
352321536
bytes
Redo Buffers
2170880
bytes
Database mounted.
SQL
>
select
status
from
v$instance;
STATUS
------------
MOUNTED
5.rman恢復(fù)
RMAN> run{
2> allocate channel c1 type disk;
3> set until time "to_date('2013-12-02 21:41:55','yyyy-mm-dd hh24:mi:ss')";
4> restore database;
5> recover database;
6> sql 'alter database open resetlogs';
7
>
}
allocated channel: c1
channel c1: sid
=
155
devtype=
DISK
executing command: SET until clause
Starting restore at
02
-DEC-
13
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore
from
backup
set
restoring datafile
00001
to /u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
system01.dbf
restoring datafile
00002
to /u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
undotbs01.dbf
restoring datafile
00003
to /u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
sysaux01.dbf
restoring datafile
00004
to /u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
users01.dbf
restoring datafile
00006
to /u01/app/oracle/product/
10.2
.
0
/db_2/oradata/orcl/
yn.dbf
channel c1: reading
from
backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_12_02/
o1_mf_nnnd0_TAG20131202T211658_99s22c7o_.bkp
channel c1: restored backup piece
1
piece handle
=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_12_02/o1_mf_nnnd0_TAG20131202T211658_99s22c7o_.bkp tag=
TAG20131202T211658
channel c1: restore complete, elapsed time:
00
:
00
:
45
Finished restore at
02
-DEC-
13
Starting recover at
02
-DEC-
13
starting media recovery
archive log thread
1
sequence
56
is
already on disk
as
file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/
o1_mf_1_56_99s2jvny_.arc
archive log thread
1
sequence
57
is
already on disk
as
file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/
o1_mf_1_57_99s2lpbk_.arc
archive log thread
1
sequence
58
is
already on disk
as
file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/
o1_mf_1_58_99s3d5ph_.arc
archive log thread
1
sequence
1
is
already on disk
as
file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/
o1_mf_1_1_99s3j6fg_.arc
archive log filename
=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/o1_mf_1_56_99s2jvny_.arc thread=
1
sequence=
56
archive log filename
=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/o1_mf_1_57_99s2lpbk_.arc thread=
1
sequence=
57
archive log filename
=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_12_02/o1_mf_1_58_99s3d5ph_.arc thread=
1
sequence=
58
media recovery complete, elapsed time:
00
:
00
:
02
Finished recover at
02
-DEC-
13
sql statement: alter database open resetlogs
released channel: c1
RMAN
>
?
6.查詢被刪除的數(shù)據(jù)
SQL>
select
*
from
t1;
ID NAME
---------- --------------------
1
first
2
second
SQL
>
?
7.重新備份數(shù)據(jù)庫
? ?在生產(chǎn)環(huán)境中，不完全恢復(fù)后，是要用rman重新備份的。因?yàn)樵搨浞菔且院髷?shù)據(jù)恢復(fù)的一個起點(diǎn)。
?
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯(lián)系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長非常感激您！手機(jī)微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
