知道datafile的file#,查询出该datafile在哪个backuppiece中

F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 – Production on Mon Feb 23 09:41:48 2015Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options09:41:49 sys@FS> col handle format a4009:41:59 sys@FS> set line 20009:42:13 sys@FS> select d.file#, p.handle09:42:16 2 from v$backup_piece p, v$backup_datafile d09:42:16 3 where d.set_stamp = p.set_stamp09:42:17 4and d.set_count = p.set_count09:42:17 5and d.file# = 2;FILE# HANDLE———- —————————————-22222222222222222222 H:\FSARCH\FULL_HOPVUMAD_1_120 rows selected.Elapsed: 00:00:00.0509:42:18 sys@FS>参考自:How To Locate What Files Are Backed Up In What RMAN Backup Set (文档 ID 246189.1)

,微风吹过,海面上金光闪闪,泛起一道道美丽的浪花,

知道datafile的file#,查询出该datafile在哪个backuppiece中

相关文章:

你感兴趣的文章:

标签云: