Rman 0级别备份和恢复

  • yewushang

    2014-02-09 20:22:06
  • Oracle
  • 原创

点击(此处)折叠或打开

  1. 1.删除备份
  2. RMAN> delete backup;

  4. using target database control file instead of recovery catalog
  5. allocated channel: ORA_DISK_1
  6. channel ORA_DISK_1: sid=131 devtype=DISK

  8. List of Backup Pieces
  9. BP Key BS Key Pc# Cp# Status Device Type Piece Name
  10. ------- ------- --- --- ----------- ----------- ----------
  11. 3 3 1 1 AVAILABLE DISK /backup/YWS_4.dbf
  12. 4 4 1 1 AVAILABLE DISK /backup/YWS_0.dbf

  14. Do you really want to delete the above objects (enter YES or NO)? yes
  15. deleted backup piece
  16. backup piece handle=/backup/YWS_4.dbf recid=3 stamp=832767718
  17. deleted backup piece
  18. backup piece handle=/backup/YWS_0.dbf recid=4 stamp=832767926
  19. Deleted 2 objects

  21. 2.0级别全备
  22. RMAN> backup incremental level 0 database format \'/backup/%s_%f.dbf\';

  24. Starting backup at 29-NOV-13
  25. using channel ORA_DISK_1
  26. channel ORA_DISK_1: starting incremental level 0 datafile backupset
  27. channel ORA_DISK_1: specifying datafile(s) in backupset
  28. input datafile fno=00001 name=/u01/oracle/oradata/yws/system01.dbf
  29. input datafile fno=00003 name=/u01/oracle/oradata/yws/sysaux01.dbf
  30. input datafile fno=00005 name=/u01/oracle/oradata/yws/example01.dbf
  31. input datafile fno=00002 name=/u01/oracle/oradata/yws/undotbs01.dbf
  32. input datafile fno=00004 name=/u01/oracle/oradata/yws/users01.dbf
  33. channel ORA_DISK_1: starting piece 1 at 29-NOV-13
  34. channel ORA_DISK_1: finished piece 1 at 29-NOV-13
  35. piece handle=/backup/5_4.dbf tag=TAG20131129T122643 comment=NONE
  36. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
  37. channel ORA_DISK_1: starting incremental level 0 datafile backupset
  38. channel ORA_DISK_1: specifying datafile(s) in backupset
  39. including current control file in backupset
  40. including current SPFILE in backupset
  41. channel ORA_DISK_1: starting piece 1 at 29-NOV-13
  42. channel ORA_DISK_1: finished piece 1 at 29-NOV-13
  43. piece handle=/backup/6_0.dbf tag=TAG20131129T122643 comment=NONE
  44. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
  45. Finished backup at 29-NOV-13

  47. 3.查看备份
  48. RMAN> LIST BACKUP OF CONTROLFILE;


  51. List of Backup Sets
  52. ===================

  54. BS Key Type LV Size Device Type Elapsed Time Completion Time
  55. ------- ---- -- ---------- ----------- ------------ ---------------
  56. 6 Incr 0 6.80M DISK 00:00:03 29-NOV-13
  57.         BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
  58.         Piece Name: /backup/6_0.dbf
  59.   Control File Included: Ckp SCN: 482504 Ckp time: 29-NOV-13

  61. RMAN> LIST BACKUP OF SPFILE;


  64. List of Backup Sets
  65. ===================

  67. BS Key Type LV Size Device Type Elapsed Time Completion Time
  68. ------- ---- -- ---------- ----------- ------------ ---------------
  69. 6 Incr 0 6.80M DISK 00:00:03 29-NOV-13
  70.         BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
  71.         Piece Name: /backup/6_0.dbf
  72.   SPFILE Included: Modification time: 29-NOV-13
  73.   
  74.   
  75.   RMAN> list backup;


  78. List of Backup Sets
  79. ===================

  81. BS Key Type LV Size Device Type Elapsed Time Completion Time
  82. ------- ---- -- ---------- ----------- ------------ ---------------
  83. 5 Incr 0 577.39M DISK 00:00:41 29-NOV-13
  84.         BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
  85.         Piece Name: /backup/5_4.dbf
  86.   List of Datafiles in backup set 5
  87.   File LV Type Ckp SCN Ckp Time Name
  88.   ---- -- ---- ---------- --------- ----
  89.   1 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/system01.dbf
  90.   2 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/undotbs01.dbf
  91.   3 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/sysaux01.dbf
  92.   4 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/users01.dbf
  93.   5 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/example01.dbf

  95. BS Key Type LV Size Device Type Elapsed Time Completion Time
  96. ------- ---- -- ---------- ----------- ------------ ---------------
  97. 6 Incr 0 6.80M DISK 00:00:03 29-NOV-13
  98.         BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
  99.         Piece Name: /backup/6_0.dbf
  100.   Control File Included: Ckp SCN: 482504 Ckp time: 29-NOV-13
  101.   SPFILE Included: Modification time: 29-NOV-13
  102.   
  103.   
  104. 4.删除文件
  105. [oracle@yws oracle]$ cd oradata/
  106. [oracle@yws oradata]$ ls
  107. yws
  108. [oracle@yws oradata]$ cd yws/
  109. [oracle@yws yws]$ ls
  110. control01.ctl control02.ctl control03.ctl example01.dbf redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
  111. [oracle@yws yws]$ rm -rf *
  112. [oracle@yws yws]$ ls
  113. [oracle@yws yws]$ ls
  114. [oracle@yws yws]$ pwd
  115. /u01/oracle/oradata/yws

  117. 5.删除归档
  118. RMAN> delete archivelog all;

  120. released channel: ORA_DISK_1
  121. allocated channel: ORA_DISK_1
  122. channel ORA_DISK_1: sid=131 devtype=DISK

  124. List of Archived Log Copies
  125. Key Thrd Seq S Low Time Name
  126. ------- ---- ------- - --------- ----
  127. 1 1 2 A 29-NOV-13 /arc/1_2_832764548.dbf
  128. 2 1 3 A 29-NOV-13 /arc/1_3_832764548.dbf
  129. 3 1 4 A 29-NOV-13 /arc/1_4_832764548.dbf
  130. 4 1 5 A 29-NOV-13 /arc/1_5_832764548.dbf
  131. 5 1 6 A 29-NOV-13 /arc/1_6_832764548.dbf
  132. 6 1 7 A 29-NOV-13 /arc/1_7_832764548.dbf

  134. Do you really want to delete the above objects (enter YES or NO)? yes
  135. deleted archive log
  136. archive log filename=/arc/1_2_832764548.dbf recid=1 stamp=832768513
  137. deleted archive log
  138. archive log filename=/arc/1_3_832764548.dbf recid=2 stamp=832768513
  139. deleted archive log
  140. archive log filename=/arc/1_4_832764548.dbf recid=3 stamp=832768518
  141. deleted archive log
  142. archive log filename=/arc/1_5_832764548.dbf recid=4 stamp=832768569
  143. deleted archive log
  144. archive log filename=/arc/1_6_832764548.dbf recid=5 stamp=832768575
  145. deleted archive log
  146. archive log filename=/arc/1_7_832764548.dbf recid=6 stamp=832768583
  147. Deleted 6 objects

  149. 6.启动数据库
  150. [oracle@yws arc]$ sqlplus / as sysdba

  152. SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 29 12:46:59 2013

  154. Copyright (c) 1982, 2005, Oracle. All rights reserved.

  156. Connected to an idle instance.

  158. SQL> startup
  159. ORACLE instance started.

  161. Total System Global Area 285212672 bytes
  162. Fixed Size 1218992 bytes
  163. Variable Size 79693392 bytes
  164. Database Buffers 201326592 bytes
  165. Redo Buffers 2973696 bytes
  166. ORA-00205: error in identifying control file, check alert log for more info --报找不到控制文件

  168. 7.恢复控制文件
  169. RMAN> restore controlfile from \'/backup/6_0.dbf\';

  171. Starting restore at 29-NOV-13
  172. using target database control file instead of recovery catalog
  173. allocated channel: ORA_DISK_1
  174. channel ORA_DISK_1: sid=155 devtype=DISK

  176. channel ORA_DISK_1: restoring control file
  177. channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
  178. output filename=/u01/oracle/oradata/yws/control01.ctl
  179. output filename=/u01/oracle/oradata/yws/control02.ctl
  180. output filename=/u01/oracle/oradata/yws/control03.ctl
  181. Finished restore at 29-NOV-13

  183. 8.数据库起到mount
  184. SQL> alter database mount;

  186. Database altered.

  188. 9.查看相关信息

  190. SQL> select checkpoint_change#,fuzzy from v$datafile_header;

  192. CHECKPOINT_CHANGE# FUZ
  193. ------------------ ---
  194.             482473 NO
  195.             482473 NO
  196.             482473 NO
  197.             482473 NO
  198.             482473 NO
  199.             
  200.             
  201. SQL> select CHECKPOINT_CHANGE#,OPEN_RESETLOGS,ARCHIVE_CHANGE# from v$database;

  203. CHECKPOINT_CHANGE# OPEN_RESETL ARCHIVE_CHANGE#
  204. ------------------ ----------- ---------------
  205.             479088 REQUIRED 0
  206.             
  207.             


  210. SQL> /

  212.     GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
  213. ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
  214.          1 1 2 52428800 1 NO CURRENT 474499 29-NOV-13
  215.          3 1 1 52428800 1 YES INACTIVE 446075 29-NOV-13
  216.          2 1 0 52428800 1 YES UNUSED 0
  217.          
  218. 10.恢复库
  219. RMAN> restore database;

  221. Starting restore at 29-NOV-13
  222. released channel: ORA_DISK_1
  223. Starting implicit crosscheck backup at 29-NOV-13
  224. allocated channel: ORA_DISK_1
  225. channel ORA_DISK_1: sid=155 devtype=DISK
  226. Crosschecked 1 objects
  227. Finished implicit crosscheck backup at 29-NOV-13

  229. Starting implicit crosscheck copy at 29-NOV-13
  230. using channel ORA_DISK_1
  231. Finished implicit crosscheck copy at 29-NOV-13

  233. searching for all files in the recovery area
  234. cataloging files...
  235. no files cataloged

  237. using channel ORA_DISK_1

  239. channel ORA_DISK_1: starting datafile backupset restore
  240. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  241. restoring datafile 00001 to /u01/oracle/oradata/yws/system01.dbf
  242. restoring datafile 00002 to /u01/oracle/oradata/yws/undotbs01.dbf
  243. restoring datafile 00003 to /u01/oracle/oradata/yws/sysaux01.dbf
  244. restoring datafile 00004 to /u01/oracle/oradata/yws/users01.dbf
  245. restoring datafile 00005 to /u01/oracle/oradata/yws/example01.dbf
  246. channel ORA_DISK_1: reading from backup piece /backup/5_4.dbf
  247. channel ORA_DISK_1: restored backup piece 1
  248. piece handle=/backup/5_4.dbf tag=TAG20131129T122643
  249. channel ORA_DISK_1: restore complete, elapsed time: 00:00:57
  250. Finished restore at 29-NOV-13

  252. RMAN> recover database;

  254. Starting recover at 29-NOV-13
  255. using channel ORA_DISK_1

  257. starting media recovery

  259. unable to find archive log
  260. archive log thread=1 sequence=2
  261. RMAN-00571: ===========================================================
  262. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  263. RMAN-00571: ===========================================================
  264. RMAN-03002: failure of recover command at 11/29/2013 12:53:18
  265. RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 482473 --报错


  268. 11.查看记录
  269. [oracle@yws yws]$ ls
  270. control01.ctl control02.ctl control03.ctl example01.dbf redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf

  272. 12.打开数据库
  273. SQL> alter database open;
  274. alter database open
  275. *
  276. ERROR at line 1:
  277. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  280. SQL> alter database open noresetlogs;
  281. alter database open noresetlogs
  282. *
  283. ERROR at line 1:
  284. ORA-01588: must use RESETLOGS option for database open


  287. SQL> alter database open resetlogs;

  289. Database altered.

  291. SQL> select status from v$datafile;

  293. STATUS
  294. -------
  295. SYSTEM
  296. ONLINE
  297. ONLINE
  298. ONLINE
  299. ONLINE

  301. SQL> select checkpoint_change#,fuzzy from v$datafile_header;

  303. CHECKPOINT_CHANGE# FUZ
  304. ------------------ ---
  305.             482475 YES
  306.             482475 YES
  307.             482475 YES
  308.             482475 YES
  309.             482475 YES

  311. SQL> select CHECKPOINT_CHANGE#,OPEN_RESETLOGS,ARCHIVE_CHANGE# from v$database;

  313. CHECKPOINT_CHANGE# OPEN_RESETL ARCHIVE_CHANGE#
  314. ------------------ ----------- ---------------
  315.             482475 NOT ALLOWED 0

  317. SQL> select * from v$log;

  319.     GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
  320. ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
  321.          1 1 1 52428800 1 NO CURRENT 482474 29-NOV-13
  322.          2 1 0 52428800 1 YES UNUSED 0
  323.          3 1 0 52428800 1 YES UNUSED 0


  326. 看告警
  327. ksdpec: called for event 13740 prior to event group initialization
  328. Starting up ORACLE RDBMS Version: 10.2.0.1.0.
  329. System parameters with non-default values:
  330.   processes = 150
  331.   __shared_pool_size = 71303168
  332.   __large_pool_size = 4194304
  333.   __java_pool_size = 4194304
  334.   __streams_pool_size = 0
  335.   sga_target = 285212672
  336.   control_files = /u01/oracle/oradata/yws/control01.ctl, /u01/oracle/oradata/yws/control02.ctl, /u01/oracle/oradata/yws/control03.ctl
  337.   db_block_size = 8192
  338.   __db_cache_size = 201326592
  339.   compatible = 10.2.0.1.0
  340.   log_archive_dest_1 = location=/arc
  341.   db_file_multiblock_read_count= 16
  342.   db_recovery_file_dest = /u01/oracle/flash_recovery_area
  343.   db_recovery_file_dest_size= 2147483648
  344.   undo_management = AUTO
  345.   undo_tablespace = UNDOTBS1
  346.   remote_login_passwordfile= EXCLUSIVE
  347.   db_domain =
  348.   dispatchers = (PROTOCOL=TCP) (SERVICE=ywsXDB)
  349.   job_queue_processes = 10
  350.   background_dump_dest = /u01/oracle/admin/yws/bdump
  351.   user_dump_dest = /u01/oracle/admin/yws/udump
  352.   core_dump_dest = /u01/oracle/admin/yws/cdump
  353.   audit_file_dest = /u01/oracle/admin/yws/adump
  354.   db_name = yws
  355.   open_cursors = 300
  356.   pga_aggregate_target = 94371840
  357. PMON started with pid=2, OS id=22552
  358. PSP0 started with pid=3, OS id=22554
  359. MMAN started with pid=4, OS id=22556
  360. DBW0 started with pid=5, OS id=22558
  361. LGWR started with pid=6, OS id=22560
  362. CKPT started with pid=7, OS id=22562
  363. SMON started with pid=8, OS id=22564
  364. RECO started with pid=9, OS id=22566
  365. CJQ0 started with pid=10, OS id=22568
  366. MMON started with pid=11, OS id=22570
  367. MMNL started with pid=12, OS id=22572
  368. Fri Nov 29 12:48:42 2013
  369. starting up 1 dispatcher(s) for network address \'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))\'...
  370. starting up 1 shared server(s) ...
  371. Fri Nov 29 12:48:42 2013


  374. Fri Nov 29 12:48:42 2013
  375. starting up 1 dispatcher(s) for network address \'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))\'...
  376. starting up 1 shared server(s) ...
  377. Fri Nov 29 12:48:42 2013
  378. ALTER DATABASE MOUNT


  381. Fri Nov 29 12:48:42 2013
  382. ORA-00202: control file: \'/u01/oracle/oradata/yws/control01.ctl\'
  383. ORA-27037: unable to obtain file status
  384. Linux Error: 2: No such file or directory
  385. Additional information: 3
  386. Fri Nov 29 12:48:45 2013
  387. ORA-205 signalled during: ALTER DATABASE MOUNT...
  388. Fri Nov 29 12:51:09 2013
  389. alter database mount
  390. Fri Nov 29 12:51:13 2013
  391. Setting recovery target incarnation to 2
  392. Fri Nov 29 12:51:13 2013
  393. Successful mount of redo thread 1, with mount id 4198944637
  394. Fri Nov 29 12:51:13 2013
  395. Database mounted in Exclusive Mode
  396. Completed: alter database mount
  397. Fri Nov 29 12:51:48 2013
  398. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  399. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
  400. ORA-01110: data file 1: \'/u01/oracle/oradata/yws/system01.dbf\'
  401. ORA-27037: unable to obtain file status
  402. Linux Error: 2: No such file or directory
  403. Additional information: 3
  404. Fri Nov 29 12:51:48 2013
  405. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  406. ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
  407. ORA-01110: data file 2: \'/u01/oracle/oradata/yws/undotbs01.dbf\'
  408. ORA-27037: unable to obtain file status
  409. Linux Error: 2: No such file or directory
  410. Additional information: 3
  411. Fri Nov 29 12:51:48 2013
  412. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  413. ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
  414. ORA-01110: data file 3: \'/u01/oracle/oradata/yws/sysaux01.dbf\'
  415. ORA-27037: unable to obtain file status
  416. Linux Error: 2: No such file or directory
  417. Additional information: 3


  420. Fri Nov 29 12:51:48 2013
  421. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  422. ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
  423. ORA-01110: data file 4: \'/u01/oracle/oradata/yws/users01.dbf\'
  424. ORA-27037: unable to obtain file status
  425. Linux Error: 2: No such file or directory
  426. Additional information: 3
  427. Fri Nov 29 12:51:48 2013
  428. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  429. ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
  430. ORA-01110: data file 5: \'/u01/oracle/oradata/yws/example01.dbf\'
  431. ORA-27037: unable to obtain file status
  432. Linux Error: 2: No such file or directory
  433. Additional information: 3
  434. Fri Nov 29 12:51:48 2013
  435. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  436. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
  437. ORA-01110: data file 1: \'/u01/oracle/oradata/yws/system01.dbf\'
  438. ORA-27037: unable to obtain file status
  439. Linux Error: 2: No such file or directory
  440. Additional information: 3
  441. Fri Nov 29 12:51:48 2013
  442. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  443. ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
  444. ORA-01110: data file 2: \'/u01/oracle/oradata/yws/undotbs01.dbf\'
  445. ORA-27037: unable to obtain file status
  446. Linux Error: 2: No such file or directory
  447. Additional information: 3
  448. Fri Nov 29 12:51:48 2013
  449. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  450. ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
  451. ORA-01110: data file 3: '/u01/oracle/oradata/yws/sysaux01.dbf'
  452. ORA-27037: unable to obtain file status
  453. Linux Error: 2: No such file or directory
  454. Additional information: 3
  455. Fri Nov 29 12:51:48 2013
  456. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  457. ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
  458. ORA-01110: data file 4: '/u01/oracle/oradata/yws/users01.dbf'
  459. ORA-27037: unable to obtain file status
  460. Linux Error: 2: No such file or directory
  461. Additional information: 3
  462. Fri Nov 29 12:51:48 2013
  463. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  464. ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

  466. ORA-01110: data file 2: '/u01/oracle/oradata/yws/undotbs01.dbf'
  467. ORA-27037: unable to obtain file status
  468. Linux Error: 2: No such file or directory
  469. Additional information: 3
  470. Fri Nov 29 12:51:48 2013
  471. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  472. ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
  473. ORA-01110: data file 3: '/u01/oracle/oradata/yws/sysaux01.dbf'
  474. ORA-27037: unable to obtain file status
  475. Linux Error: 2: No such file or directory
  476. Additional information: 3
  477. Fri Nov 29 12:51:48 2013
  478. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  479. ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
  480. ORA-01110: data file 4: '/u01/oracle/oradata/yws/users01.dbf'
  481. ORA-27037: unable to obtain file status
  482. Linux Error: 2: No such file or directory
  483. Additional information: 3
  484. Fri Nov 29 12:51:48 2013
  485. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  486. ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
  487. ORA-01110: data file 5: '/u01/oracle/oradata/yws/example01.dbf'
  488. ORA-27037: unable to obtain file status
  489. Linux Error: 2: No such file or directory
  490. Additional information: 3



  494. Fri Nov 29 12:51:51 2013
  495. Full restore complete of datafile 4 /u01/oracle/oradata/yws/users01.dbf. Elapsed time: 0:00:00
  496.   checkpoint is 482473
  497. Full restore complete of datafile 2 /u01/oracle/oradata/yws/undotbs01.dbf. Elapsed time: 0:00:04
  498.   checkpoint is 482473
  499. Fri Nov 29 12:52:06 2013
  500. Full restore complete of datafile 5 /u01/oracle/oradata/yws/example01.dbf. Elapsed time: 0:00:14
  501.   checkpoint is 482473
  502. Fri Nov 29 12:52:18 2013
  503. Full restore complete of datafile 3 /u01/oracle/oradata/yws/sysaux01.dbf. Elapsed time: 0:00:28
  504.   checkpoint is 482473
  505. Fri Nov 29 12:52:35 2013
  506. Full restore complete of datafile 1 /u01/oracle/oradata/yws/system01.dbf. Elapsed time: 0:00:44
  507.   checkpoint is 482473
  508. Fri Nov 29 12:53:15 2013
  509. alter database recover datafile list clear
  510. Fri Nov 29 12:53:15 2013
  511. Completed: alter database recover datafile list clear
  512. Fri Nov 29 12:53:15 2013
  513. alter database recover datafile list
  514.  1 , 2 , 3 , 4 , 5
  515. Completed: alter database recover datafile list
  516.  1 , 2 , 3 , 4 , 5
  517. Fri Nov 29 12:53:15 2013
  518. alter database recover if needed
  519.  start until cancel using backup controlfile
  520. Media Recovery Start
  521. ORA-279 signalled during: alter database recover if needed
  522.  start until cancel using backup controlfile
  523. ...
  524. Fri Nov 29 12:53:16 2013
  525. alter database recover cancel
  526. Fri Nov 29 12:53:18 2013
  527. Media Recovery Canceled
  528. Completed: alter database recover cancel
  529. Fri Nov 29 13:03:45 2013
  530. db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
  531. user-specified limit on the amount of space that will be used by this
  532. database for recovery-related files, and does not reflect the amount of
  533. space available in the underlying filesystem or ASM diskgroup.
  534. Fri Nov 29 13:09:25 2013
  535. alter database open
  536. Fri Nov 29 13:09:25 2013
  537. ORA-1589 signalled during: alter database open...
  538. Fri Nov 29 13:09:45 2013
  539. alter database open noresetlogs
  540. Fri Nov 29 13:09:45 2013
  541. ORA-1588 signalled during: alter database open noresetlogs...
  542. Fri Nov 29 13:09:58 2013
  543. alter database open resetlogs
  544. Fri Nov 29 13:09:58 2013
  545. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  546. ORA-00313: open failed for members of log group 1 of thread 1
  547. ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/yws/redo01.log'
  548. ORA-27037: unable to obtain file status
  549. Linux Error: 2: No such file or directory
  550. Additional information: 3
  551. Fri Nov 29 13:09:58 2013
  552. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  553. ORA-00313: open failed for members of log group 1 of thread 1
  554. ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/yws/redo01.log'
  555. ORA-27037: unable to obtain file status
  556. Linux Error: 2: No such file or directory
  557. Additional information: 3
  558. Fri Nov 29 13:09:58 2013
  559. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  560. ORA-00313: open failed for members of log group 2 of thread 1
  561. ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/yws/redo02.log'
  562. ORA-27037: unable to obtain file status
  563. Linux Error: 2: No such file or directory
  564. Additional information: 3
  565. Fri Nov 29 13:09:58 2013
  566. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  567. ORA-00313: open failed for members of log group 2 of thread 1
  568. ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/yws/redo02.log'
  569. ORA-27037: unable to obtain file status
  570. Linux Error: 2: No such file or directory
  571. Additional information: 3
  572. Fri Nov 29 13:09:58 2013
  573. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  574. ORA-00313: open failed for members of log group 3 of thread 1
  575. ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/yws/redo03.log'
  576. ORA-27037: unable to obtain file status
  577. Linux Error: 2: No such file or directory
  578. Additional information: 3
  579. Fri Nov 29 13:09:58 2013
  580. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  581. ORA-00313: open failed for members of log group 3 of thread 1
  582. ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/yws/redo03.log'
  583. ORA-27037: unable to obtain file status
  584. Linux Error: 2: No such file or directory
  585. Additional information: 3
  586. Fri Nov 29 13:09:58 2013
  587. RESETLOGS after incomplete recovery UNTIL CHANGE 482473
  588. Resetting resetlogs activation ID 4198903106 (0xfa462d42)
  589. Fri Nov 29 13:09:58 2013
  590. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  591. ORA-00313: open failed for members of log group 1 of thread 1
  592. ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/yws/redo01.log'
  593. ORA-27037: unable to obtain file status
  594. Linux Error: 2: No such file or directory
  595. Additional information: 3
  596. Fri Nov 29 13:10:00 2013
  597. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  598. ORA-00313: open failed for members of log group 2 of thread 1
  599. ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/yws/redo02.log'
  600. ORA-27037: unable to obtain file status
  601. Linux Error: 2: No such file or directory
  602. Additional information: 3
  603. Fri Nov 29 13:10:02 2013
  604. Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
  605. ORA-00313: open failed for members of log group 3 of thread 1
  606. ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/yws/redo03.log'

  608. ORA-27037: unable to obtain file status
  609. Linux Error: 2: No such file or directory
  610. Additional information: 3
  611. Fri Nov 29 13:10:04 2013
  612. Setting recovery target incarnation to 3
  613. Fri Nov 29 13:10:04 2013
  614. Assigning activation ID 4198944637 (0xfa46cf7d)
  615. LGWR: STARTING ARCH PROCESSES
  616. ARC0 started with pid=19, OS id=23381
  617. ARC1 started with pid=20, OS id=23383
  618. Fri Nov 29 13:10:05 2013
  619. ARC0: Archival started
  620. ARC1: Archival started
  621. LGWR: STARTING ARCH PROCESSES COMPLETE
  622. Fri Nov 29 13:10:05 2013
  623. ARC0: STARTING ARCH PROCESSES
  624. Fri Nov 29 13:10:05 2013
  625. ARC1: Becoming the 'no FAL' ARCH
  626. ARC1: Becoming the 'no SRL' ARCH
  627. Fri Nov 29 13:10:05 2013
  628. Thread 1 opened at log sequence 1
  629.   Current log# 1 seq# 1 mem# 0: /u01/oracle/oradata/yws/redo01.log
  630. Successful open of redo thread 1
  631. Fri Nov 29 13:10:05 2013
  632. ARC2: Archival started
  633. ARC0: STARTING ARCH PROCESSES COMPLETE
  634. ARC0: Becoming the heartbeat ARCH
  635. ARC2 started with pid=21, OS id=23385
  636. Fri Nov 29 13:10:05 2013
  637. MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
  638. Fri Nov 29 13:10:05 2013
  639. SMON: enabling cache recovery
  640. Fri Nov 29 13:10:08 2013
  641. Successfully onlined Undo Tablespace 1.
  642. Dictionary check beginning
  643. Fri Nov 29 13:10:08 2013
  644. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  645. ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
  646. ORA-01110: data file 201: '/u01/oracle/oradata/yws/temp01.dbf'
  647. ORA-27037: unable to obtain file status
  648. Linux Error: 2: No such file or directory
  649. Additional information: 3
  650. Fri Nov 29 13:10:08 2013
  651. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  652. ORA-01186: file 201 failed verification tests
  653. ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
  654. ARC2: Archival started
  655. ARC0: STARTING ARCH PROCESSES COMPLETE
  656. ARC0: Becoming the heartbeat ARCH
  657. ARC2 started with pid=21, OS id=23385
  658. Fri Nov 29 13:10:05 2013
  659. MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
  660. Fri Nov 29 13:10:05 2013
  661. SMON: enabling cache recovery
  662. Fri Nov 29 13:10:08 2013
  663. Successfully onlined Undo Tablespace 1.
  664. Dictionary check beginning
  665. Fri Nov 29 13:10:08 2013
  666. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  667. ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
  668. ORA-01110: data file 201: '/u01/oracle/oradata/yws/temp01.dbf'
  669. ORA-27037: unable to obtain file status
  670. Linux Error: 2: No such file or directory
  671. Additional information: 3
  672. Fri Nov 29 13:10:08 2013
  673. Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
  674. ORA-01186: file 201 failed verification tests
  675. ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
  676. ORA-01110: data file 201: '/u01/oracle/oradata/yws/temp01.dbf'
  677. Fri Nov 29 13:10:08 2013
  678. File 201 not verified due to error ORA-01157
  679. Fri Nov 29 13:10:08 2013
  680. Dictionary check complete
  681. Fri Nov 29 13:10:08 2013
  682. SMON: enabling tx recovery
  683. Fri Nov 29 13:10:08 2013
  684. Re-creating tempfile /u01/oracle/oradata/yws/temp01.dbf
  685. Database Characterset is WE8ISO8859P1
  686. replication_dependency_tracking turned off (no async multimaster replication found)
  687. Starting background process QMNC
  688. QMNC started with pid=22, OS id=23401
  689. Fri Nov 29 13:10:15 2013
  690. LOGSTDBY: Validating controlfile with logical metadata
  691. Fri Nov 29 13:10:15 2013
  692. LOGSTDBY: Validation complete
  693. Completed: alter database open resetlogs
  694. Fri Nov 29 13:16:05 2013
  695. Shutting down archive processes
  696. Fri Nov 29 13:16:10 2013
  697. ARCH shutting down
  698. ARC2: Archival stopped


请使用浏览器的分享功能分享到微信等