如何利用Direct NFS克隆Oracle数据库(三)

2015-07-16 12:09:09 · 作者: · 浏览: 8
',如果直接backup as copy database format '/backup/prod/%U',在执行


dbren.sql脚本时,会出现以下错误:


?


SQL> @dbren.sql
SQL> declare
? 2? begin
? 3? dbms_dnfs.clonedb_renamefile('/prod/backup/data_D-PROD_I-289579616_TS-SYSAUX_FNO-2_08q553gd' , '/u01/app/oracle/oradata/orcl/ora_data_orcl0.dbf');
? 4? dbms_dnfs.clonedb_renamefile('/prod/backup/data_D-PROD_I-289579616_TS-SYSTEM_FNO-1_07q553dp' , '/u01/app/oracle/oradata/orcl/ora_data_orcl1.dbf');
? 5? dbms_dnfs.clonedb_renamefile('/prod/backup/data_D-PROD_I-289579616_TS-UNDOTBS1_FNO-3_09q553hj' , '/u01/app/oracle/oradata/orcl/ora_data_orcl2.dbf');
? 6? dbms_dnfs.clonedb_renamefile('/prod/backup/data_D-PROD_I-289579616_TS-USERS_FNO-4_0bq553i5' , '/u01/app/oracle/oradata/orcl/ora_data_orcl3.dbf');
? 7? end;
? 8? /


PL/SQL procedure successfully completed.


SQL> show errors;
No errors.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/ora_data_orcl1.dbf'


?


?


3> 如果数据库启用了Direct NFS,在告警日志中会有如下信息:Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0。


? ? 同时,可查看v$dnfs_servers视图。


SQL> select * from v$dnfs_servers;


?ID SVRNAME? ? ? ? DIRNA? ? ? MNTPORT? ? NFSPORT? ? ? WTMAX? RTMAX
--- -------------------- ----- ---------- ---------- ---------- ------
? 1 node3.being.com? ? /u01? ? ? ? 44046? ? 2049? ? ? 32768? 32768


? ? 注意:并不是启动了Direct NFS,该视图就会填充,可通过创建测试表空间来验证create tablespace test datafile '/backup/prod/test.dbf' size 2m,如果能创建成功,该视图也会被填充的。