第14次活动：2017-08-28（星期一晚上7:00-10:00）

botang

bclresult-10d.zip (56.58 KB, 下载次数: 244)

2017-8-29 11:14 上传

点击文件名下载附件    bclresult-9b.zip (54.22 KB, 下载次数: 272)

2017-8-29 11:15 上传

点击文件名下载附件    bclresult-9d.zip (52.35 KB, 下载次数: 247)

2017-8-29 11:15 上传

点击文件名下载附件    bclresult-10b.zip (56.4 KB, 下载次数: 258)

2017-8-29 11:15 上传

点击文件名下载附件    bclresult-11a.zip (47.16 KB, 下载次数: 250)

2017-8-29 11:15 上传

点击文件名下载附件

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 28 20:24:17 2017
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected to an idle instance.
   
9. SQL> startup
   
10. ORACLE instance started.
    
11. 
    
12. Total System Global Area 6680915968 bytes
    
13. Fixed Size                    2213936 bytes
    
14. Variable Size                 3556771792 bytes
    
15. Database Buffers         3087007744 bytes
    
16. Redo Buffers                   34922496 bytes
    
17. ORA-00205: error in identifying control file, check alert log for more info
    
18. 
    
19. 
    
20. SQL> @control9d-after.sql
    
21. 
    
22. Control file created.
    
23. 
    
24. 
    
25. PL/SQL procedure successfully completed.
    
26. 
    
27. 
    
28. PL/SQL procedure successfully completed.
    
29. 
    
30. 
    
31. PL/SQL procedure successfully completed.
    
32. 
    
33. 
    
34. PL/SQL procedure successfully completed.
    
35. 
    
36. 
    
37. PL/SQL procedure successfully completed.
    
38. 
    
39. 
    
40. PL/SQL procedure successfully completed.
    
41. 
    
42. 
    
43. PL/SQL procedure successfully completed.
    
44. 
    
45. 
    
46. PL/SQL procedure successfully completed.
    
47. 
    
48. SQL> select  name , status from v$datafile;
    
49. 
    
50. NAME
    
51. --------------------------------------------------------------------------------
    
52. STATUS
    
53. -------
    
54. +DATA/orcl/datafile/system.259.953150809
    
55. SYSTEM
    
56. 
    
57. +DATA/orcl/datafile/sysaux.257.953150809
    
58. RECOVER
    
59. 
    
60. +DATA/orcl/datafile/undotbs1.258.953150809
    
61. RECOVER
    
62. 
    
63. 
    
64. NAME
    
65. --------------------------------------------------------------------------------
    
66. STATUS
    
67. -------
    
68. +DATA/orcl/datafile/example.256.953150809
    
69. RECOVER
    
70. 
    
71. +DATA/orcl/datafile/tbsocp05_test.263.953150809
    
72. RECOVER
    
73. 
    
74. 
    
75. SQL>
    

复制代码

用脚本改数据库名，另一种做法是NID：

1. CREATE CONTROLFILE  set  DATABASE  "NEWEXAM"   RESETLOGS  NOARCHIVELOG
   
2. --  SET STANDBY TO MAXIMIZE PERFORMANCE
   
3.     MAXLOGFILES 50
   
4.     MAXLOGMEMBERS 5
   
5.     MAXDATAFILES 100
   
6.     MAXINSTANCES 1
   
7.     MAXLOGHISTORY 226
   
8. LOGFILE
   
9.   GROUP 1 '/home/ora9i/oradata/newexam/redo01.log'  SIZE 100M,
   
10.   GROUP 2 '/home/ora9i/oradata/newexam/redo02.log'  SIZE 100M,
    
11.   GROUP 3 '/home/ora9i/oradata/newexam/redo03.log'  SIZE 100M
    
12. -- STANDBY LOGFILE
    
13. DATAFILE
    
14.   '/home/ora9i/oradata/newexam/system01.dbf',
    
15.   '/home/ora9i/oradata/newexam/undotbs01.dbf',
    
16.   '/home/ora9i/oradata/newexam/cwmlite01.dbf',
    
17.   '/home/ora9i/oradata/newexam/drsys01.dbf',
    
18.   '/home/ora9i/oradata/newexam/example01.dbf',
    
19.   '/home/ora9i/oradata/newexam/indx01.dbf',
    
20.   '/home/ora9i/oradata/newexam/odm01.dbf',
    
21.   '/home/ora9i/oradata/newexam/tools01.dbf',
    
22.   '/home/ora9i/oradata/newexam/users01.dbf',
    
23.   '/home/ora9i/oradata/newexam/xdb01.dbf'
    
24. CHARACTER SET ZHS16GBK
    
25. ;
    
26. # Recovery is required if any of the datafiles are restored backups,
    
27. # or if the last shutdown was not normal or immediate.
    
28. # Database can now be opened normally.
    
29. # No tempfile entries found to add.
    
30. #

复制代码