398236817 发表于 2018-01-30 16:50

求助：NBU7.6 恢复oracle时出错

nbu还原oracle的时候，控制文件已经还原成功了。但是还原数据库的时候报错。求各位老大，有什么解决方法。
RMAN> run {
2>allocate channel D1 type 'sbt_tape' parms 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
3> send 'NB_ORA_SERV=******,NB_ORA_CLIENT=*******';
4> set until time "to_date('2018-01-25:00:00:00','YYYY-MM-DD hh24:mi:ss')";
5>    restore database;
6>   recover database;
7> RELEASE CHANNEL D1;
8>   }
allocated channel: D1
channel D1: SID=63 device type=SBT_TAPE
channel D1: Veritas NetBackup for Oracle - Release 7.6 (2014070620)
sent command to channel: D1
executing command: SET until clause
Starting restore at 30-JAN-18
creating datafile file number=1 name=/oracledata/oracle/CSIC8/system01.dbf
released channel: D1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2018 16:25:47
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oracledata/oracle/CSIC8/system01.dbf'

RMAN> run {
2>allocate channel D1 type 'sbt_tape' parms 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
3> send 'NB_ORA_SERV=lilynub,NB_ORA_CLIENT=LILYPLMDBD02';
4> set until time "to_date('2018-01-25:00:00:00','YYYY-MM-DD hh24:mi:ss')";
5>    restore database;
6>   recover database;
7> RELEASE CHANNEL D1;
8>   }

allocated channel: D1
channel D1: SID=63 device type=SBT_TAPE
channel D1: Veritas NetBackup for Oracle - Release 7.6 (2014070620)

sent command to channel: D1

executing command: SET until clause

Starting restore at 30-JAN-18

creating datafile file number=1 name=/oracledata/oracle/CSIC8/system01.dbf
released channel: D1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2018 16:25:47
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/oracledata/oracle/CSIC8/system01.dbf'


notooth 发表于 2018-02-20 10:34

先看看是不是权限问题，如果排除权限问题，检查一下备份集是否有效。
RMAN> list backup of datafile 1;

无牙 发表于 2018-02-20 10:38

先看看是不是权限问题，如果排除权限问题，检查一下备份集是否有效。
RMAN> list backup of datafile 1;

noise 发表于 2018-02-20 19:11

原机恢复还是异机恢复，如果是异机确认一下路径是否有效。
页: [1]
查看完整版本: 求助：NBU7.6 恢复oracle时出错