Guest User

Untitled

a guest
Apr 24th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.03 KB | None | 0 0
  1. rman target / nocatalog cmdfile=/oracle/admin/led/rman/LEDlvl0 log=$LOGFILE
  2.  
  3. run {
  4. set command id to 'LED_rman_test';
  5. allocate channel disk1 type disk format '/apps1/backup/%d.LVL0.%s.%t.%p.dbf';
  6. allocate channel disk2 type disk format '/apps2/backup/%d.LVL0.%s.%t.%p.dbf';
  7. allocate channel disk3 type disk format '/apps3/backup/%d.LVL0.%s.%t.%p.dbf';
  8. allocate channel disk5 type disk format '/apps5/backup/%d.LVL0.%s.%t.%p.dbf';
  9. allocate channel disk6 type disk format '/apps6/backup/%d.LVL0.%s.%t.%p.dbf';
  10.  
  11.  
  12. backup incremental level=0 setsize=7000000 database ;
  13. backup (current controlfile format '/apps4/backup/%d.%s.%t.%p.ctl');
  14.  
  15.  
  16. release channel disk1;
  17. release channel disk2;
  18. release channel disk3;
  19. release channel disk5;
  20. release channel disk6;
  21.  
  22. $ rman nocatalog
  23.  
  24. RMAN> connect target sys/********@LED
  25.  
  26. RMAN> startup mount
  27.  
  28. RMAN-06196: Oracle instance started
  29. RMAN-00571: ===========================================================
  30. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  31. RMAN-00571: ===========================================================
  32. RMAN-06003: ORACLE error from target database: ORA-00205: error in identifying controlfile, check alert log for more info
  33. RMAN-06097: text of failing SQL statement: alter database mount
  34. RMAN-06099: error occurred in source file: krmk.pc, line: 4192
  35.  
  36. Tue Apr 24 16:57:04 2018
  37. Starting ORACLE instance (normal)
  38. LICENSE_MAX_SESSION = 0
  39. LICENSE_SESSIONS_WARNING = 0
  40. LICENSE_MAX_USERS = 0
  41. Starting up ORACLE RDBMS Version: 8.1.7.0.0.
  42. System parameters with non-default values:
  43. processes = 150
  44. sessions = 170
  45. timed_statistics = TRUE
  46. event = 10183 trace name context forever, level 1,
  47. 10191 trace name context forever, level 1
  48. shared_pool_size = 400000000
  49. enqueue_resources = 8000
  50. control_files = /oracle/LED/sapdata1/cntrl/cntrlLED.dbf, /oracle/LED/sapdata2/cntrl/cntrlLED.dbf, /oracle/LED/sapdata3/cntrl/cntrlLED.dbf
  51. db_block_buffers = 142000
  52. db_block_size = 8192
  53. db_block_lru_latches = 4
  54. compatible = 8.1.0
  55. log_archive_start = TRUE
  56. log_archive_dest = /oracle/LED/saparch/R3Parch
  57. log_archive_min_succeed_dest= 1
  58. log_buffer = 1048576
  59. log_checkpoint_interval = 300000
  60. log_checkpoint_timeout = 0
  61. db_files = 254
  62. db_file_multiblock_read_count= 8
  63. log_checkpoints_to_alert = TRUE
  64. control_file_record_keep_time= 45
  65. dml_locks = 2500
  66. row_locking = always
  67. replication_dependency_tracking= FALSE
  68. transactions_per_rollback_segment= 20
  69. max_rollback_segments = 400
  70. rollback_segments = PRS_0, PRS_1, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9
  71. transaction_auditing = FALSE
  72. remote_os_authent = TRUE
  73. remote_login_passwordfile= EXCLUSIVE
  74. db_domain = world
  75. audit_trail = TRUE
  76. sort_area_size = 2097152
  77. sort_area_retained_size = 0
  78. db_name = LED
  79. open_cursors = 800
  80. optimizer_mode = choose
  81. optimizer_index_cost_adj = 10
  82. cursor_space_for_time = FALSE
  83. parallel_max_servers = 20
  84. hash_join_enabled = FALSE
  85. background_dump_dest = /oracle/LED/saptrace/background
  86. user_dump_dest = /oracle/LED/saptrace/usertrace
  87. core_dump_dest = /oracle/LED/saptrace/background
  88. PMON started with pid=2
  89. DBW0 started with pid=3
  90. LGWR started with pid=4
  91. CKPT started with pid=5
  92. SMON started with pid=6
  93. RECO started with pid=7
  94. Tue Apr 24 16:57:07 2018
  95. ARCH: STARTING ARCH PROCESSES
  96. ARC0 started with pid=8
  97. Tue Apr 24 16:57:07 2018
  98. ARCH: STARTING ARCH PROCESSES COMPLETE
  99. Tue Apr 24 16:57:07 2018
  100. ARC0: Archival started
  101. Tue Apr 24 16:57:07 2018
  102. alter database mount
  103. Tue Apr 24 16:57:07 2018
  104. ORA-00202: controlfile: '/oracle/LED/sapdata1/cntrl/cntrlLED.dbf'
  105. Tue Apr 24 16:57:10 2018
  106. ORA-205 signalled during: alter database mount...
  107.  
  108. $ oerr ora 205
  109. 00205, 00000, "error in identifying controlfile, check alert log for more info"
  110. // *Cause: The system could not find a controlfile of the specified name and
  111. // size.
  112. // *Action: Check that ALL controlfiles are online and that they are the same
  113. // files that the system created at cold start time.
  114.  
  115. $ ls -l /oracle/LED/sapdata1/cntrl/cntrlLED.dbf /oracle/LED/sapdata2/cntrl/cntrlLED.dbf /oracle/LED/sapdata3/cntrl/cntrlLED.dbf
  116. -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata1/cntrl/cntrlLED.dbf
  117. -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata2/cntrl/cntrlLED.dbf
  118. -rw-r----- 1 oraled dba 29876736 Apr 23 23:19 /oracle/LED/sapdata3/cntrl/cntrlLED.dbf
  119.  
  120. $ rman nocatalog
  121.  
  122. RMAN> connect target sys/********@LED
  123.  
  124. RMAN> startup nomount
  125.  
  126.  
  127. RMAN-06196: Oracle instance started
  128.  
  129. Total System Global Area 1609240736 bytes
  130.  
  131. Fixed Size 73888 bytes
  132. Variable Size 444837888 bytes
  133. Database Buffers 1163264000 bytes
  134. Redo Buffers 1064960 bytes
  135.  
  136. RMAN> run {
  137. 2> allocate channel ch1 type disk;
  138. 3> allocate channel ch2 type disk;
  139. 4> allocate channel ch3 type disk;
  140. 5> allocate channel ch5 type disk;
  141. 6> allocate channel ch6 type disk;
  142. 7>
  143. 8> restore controlfile to '/apps6/backup/jimt.ctl';
  144. 9> }
  145.  
  146. RMAN-03022: compiling command: allocate
  147. RMAN-03023: executing command: allocate
  148. RMAN-08030: allocated channel: ch1
  149. RMAN-08500: channel ch1: sid=10 devtype=DISK
  150.  
  151. RMAN-03022: compiling command: allocate
  152. RMAN-03023: executing command: allocate
  153. RMAN-08030: allocated channel: ch2
  154. RMAN-08500: channel ch2: sid=11 devtype=DISK
  155.  
  156. RMAN-03022: compiling command: allocate
  157. RMAN-03023: executing command: allocate
  158. RMAN-08030: allocated channel: ch3
  159. RMAN-08500: channel ch3: sid=12 devtype=DISK
  160.  
  161. RMAN-03022: compiling command: allocate
  162. RMAN-03023: executing command: allocate
  163. RMAN-08030: allocated channel: ch5
  164. RMAN-08500: channel ch5: sid=13 devtype=DISK
  165.  
  166. RMAN-03022: compiling command: allocate
  167. RMAN-03023: executing command: allocate
  168. RMAN-08030: allocated channel: ch6
  169. RMAN-08500: channel ch6: sid=14 devtype=DISK
  170.  
  171. RMAN-03022: compiling command: restore
  172.  
  173. RMAN-03022: compiling command: IRESTORE
  174. RMAN-03026: error recovery releasing channel resources
  175. RMAN-08031: released channel: ch1
  176. RMAN-08031: released channel: ch2
  177. RMAN-08031: released channel: ch3
  178. RMAN-08031: released channel: ch5
  179. RMAN-08031: released channel: ch6
  180. RMAN-00571: ===========================================================
  181. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  182. RMAN-00571: ===========================================================
  183. RMAN-03002: failure during compilation of command
  184. RMAN-03013: command type: restore
  185. RMAN-03002: failure during compilation of command
  186. RMAN-03013: command type: IRESTORE
  187. RMAN-06003: ORACLE error from target database: ORA-01507: database not mounted
  188. ORA-06512: at "SYS.X$DBMS_RCVMAN", line 4461
  189. ORA-06512: at line 1
  190. RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upper ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ;
  191. RMAN-06099: error occurred in source file: krmk.pc, line: 9196
Add Comment
Please, Sign In to add comment