dataguard ORA-17628 处理

dataguard ORA-17628 处理

点击(此处)折叠或打开

1. RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
   
2. 
   
3. Starting Duplicate Db at 02-JUL-18
   
4. using target database control file instead of recovery catalog
   
5. allocated channel: ORA_AUX_DISK_1
   
6. channel ORA_AUX_DISK_1: SID=396 device type=DISK
   
7. 
   
8. 
   
9. contents of Memory Script:
   
10. {
    
11.    backup as copy reuse
    
12.    targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' auxiliary format
    
13.  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwnetdata' ;
    
14. }
    
15. executing Memory Script
    
16. 
    
17. 
    
18. Starting backup at 02-JUL-18
    
19. allocated channel: ORA_DISK_1
    
20. channel ORA_DISK_1: SID=408 device type=DISK
    
21. Finished backup at 02-JUL-18
    
22. 
    
23. 
    
24. contents of Memory Script:
    
25. {
    
26.    backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/netdata/control01.ctl';
    
27.    restore clone controlfile to '/u01/app/oracle/fast_recovery_area/netdata/control02.ctl' from
    
28.  '/u01/app/oracle/oradata/netdata/control01.ctl';
    
29. }
    
30. executing Memory Script
    
31. 
    
32. 
    
33. Starting backup at 02-JUL-18
    
34. using channel ORA_DISK_1
    
35. channel ORA_DISK_1: starting datafile copy
    
36. copying standby control file
    
37. output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_netdata.f tag=TAG20180702T183426 RECID=1 STAMP=980447667
    
38. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
    
39. Finished backup at 02-JUL-18
    
40. 
    
41. 
    
42. Starting restore at 02-JUL-18
    
43. using channel ORA_AUX_DISK_1
    
44. 
    
45. 
    
46. channel ORA_AUX_DISK_1: copied control file copy
    
47. Finished restore at 02-JUL-18
    
48. 
    
49. 
    
50. contents of Memory Script:
    
51. {
    
52.    sql clone 'alter database mount standby database';
    
53. }
    
54. executing Memory Script
    
55. 
    
56. 
    
57. sql statement: alter database mount standby database
    
58. 
    
59. 
    
60. contents of Memory Script:
    
61. {
    
62.    set newname for tempfile 1 to
    
63.  "/u01/app/oracle/oradata/netdata/temp01.dbf";
    
64.    switch clone tempfile all;
    
65.    set newname for datafile 1 to
    
66.  "/u01/app/oracle/oradata/netdata/system01.dbf";
    
67.    set newname for datafile 2 to
    
68.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf";
    
69.    set newname for datafile 3 to
    
70.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf";
    
71.    set newname for datafile 4 to
    
72.  "/u01/app/oracle/oradata/netdata/users01.dbf";
    
73.    backup as copy reuse
    
74.    datafile 1 auxiliary format
    
75.  "/u01/app/oracle/oradata/netdata/system01.dbf" datafile
    
76.  2 auxiliary format
    
77.  "/u01/app/oracle/oradata/netdata/sysaux01.dbf" datafile
    
78.  3 auxiliary format
    
79.  "/u01/app/oracle/oradata/netdata/undotbs01.dbf" datafile
    
80.  4 auxiliary format
    
81.  "/u01/app/oracle/oradata/netdata/users01.dbf" ;
    
82.    sql 'alter system archive log current';
    
83. }
    
84. executing Memory Script
    
85. 
    
86. 
    
87. executing command: SET NEWNAME
    
88. 
    
89. 
    
90. renamed tempfile 1 to /u01/app/oracle/oradata/netdata/temp01.dbf in control file
    
91. 
    
92. 
    
93. executing command: SET NEWNAME
    
94. 
    
95. 
    
96. executing command: SET NEWNAME
    
97. 
    
98. 
    
99. executing command: SET NEWNAME
    
100. 
     
101. 
     
102. executing command: SET NEWNAME
     
103. 
     
104. 
     
105. Starting backup at 02-JUL-18
     
106. using channel ORA_DISK_1
     
107. channel ORA_DISK_1: starting datafile copy
     
108. input datafile