课程第8次

botang

在做7b实验之前，要检查：

1. SQL> archive log list
   
2. Database log mode              Archive Mode
   
3. Automatic archival             Enabled
   
4. Archive destination            USE_DB_RECOVERY_FILE_DEST
   
5. Oldest online log sequence     3
   
6. Next log sequence to archive   5
   
7. Current log sequence           5
   
8. SQL> alter system switch logfile;
   
9. 
   
10. System altered.
    
11. 
    
12. SQL> /
    
13. 
    
14. System altered.
    
15. 
    
16. SQL>

复制代码

1. [oracle@station80 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Sat May 25 08:34:46 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1535788302)
   
8. 
   
9. RMAN> list backup of database;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. 
    
13. List of Backup Sets
    
14. ===================
    
15. 
    
16. 
    
17. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
18. ------- ---- -- ---------- ----------- ------------ ---------------
    
19. 3       Full    1.21G      DISK        00:00:29     22-MAY-19
    
20.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20190522T223509
    
21.         Piece Name: +FRA/orcl/backupset/2019_05_22/nnndf0_tag20190522t223509_0.262.1008974111
    
22.   List of Datafiles in backup set 3
    
23.   File LV Type Ckp SCN    Ckp Time  Name
    
24.   ---- -- ---- ---------- --------- ----
    
25.   1       Full 1158892    22-MAY-19 +DATA/orcl/datafile/system.256.1008007421
    
26.   2       Full 1158892    22-MAY-19 +DATA/orcl/datafile/sysaux.257.1008007423
    
27.   3       Full 1158892    22-MAY-19 +DATA/orcl/datafile/undotbs1.258.1008007423
    
28.   4       Full 1158892    22-MAY-19 +DATA/orcl/datafile/users.259.1008007423
    
29.   5       Full 1158892    22-MAY-19 +DATA/orcl/datafile/example.265.1008007585
    
30. 
    
31. RMAN> list copy;
    
32. 
    
33. specification does not match any datafile copy in the repository
    
34. List of Control File Copies
    
35. ===========================
    
36. 
    
37. Key     S Completion Time Ckp SCN    Ckp Time
    
38. ------- - --------------- ---------- ---------------
    
39. 2       A 22-MAY-19       1137125    22-MAY-19
    
40.         Name: /home/oracle/control.f
    
41.         Tag: TAG20190522T212750
    
42. 
    
43. List of Archived Log Copies for database with db_unique_name ORCL
    
44. =====================================================================
    
45. 
    
46. Key     Thrd Seq     S Low Time
    
47. ------- ---- ------- - ---------
    
48. 7       1    3       A 22-MAY-19
    
49.         Name: +FRA/orcl/archivelog/2019_05_24/thread_1_seq_3.264.1009108671
    
50. 
    
51. 8       1    4       A 24-MAY-19
    
52.         Name: +FRA/orcl/archivelog/2019_05_25/thread_1_seq_4.265.1009182043
    
53. 
    
54. 9       1    5       A 25-MAY-19
    
55.         Name: +FRA/orcl/archivelog/2019_05_25/thread_1_seq_5.266.1009182835
    
56. 
    
57. 10      1    6       A 25-MAY-19
    
58.         Name: +FRA/orcl/archivelog/2019_05_25/thread_1_seq_6.267.1009182853
    
59. 
    
60. 
    
61. RMAN>
    

复制代码

1. ASMCMD> cd fra
   
2. ASMCMD> ls
   
3. ORCL/
   
4. ASMCMD> cd orcl
   
5. ASMCMD> ls
   
6. ARCHIVELOG/
   
7. BACKUPSET/
   
8. CONTROLFILE/
   
9. ONLINELOG/
   
10. ASMCMD> cd archivelog
    
11. ASMCMD> ls
    
12. 2019_05_24/
    
13. 2019_05_25/
    
14. ASMCMD> cd 2019_05_25/
    
15. ASMCMD> ls
    
16. thread_1_seq_4.265.1009182043
    
17. ASMCMD> ls
    
18. thread_1_seq_4.265.1009182043
    
19. ASMCMD> pwd
    
20. +fra/orcl/archivelog/2019_05_25
    
21. ASMCMD> ls
    
22. thread_1_seq_4.265.1009182043
    
23. thread_1_seq_5.266.1009182835
    
24. ASMCMD> ls
    
25. thread_1_seq_4.265.1009182043
    
26. thread_1_seq_5.266.1009182835
    
27. thread_1_seq_6.267.1009182853
    
28. ASMCMD>
    

复制代码

服务器进程：

1. SQL> ! ps aux | grep 23703
   
2. oracle    23703  0.0  3.0 1771012 113252 ?      Ss   10:09   0:00 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
   
3. oracle    23766  0.0  0.0 108232  2716 pts/0    S+   10:11   0:00 /bin/bash -c  ps aux | grep 23703
   
4. oracle    23768  0.0  0.0 105440  2080 pts/0    S+   10:11   0:00 grep 23703
   
5. 
   
6. SQL> conn hr/oracle_4U@orcl
   
7. Connected.
   
8. SQL> !ps
   
9.    PID TTY          TIME CMD
   
10. 15176 pts/0    00:00:00 bash
    
11. 21822 pts/0    00:00:00 sqlplus
    
12. 23841 pts/0    00:00:00 ps
    
13. 
    
14. SQL> !ps aux | grep 23840
    
15. oracle    23840  0.1  2.0 1766384 77268 ?       Ss   10:11   0:00 oracleorcl (LOCAL=NO)
    
16. oracle    23860  0.0  0.0 108232  2704 pts/0    S+   10:12   0:00 /bin/bash -c ps aux | grep 23840
    
17. oracle    23862  0.0  0.0 105440  2028 pts/0    S+   10:12   0:00 grep 23840
    

复制代码