ExaGridDba

spool log off defeats rman command line log=

Jul 5th, 2016
205
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.38 KB | None | 0 0
  1. [oracle@stormking cdb12102 rman]$ cat test.rcv
  2. list archivelog all;
  3. spool log off
  4. quit
  5. [oracle@stormking cdb12102 rman]$ rman target / @ test.rcv log=rmanlog.txt
  6. RMAN> 2> 3>
  7. using target database control file instead of recovery catalog
  8. List of Archived Log Copies for database with db_unique_name CDB12102
  9. =====================================================================
  10.  
  11. Key Thrd Seq S Low Time
  12. ------- ---- ------- - --------------
  13. 623 1 601 A 20160213 09:00
  14. Name: +RECO/CDB12102/ARCHIVELOG/2016_03_27/thread_1_seq_601.425.907589637
  15.  
  16. 625 1 602 A 20160213 10:29
  17. Name: +RECO/CDB12102/ARCHIVELOG/2016_03_27/thread_1_seq_602.427.907589649
  18.  
  19. 624 1 603 A 20160213 14:27
  20. Name: +RECO/CDB12102/ARCHIVELOG/2016_03_27/thread_1_seq_603.436.907589743
  21.  
  22.  
  23. Spooling for log turned off
  24.  
  25. Recovery Manager12.1.0.2.0
  26.  
  27. Recovery Manager complete.
  28. [oracle@stormking cdb12102 rman]$ cat rmanlog.txt
  29.  
  30. Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 5 22:27:59 2016
  31.  
  32. Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
  33.  
  34. connected to target database: CDB12102 (DBID=2143414189)
  35.  
  36. RMAN> list archivelog all;
  37. 2> spool log off
  38. 3> quit
  39.  
  40. Fix?
  41. delete "spool log off"
  42.  
  43. [oracle@stormking cdb12102 rman]$ ed test.rcv
  44. 40
  45. /spool/d
  46. w
  47. 26
  48. q
  49.  
  50. [oracle@stormking cdb12102 rman]$ rman target / @ test.rcv log=rmanlog.txt
  51. RMAN> 2>
  52. [oracle@stormking cdb12102 rman]$ cat rmanlog.txt
  53.  
  54. Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 5 22:28:47 2016
  55.  
  56. Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
  57.  
  58. connected to target database: CDB12102 (DBID=2143414189)
  59.  
  60. RMAN> list archivelog all;
  61. 2> quit
  62. using target database control file instead of recovery catalog
  63. List of Archived Log Copies for database with db_unique_name CDB12102
  64. =====================================================================
  65.  
  66. Key Thrd Seq S Low Time
  67. ------- ---- ------- - --------------
  68. 623 1 601 A 20160213 09:00
  69. Name: +RECO/CDB12102/ARCHIVELOG/2016_03_27/thread_1_seq_601.425.907589637
  70.  
  71. 625 1 602 A 20160213 10:29
  72. Name: +RECO/CDB12102/ARCHIVELOG/2016_03_27/thread_1_seq_602.427.907589649
  73.  
  74. 624 1 603 A 20160213 14:27
  75. Name: +RECO/CDB12102/ARCHIVELOG/2016_03_27/thread_1_seq_603.436.907589743
  76.  
  77.  
  78. Recovery Manager complete.
Advertisement
Add Comment
Please, Sign In to add comment