（52-10）第13/14次：2015-10-30星期五，2015-11-2星期一

botang

上完1Z0-052第15章，（52-9）
上完1Z0-053第2章，（52-10）


catalog:

1. Starting Control File and SPFILE Autobackup at 02-NOV-15
   
2. piece handle=c-1343950367-20151102-03 comment=API Version 2.0,MMS Version 10.3.0.2
   
3. Finished Control File and SPFILE Autobackup at 02-NOV-15
   
4. 
   
5. RMAN> list backupset 48;
   
6. 
   
7. 
   
8. List of Backup Sets
   
9. ===================
   
10. 
    
11. 
    
12. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
13. ------- ---- -- ---------- ----------- ------------ ---------------
    
14. 48      Full    69.01M     SBT_TAPE    00:00:01     02-NOV-15      
    
15.         BP Key: 52   Status: AVAILABLE  Compressed: NO  Tag: TAG20151102T201139
    
16.         Handle: 1hql9e3r_1_3   Media: station90-000011
    
17.   List of Datafiles in backup set 48
    
18.   File LV Type Ckp SCN    Ckp Time  Name
    
19.   ---- -- ---- ---------- --------- ----
    
20.   5       Full 2001595    02-NOV-15 +DATA/orcl/datafile/example.265.816169651
    
21. 
    
22. RMAN> exit
    
23. 
    
24. 
    
25. Recovery Manager complete.
    
26. [oracle@station90 ~]$ . oraenv
    
27. ORACLE_SID = [orcl] ? rcat
    
28. The Oracle base remains unchanged with value /u01/app/oracle
    
29. [oracle@station90 ~]$ sqlplus /nolog
    
30. 
    
31. SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 2 21:32:32 2015
    
32. 
    
33. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
34. 
    
35. SQL> conn / as sysdba
    
36. Connected to an idle instance.
    
37. SQL> startup
    
38. ORACLE instance started.
    
39. 
    
40. Total System Global Area 1603411968 bytes
    
41. Fixed Size                    2228784 bytes
    
42. Variable Size                  503320016 bytes
    
43. Database Buffers         1090519040 bytes
    
44. Redo Buffers                    7344128 bytes
    
45. Database mounted.
    
46. Database opened.
    
47. SQL> set linesize 1000
    
48. SQL> select file_name from dba_data_files;
    
49. 
    
50. FILE_NAME
    
51. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    
52. /u01/app/oracle/oradata/rcat/users01.dbf
    
53. /u01/app/oracle/oradata/rcat/undotbs01.dbf
    
54. /u01/app/oracle/oradata/rcat/sysaux01.dbf
    
55. /u01/app/oracle/oradata/rcat/system01.dbf
    
56. /u01/app/oracle/oradata/rcat/example01.dbf
    
57. /u01/app/oracle/oradata/rcat/rcat01.dbf
    
58. 
    
59. 6 rows selected.
    
60. 
    
61. SQL> select  tablespace_name from dba_tablespaces;
    
62. 
    
63. TABLESPACE_NAME
    
64. ------------------------------
    
65. SYSTEM
    
66. SYSAUX
    
67. UNDOTBS1
    
68. TEMP
    
69. USERS
    
70. EXAMPLE
    
71. RCAT
    
72. 
    
73. 7 rows selected.
    
74. 
    
75. SQL> show parameter instance_name
    
76. 
    
77. NAME                                     TYPE         VALUE
    
78. ------------------------------------ ----------- ------------------------------
    
79. instance_name                             string         rcat
    
80. SQL> show parameter service
    
81. 
    
82. NAME                                     TYPE         VALUE
    
83. ------------------------------------ ----------- ------------------------------
    
84. service_names                             string         rcat.example.com
    
85. SQL> create tablespace rcat datafile '/u01/app/oracle/oradata/rcat/rcat01.dbf' size 100M autoextend on ;
    
86. create tablespace rcat datafile '/u01/app/oracle/oradata/rcat/rcat01.dbf' size 100M autoextend on
    
87. *
    
88. ERROR at line 1:
    
89. ORA-01543: tablespace 'RCAT' already exists
    
90. 
    
91. 
    
92. SQL> create user u90 identified by oracle_4U default tablespace RCAT quota unlimited on rcat;
    
93. create user u90 identified by oracle_4U default tablespace RCAT quota unlimited on rcat
    
94.             *
    
95. ERROR at line 1:
    
96. ORA-01920: user name 'U90' conflicts with another user or role name
    
97. 
    
98. 
    
99. SQL> grant recovery_catalog_owner to u90;
    
100. 
     
101. Grant succeeded.
     
102. 
     
103. SQL>
     

复制代码