第25次：

botang

1. select  * from v$logfile;
   
2. 
   
3. select * from v$log;
   
4. 
   
5. alter database add logfile member '+DATA'   to group 1;
   
6. 
   
7. alter system switch logfile;
   
8. 
   
9. alter database drop logfile member '+DATA/orcl/onlinelog/group_1.269.856037447' ;
   
10. 
    

复制代码

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 19 19:38:37 2014
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> show parameter control
   
10. 
    
11. NAME                                     TYPE         VALUE
    
12. ------------------------------------ ----------- ------------------------------
    
13. control_file_record_keep_time             integer         7
    
14. control_files                             string         +DATA/orcl/controlfile/current
    
15.                                                  .260.816169631, +FRA/orcl/cont
    
16.                                                  rolfile/current.256.816169633
    
17. control_management_pack_access             string         DIAGNOSTIC+TUNING
    
18. SQL> exit
    
19. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
20. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
21. and Real Application Testing options
    
22. [oracle@station90 ~]$ rman target /  catalog u90/oracle_4U@rcat
    
23. 
    
24. Recovery Manager: Release 11.2.0.3.0 - Production on Tue Aug 19 19:46:01 2014
    
25. 
    
26. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
27. 
    
28. connected to target database: ORCL (DBID=1343950367)
    
29. RMAN-04007: WARNING from recovery catalog database: ORA-28002: the password will expire within 7 days
    
30. 
    
31. connected to recovery catalog database
    
32. 
    
33. RMAN> create catalog;
    
34. 
    
35. recovery catalog created
    
36. 
    
37. RMAN> register  database ;
    
38. 
    
39. database registered in recovery catalog
    
40. starting full resync of recovery catalog
    
41. full resync complete
    
42. 
    
43. RMAN> list backup ;
    
44. 
    
45. 
    
46. List of Backup Sets
    
47. ===================
    
48. 
    
49. 
    
50. BS Key  Size       Device Type Elapsed Time Completion Time
    
51. ------- ---------- ----------- ------------ ---------------
    
52. 154     64.00K     SBT_TAPE    00:01:46     06-AUG-14      
    
53.         BP Key: 162   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T194707
    
54.         Handle: 0qpf9rpr_1_1   Media: station90-000009
    
55. 
    
56.   List of Archived Logs in backup set 154
    
57.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
58.   ---- ------- ---------- --------- ---------- ---------
    
59.   1    93      1914471    06-AUG-14 1914701    06-AUG-14
    
60. 
    
61. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
62. ------- ---- -- ---------- ----------- ------------ ---------------
    
63. 155     Full    630.50M    SBT_TAPE    00:02:47     06-AUG-14      
    
64.         BP Key: 163   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T194902
    
65.         Handle: 0rpf9rtf_1_1   Media: station90-000009
    
66.   List of Datafiles in backup set 155
    
67.   File LV Type Ckp SCN    Ckp Time  Name
    
68.   ---- -- ---- ---------- --------- ----
    
69.   1       Full 1915012    06-AUG-14 +DATA/orcl/datafile/system.256.816169553
    
70. 
    
71. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
72. ------- ---- -- ---------- ----------- ------------ ---------------
    
73. 156     Full    431.06M    SBT_TAPE    00:03:17     06-AUG-14      
    
74.         BP Key: 164   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T194902
    
75.         Handle: 0tpf9rtf_1_1   Media: station90-000010
    
76.   List of Datafiles in backup set 156
    
77.   File LV Type Ckp SCN    Ckp Time  Name
    
78.   ---- -- ---- ---------- --------- ----
    
79.   2       Full 1915016    06-AUG-14 +DATA/orcl/datafile/sysaux.257.816169553
    
80. 
    
81. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
82. ------- ---- -- ---------- ----------- ------------ ---------------
    
83. 157     Full    642.50M    SBT_TAPE    00:06:03     06-AUG-14      
    
84.         BP Key: 165   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T194902
    
85.         Handle: 0spf9rtf_1_1   Media: station90-000009
    
86.   List of Datafiles in backup set 157
    
87.   File LV Type Ckp SCN    Ckp Time  Name
    
88.   ---- -- ---- ---------- --------- ----
    
89.   3       Full 1915014    06-AUG-14 +DATA/orcl/datafile/undotbs1.258.816169553
    
90. 
    
91. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
92. ------- ---- -- ---------- ----------- ------------ ---------------
    
93. 158     Full    69.06M     SBT_TAPE    00:06:20     06-AUG-14      
    
94.         BP Key: 166   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T194902
    
95.         Handle: 0upf9rtf_1_1   Media: station90-000010
    
96.   List of Datafiles in backup set 158
    
97.   File LV Type Ckp SCN    Ckp Time  Name
    
98.   ---- -- ---- ---------- --------- ----
    
99.   5       Full 1915018    06-AUG-14 +DATA/orcl/datafile/example.265.816169651
    
100. 
     
101. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
102. ------- ---- -- ---------- ----------- ------------ ---------------
     
103. 159     Full    3.31M      SBT_TAPE    00:07:57     06-AUG-14      
     
104.         BP Key: 167   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T194902
     
105.         Handle: 0vpf9rtg_1_1   Media: station90-000009
     
106.   List of Datafiles in backup set 159
     
107.   File LV Type Ckp SCN    Ckp Time  Name
     
108.   ---- -- ---- ---------- --------- ----
     
109.   4       Full 1915020    06-AUG-14 +DATA/orcl/datafile/users.259.816169553
     
110. 
     
111. BS Key  Size       Device Type Elapsed Time Completion Time
     
112. ------- ---------- ----------- ------------ ---------------
     
113. 160     2.63M      SBT_TAPE    00:01:39     06-AUG-14      
     
114.         BP Key: 168   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T195709
     
115.         Handle: 10pf9scl_1_1   Media: station90-000009
     
116. 
     
117.   List of Archived Logs in backup set 160
     
118.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
119.   ---- ------- ---------- --------- ---------- ---------
     
120.   1    94      1914701    06-AUG-14 1915763    06-AUG-14
     
121. 
     
122. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
123. ------- ---- -- ---------- ----------- ------------ ---------------
     
124. 161     Full    9.50M      SBT_TAPE    00:01:39     06-AUG-14      
     
125.         BP Key: 169   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T195855
     
126.         Handle: c-1343950367-20140806-01   Media: station90-000009
     
127.   SPFILE Included: Modification time: 06-AUG-14
     
128.   SPFILE db_unique_name: ORCL
     
129.   Control File Included: Ckp SCN: 1918038      Ckp time: 06-AUG-14
     
130. 
     
131. RMAN>
     

复制代码

1. [root@station90 ~]# su - oracle
   
2. [oracle@station90 ~]$ . oraenv
   
3. ORACLE_SID = [orcl] ? rcat
   
4. ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome_1
   
5. The Oracle base remains unchanged with value /u01/app/oracle
   
6. [oracle@station90 ~]$ sqlplus /nolog
   
7. 
   
8. SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 19 19:43:12 2014
   
9. 
   
10. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
11. 
    
12. SQL> conn / as sysdba
    
13. Connected to an idle instance.
    
14. SQL> startup
    
15. ORACLE instance started.
    
16. 
    
17. Total System Global Area 1603411968 bytes
    
18. Fixed Size                    2228784 bytes
    
19. Variable Size                  503320016 bytes
    
20. Database Buffers         1090519040 bytes
    
21. Redo Buffers                    7344128 bytes
    
22. Database mounted.
    
23. Database opened.
    
24. SQL> show parameter db_name
    
25. 
    
26. NAME                                     TYPE         VALUE
    
27. ------------------------------------ ----------- ------------------------------
    
28. db_name                              string         rcat
    
29. SQL> select  name from v$datafile;
    
30. 
    
31. NAME
    
32. --------------------------------------------------------------------------------
    
33. /u01/app/oracle/oradata/rcat/system01.dbf
    
34. /u01/app/oracle/oradata/rcat/sysaux01.dbf
    
35. /u01/app/oracle/oradata/rcat/undotbs01.dbf
    
36. /u01/app/oracle/oradata/rcat/users01.dbf
    
37. /u01/app/oracle/oradata/rcat/example01.dbf
    
38. /u01/app/oracle/oradata/rcat/rcat01.dbf
    
39. 
    
40. 6 rows selected.
    
41. 
    
42. SQL> create user u90 identified by oracle_4U  default tablespace rcat  quota unlimited on rcat ;
    
43. create user u90 identified by oracle_4U  default tablespace rcat  quota unlimited on rcat
    
44.             *
    
45. ERROR at line 1:
    
46. ORA-01920: user name 'U90' conflicts with another user or role name
    
47. 
    
48. 
    
49. SQL> grant recovery_catalog_owner to u90;
    
50. 
    
51. Grant succeeded.
    
52. 
    
53. SQL>
    

复制代码