探索ORACLE之RMAN_03非一致性备份(五)
BP Key:14 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133645
Piece Name:/DBBak/bak_WWL_05_23_0gnbn2je_1_1
Control FileIncluded: Ckp SCN: 651150 Ckp time:23-MAY-12
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
15 Full 6.80M DISK 00:00:01 23-MAY-12
BP Key:15 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133648
Piece Name:/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120523-03
Control FileIncluded: Ckp SCN: 651154 Ckp time:23-MAY-12
SPFILE Included:Modification time: 23-MAY-12
如下是备份spfile文件的信息：
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
16 Full 80.00K DISK 00:00:01 23-MAY-12
BP Key:16 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133737
Piece Name:/DBBak/bak_WWL_05_23_0inbn2l2_1_1
SPFILE Included:Modification time: 23-MAY-12
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
17 Full 6.80M DISK 00:00:02 23-MAY-12
BP Key:17 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133740
Piece Name:/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120523-04
Control FileIncluded: Ckp SCN: 651175 Ckp time:23-MAY-12
SPFILE Included:Modification time: 23-MAY-12 www.2cto.com
RMAN>
恢复大综合：
介于Rman恢复的自动性，我们刚才对数据库的全库，单表空间，数据文件控制文件和参数文件都做了备份，这些备份的内容是数据库运行不可缺少的必要元素，通常情况下我们在生产库中只需要备份这些内容即可。有了这些备份，即使数据库的的任何信息丢失，我们都可以得以恢复使得数据库的正常运行，当然如果我们将archive log 也备份，当然就会更好了，一般情况下这个可以不用备份，备份archive log占用空间非常大。如果有海量的储存，当然备份也无妨咯。
Egg:
2.1 删除数据库的所有文件，仅保留redo日志和archivelog文件
删除控制文件：
[oracle@wwldb WWL]$ pwd
/DBData/oradata/WWL
[oracle@wwldb WWL]$ ls
control02.ctl control03.ctl
[oracle@wwldb WWL]$ rm -rf *.ctl
[oracle@wwldbWWL]$
[oracle@wwldb WWL]$ pwd
/DBSoft/oradata/WWL
[oracle@wwldb WWL]$ ls
control01.ctl
[oracle@wwldb WWL]$ rm -rf control01.ctl
[oracle@wwldbWWL]$
删除数据文件：
[oracle@wwldb WWL]$ ls
redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@wwldb WWL]$ rm -rf *.dbf
[oracle@wwldb WWL]$ ls
redo01.log redo02.log redo03.log
[oracle@wwldbWWL]$
删除参数文件：
[oracle@wwldb dbs]$ cd $ORACLE_HOME/dbs
[oracle@wwldb dbs]$ rm -rf spfileWWL.ora
[oracle@wwldbdbs]$
执行大恢复
1、现在数据库是关闭状态 www.2cto.com
[oracle@wwldb dbs]$ ps -ef|grep ora
root 2910 2888 0 10:02 00:00:15 hald-addon-storage: polling/dev/hdc
root 28954 3478 0 11:38 pts/1 00:00:00 su - oracle
oracle 28955 28954 0 11:38 pts/1 00:00:00 -bash
root 29361 3438 0 13:41 pts/2 00:00:00 su - oracle
oracle 29362 29361 0 13:41 pts/2 00:00:01 -bash
oracle 29988 29362 0 16:06 pts/2 00:00:00sqlplus as sysdba
oracle 30102 28955 0 17:03 pts/1 00:00:00 ps -ef
oracle 30103 28955 0 17:03 pts/1 00:00:00 grep ora
[oracle@wwldbdbs]$
2、要恢复首先要将数据库启动到mount状态才能恢复
[oracle@wwldb dbs]$ sqlplus / as sysdba
SQL*Plus:Release 10.2.0.1.0 - Production on Wed May 23 17:03:42 2012
Copyright (c)198