如何restore db from tag？

znn19850323

大師們，我是個新手，

我想restore database從一個指定的tag，

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  F  A DISK        14-MAY-14       1       1       NO         TAG20140514T095446
2       B  F  A DISK        15-MAY-14       1       1       NO         TAG20140515T162453
3       B  0  A DISK        19-MAY-14       1       1       NO         DB0
4       B  0  A DISK        19-MAY-14       1       1       NO         DB0
5       B  F  A DISK        19-MAY-14       1       1       NO         TAG20140519T193328
6       B  0  A DISK        21-MAY-14       1       1       NO         DB0
7       B  0  A DISK        21-MAY-14       1       1       NO         DB0
8       B  F  A DISK        21-MAY-14       1       1       NO         TAG20140521T191523

比如TAG20140521T191523（最新的一個 full backup),  遇到了錯誤

RMAN> restore database from tag='TAG20140519T193328'
2> ;

Starting restore at 21-MAY-14
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/21/2014 19:19:09
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

請問這是怎么回事？如何解決？  謝謝

www_xylove

備份還在嗎？
crosscheck backup;

znn19850323

二樓：

crosscheck 通過，沒有報錯

znn19850323

我用restore database 可以，但是不能指定具體的tag ，很奇怪，

RMAN> restore database;

Starting restore at 22-MAY-14
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/app/oradata/first_time_oracle/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/oracle/app/oradata/first_time_oracle/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/app/oradata/first_time_oracle/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/app/oradata/first_time_oracle/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/app/RmanBackup/db0_FIRST_TI_20140521_8
channel ORA_DISK_1: piece handle=/home/oracle/app/RmanBackup/db0_FIRST_TI_20140521_8 tag=DB0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:45
Finished restore at 22-MAY-14

www_xylove

指定tag，需要注意語法的書寫的正確性。

jackson198574

你這臺機器上有幾個數(shù)據(jù)庫？

znn19850323

回復(fù) 6# jackson198574


    我機器上就一個庫啊

znn19850323

回復(fù) 5# www_xylove


    restore database from tag=`tagxxxxxx' 不對嗎？

znn19850323

貼上我的full backup 腳本：

[oracle@localhost RmanBackup]$ cat BackupFull.sh
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATHHOME/binORACLE_HOME/bin

rman target/ << EOF_RMAN
run{
allocate channel c1 type disk;
backup incremental level 0 tag 'db0' format
'/home/oracle/app/RmanBackup/db0_%d_%T_%s' database include current controlfile;
delete noprompt obsolete;
release channel c1;
}

[oracle@localhost RmanBackup]$ pwd
/home/oracle/app/RmanBackup

[oracle@localhost RmanBackup]$ echo $ORACLE_HOME
/home/oracle/app/oracle/product/11.2.0/dbhome_1

znn19850323

成功了！:wink:

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  F  A DISK        14-MAY-14       1       1       NO         TAG20140514T095446
2       B  F  A DISK        15-MAY-14       1       1       NO         TAG20140515T162453
3       B  0  A DISK        19-MAY-14       1       1       NO         DB0
4       B  0  A DISK        19-MAY-14       1       1       NO         DB0
5       B  F  A DISK        19-MAY-14       1       1       NO         TAG20140519T193328
6       B  0  A DISK        21-MAY-14       1       1       NO         DB0
7       B  0  A DISK        21-MAY-14       1       1       NO         DB0
8       B  F  A DISK        21-MAY-14       1       1       NO         TAG20140521T191523

RMAN> restore database from tag='DB0';

Starting restore at 23-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/app/oradata/first_time_oracle/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /home/oracle/app/oradata/first_time_oracle/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/app/oradata/first_time_oracle/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/app/oradata/first_time_oracle/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/app/RmanBackup/db0_FIRST_TI_20140521_8
channel ORA_DISK_1: piece handle=/home/oracle/app/RmanBackup/db0_FIRST_TI_20140521_8 tag=DB0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:15
Finished restore at 23-MAY-14

我把庫重啟，然后startup mount ，然后Rman restore 就行了！ 以前庫一直是open狀態(tài)。。。。