- 论坛徽章:
- 0
|
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'
|
|