Bo's Oracle Station

查看: 1002|回复: 0

课程第33/34次(2017-09-16星期六上下午)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-9-16 15:39:02 | 显示全部楼层 |阅读模式
上完1Z0-052第16章/1Z0-053第2章
1Z0-052
19章(上完12章),1Z0-05321章(上完6章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的18

1a实验,对应图形界面上的DRA:

Screenshot.png

  1. [oracle@station90 ~]$ sqlplus /nolog

  2. SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 16 15:22:43 2017

  3. Copyright (c) 1982, 2011, Oracle.  All rights reserved.

  4. SQL> conn / as sysdba
  5. Connected to an idle instance.
  6. SQL> startup
  7. ORACLE instance started.

  8. Total System Global Area 6664212480 bytes
  9. Fixed Size                    2240944 bytes
  10. Variable Size                 3640659536 bytes
  11. Database Buffers         3003121664 bytes
  12. Redo Buffers                   18190336 bytes
  13. Database mounted.
  14. ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
  15. ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.816169553'


  16. SQL> exit
  17. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  18. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  19. and Real Application Testing options
  20. [oracle@station90 ~]$ rman target /

  21. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Sep 16 15:23:09 2017

  22. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  23. connected to target database: ORCL (DBID=1343950367, not open)

  24. RMAN> list failure;

  25. using target database control file instead of recovery catalog
  26. List of Database Failures
  27. =========================

  28. Failure ID Priority Status    Time Detected Summary
  29. ---------- -------- --------- ------------- -------
  30. 482        CRITICAL OPEN      16-SEP-17     System datafile 1: '+DATA/orcl/datafile/system.256.816169553' is missing
  31. 485        HIGH     OPEN      16-SEP-17     One or more non-system datafiles are missing

  32. RMAN> advise failure;

  33. List of Database Failures
  34. =========================

  35. Failure ID Priority Status    Time Detected Summary
  36. ---------- -------- --------- ------------- -------
  37. 482        CRITICAL OPEN      16-SEP-17     System datafile 1: '+DATA/orcl/datafile/system.256.816169553' is missing
  38. 485        HIGH     OPEN      16-SEP-17     One or more non-system datafiles are missing

  39. analyzing automatic repair options; this may take some time
  40. allocated channel: ORA_DISK_1
  41. channel ORA_DISK_1: SID=131 device type=DISK
  42. allocated channel: ORA_DISK_2
  43. channel ORA_DISK_2: SID=192 device type=DISK
  44. allocated channel: ORA_DISK_3
  45. channel ORA_DISK_3: SID=8 device type=DISK
  46. allocated channel: ORA_DISK_4
  47. channel ORA_DISK_4: SID=69 device type=DISK
  48. allocated channel: ORA_DISK_5
  49. channel ORA_DISK_5: SID=132 device type=DISK
  50. allocated channel: ORA_DISK_6
  51. channel ORA_DISK_6: SID=193 device type=DISK
  52. allocated channel: ORA_DISK_7
  53. channel ORA_DISK_7: SID=9 device type=DISK
  54. allocated channel: ORA_DISK_8
  55. channel ORA_DISK_8: SID=70 device type=DISK
  56. allocated channel: ORA_SBT_TAPE_1
  57. channel ORA_SBT_TAPE_1: SID=133 device type=SBT_TAPE
  58. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  59. allocated channel: ORA_SBT_TAPE_2
  60. channel ORA_SBT_TAPE_2: SID=10 device type=SBT_TAPE
  61. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  62. analyzing automatic repair options complete

  63. Mandatory Manual Actions
  64. ========================
  65. 1. If file +DATA/orcl/datafile/system.256.816169553 was unintentionally renamed or moved, restore it
  66. 2. If file +DATA/orcl/datafile/sysaux.257.816169553 was unintentionally renamed or moved, restore it
  67. 3. If file +DATA/orcl/datafile/undotbs1.258.816169553 was unintentionally renamed or moved, restore it
  68. 4. If file +DATA/orcl/datafile/users.259.816169553 was unintentionally renamed or moved, restore it
  69. 5. If file +DATA/orcl/datafile/example.265.816169651 was unintentionally renamed or moved, restore it
  70. 6. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair

  71. Optional Manual Actions
  72. =======================
  73. no manual actions available

  74. Automated Repair Options
  75. ========================
  76. no automatic repair options available

  77. RMAN> restore database;

  78. Starting restore at 16-SEP-17
  79. using channel ORA_DISK_1
  80. using channel ORA_DISK_2
  81. using channel ORA_DISK_3
  82. using channel ORA_DISK_4
  83. using channel ORA_DISK_5
  84. using channel ORA_DISK_6
  85. using channel ORA_DISK_7
  86. using channel ORA_DISK_8
  87. using channel ORA_SBT_TAPE_1
  88. using channel ORA_SBT_TAPE_2

  89. channel ORA_SBT_TAPE_1: starting datafile backup set restore
  90. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
  91. channel ORA_SBT_TAPE_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.816169553
  92. channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.816169651
  93. channel ORA_SBT_TAPE_1: reading from backup piece 1ls4tgjd_1_1
  94. channel ORA_SBT_TAPE_2: starting datafile backup set restore
  95. channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
  96. channel ORA_SBT_TAPE_2: restoring datafile 00001 to +DATA/orcl/datafile/system.256.816169553
  97. channel ORA_SBT_TAPE_2: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.816169553
  98. channel ORA_SBT_TAPE_2: restoring datafile 00004 to +DATA/orcl/datafile/users.259.816169553
  99. channel ORA_SBT_TAPE_2: reading from backup piece 1ks4tgjd_1_1
  100. channel ORA_SBT_TAPE_1: piece handle=1ls4tgjd_1_1 tag=0T_INCR0_WHOLE
  101. channel ORA_SBT_TAPE_1: restored backup piece 1
  102. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
  103. channel ORA_SBT_TAPE_2: piece handle=1ks4tgjd_1_1 tag=0T_INCR0_WHOLE
  104. channel ORA_SBT_TAPE_2: restored backup piece 1
  105. channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:00:55
  106. Finished restore at 16-SEP-17

  107. RMAN> list failure;

  108. no failures found that match specification

  109. RMAN> alter database open ;

  110. RMAN-00571: ===========================================================
  111. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  112. RMAN-00571: ===========================================================
  113. RMAN-03002: failure of alter db command at 09/16/2017 15:27:36
  114. ORA-01113: file 1 needs media recovery
  115. ORA-01110: data file 1: '+DATA/orcl/datafile/system.257.954861995'

  116. RMAN> list failure;

  117. no failures found that match specification

  118. RMAN> list failure all;

  119. no failures found that match specification

  120. RMAN> list failure ;

  121. no failures found that match specification

  122. RMAN> recover database;

  123. Starting recover at 16-SEP-17
  124. using channel ORA_DISK_1
  125. using channel ORA_DISK_2
  126. using channel ORA_DISK_3
  127. using channel ORA_DISK_4
  128. using channel ORA_DISK_5
  129. using channel ORA_DISK_6
  130. using channel ORA_DISK_7
  131. using channel ORA_DISK_8
  132. using channel ORA_SBT_TAPE_1
  133. using channel ORA_SBT_TAPE_2

  134. starting media recovery

  135. archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765
  136. archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333
  137. archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887
  138. archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455
  139. archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455
  140. archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467
  141. archived log for thread 1 with sequence 115 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_115.326.954861469
  142. archived log for thread 1 with sequence 116 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_116.325.954861473
  143. RMAN-00571: ===========================================================
  144. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  145. RMAN-00571: ===========================================================
  146. RMAN-03002: failure of recover command at 09/16/2017 15:28:19
  147. RMAN-06053: unable to perform media recovery because of missing log
  148. RMAN-06025: no backup of archived log for thread 1 with sequence 114 and starting SCN of 2101539 found to restore

  149. RMAN> list failure ;

  150. no failures found that match specification

  151. RMAN> run {
  152. 2> set until sequence 114 thread 1;
  153. 3> recover database;
  154. 4> }

  155. executing command: SET until clause

  156. Starting recover at 16-SEP-17
  157. using channel ORA_DISK_1
  158. using channel ORA_DISK_2
  159. using channel ORA_DISK_3
  160. using channel ORA_DISK_4
  161. using channel ORA_DISK_5
  162. using channel ORA_DISK_6
  163. using channel ORA_DISK_7
  164. using channel ORA_DISK_8
  165. using channel ORA_SBT_TAPE_1
  166. using channel ORA_SBT_TAPE_2

  167. starting media recovery

  168. archived log for thread 1 with sequence 108 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765
  169. archived log for thread 1 with sequence 109 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333
  170. archived log for thread 1 with sequence 110 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887
  171. archived log for thread 1 with sequence 111 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455
  172. archived log for thread 1 with sequence 112 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455
  173. archived log for thread 1 with sequence 113 is already on disk as file +FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467
  174. channel ORA_SBT_TAPE_1: starting archived log restore to default destination
  175. channel ORA_SBT_TAPE_1: restoring archived log
  176. archived log thread=1 sequence=107
  177. channel ORA_SBT_TAPE_1: reading from backup piece 1ms4tgk7_1_1
  178. channel ORA_SBT_TAPE_1: piece handle=1ms4tgk7_1_1 tag=0T_INCR0_WHOLE
  179. channel ORA_SBT_TAPE_1: restored backup piece 1
  180. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:33
  181. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_107.327.954862151 thread=1 sequence=107
  182. channel default: deleting archived log(s)
  183. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_107.327.954862151 RECID=109 STAMP=954862150
  184. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765 thread=1 sequence=108
  185. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333 thread=1 sequence=109
  186. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887 thread=1 sequence=110
  187. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455 thread=1 sequence=111
  188. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455 thread=1 sequence=112
  189. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467 thread=1 sequence=113
  190. media recovery complete, elapsed time: 00:00:04
  191. Finished recover at 16-SEP-17

  192. RMAN> list failure ;

  193. no failures found that match specification

  194. RMAN> alter database open ;

  195. RMAN-00571: ===========================================================
  196. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  197. RMAN-00571: ===========================================================
  198. RMAN-03002: failure of alter db command at 09/16/2017 15:29:37
  199. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

  200. RMAN> alter database open  RESETLOGS;

  201. database opened

  202. RMAN> list failure;

  203. no failures found that match specification

  204. RMAN> list failure;

  205. no failures found that match specification

  206. RMAN> list failure;

  207. no failures found that match specification

  208. RMAN> list failure;

  209. no failures found that match specification

  210. RMAN> list failure;

  211. no failures found that match specification

  212. RMAN> list failure;

  213. no failures found that match specification

  214. RMAN> list failure;

  215. no failures found that match specification

  216. RMAN> list failure;

  217. no failures found that match specification

  218. RMAN> list failure;

  219. no failures found that match specification

  220. RMAN> list failure;

  221. no failures found that match specification

  222. RMAN> list failure;

  223. no failures found that match specification

  224. RMAN> list failure;

  225. no failures found that match specification

  226. RMAN> list failure;

  227. List of Database Failures
  228. =========================

  229. Failure ID Priority Status    Time Detected Summary
  230. ---------- -------- --------- ------------- -------
  231. 561        HIGH     OPEN      16-SEP-17     Tablespace 4: 'USERS' is offline
  232. 485        HIGH     OPEN      16-SEP-17     One or more non-system datafiles are missing

  233. RMAN> advise failure;

  234. List of Database Failures
  235. =========================

  236. Failure ID Priority Status    Time Detected Summary
  237. ---------- -------- --------- ------------- -------
  238. 561        HIGH     OPEN      16-SEP-17     Tablespace 4: 'USERS' is offline
  239. 485        HIGH     OPEN      16-SEP-17     One or more non-system datafiles are missing

  240. analyzing automatic repair options; this may take some time
  241. using channel ORA_DISK_1
  242. using channel ORA_DISK_2
  243. using channel ORA_DISK_3
  244. using channel ORA_DISK_4
  245. using channel ORA_DISK_5
  246. using channel ORA_DISK_6
  247. using channel ORA_DISK_7
  248. using channel ORA_DISK_8
  249. using channel ORA_SBT_TAPE_1
  250. using channel ORA_SBT_TAPE_2
  251. analyzing automatic repair options complete

  252. Not all specified failures can currently be repaired.
  253. The following failures must be repaired before advise for others can be given.

  254. Failure ID Priority Status    Time Detected Summary
  255. ---------- -------- --------- ------------- -------
  256. 485        HIGH     OPEN      16-SEP-17     One or more non-system datafiles are missing

  257. Mandatory Manual Actions
  258. ========================
  259. no manual actions available

  260. Optional Manual Actions
  261. =======================
  262. 1. If file +DATA/orcl/datafile/users.256.954861995 was unintentionally renamed or moved, restore it

  263. Automated Repair Options
  264. ========================
  265. Option Repair Description
  266. ------ ------------------
  267. 1      Restore and recover datafile 4  
  268.   Strategy: The repair includes complete media recovery with no data loss
  269.   Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1239215094.hm

  270. RMAN> repair  failure preview;

  271. Strategy: The repair includes complete media recovery with no data loss
  272. Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1239215094.hm

  273. contents of repair script:
  274.    # restore and recover datafile
  275.    sql 'alter database datafile 4 offline';
  276.    restore datafile 4;
  277.    recover datafile 4;
  278.    sql 'alter database datafile 4 online';

  279. RMAN> list failure;

  280. no failures found that match specification

  281. RMAN> list failure;

  282. List of Database Failures
  283. =========================

  284. Failure ID Priority Status    Time Detected Summary
  285. ---------- -------- --------- ------------- -------
  286. 561        HIGH     OPEN      16-SEP-17     Tablespace 4: 'USERS' is offline
  287. 485        HIGH     OPEN      16-SEP-17     One or more non-system datafiles are missing

  288. RMAN> show all;

  289. RMAN configuration parameters for database with db_unique_name ORCL are:
  290. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  291. CONFIGURE BACKUP OPTIMIZATION ON;
  292. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  293. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  294. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  295. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  296. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  297. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  298. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  299. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  300. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  301. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  302. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  303. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  304. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  305. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  306. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  307. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  308. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  309. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  310. RMAN> delete noprompt backup;

  311. using channel ORA_DISK_1
  312. using channel ORA_DISK_2
  313. using channel ORA_DISK_3
  314. using channel ORA_DISK_4
  315. using channel ORA_DISK_5
  316. using channel ORA_DISK_6
  317. using channel ORA_DISK_7
  318. using channel ORA_DISK_8
  319. using channel ORA_SBT_TAPE_1
  320. using channel ORA_SBT_TAPE_2

  321. List of Backup Pieces
  322. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
  323. ------- ------- --- --- ----------- ----------- ----------
  324. 51      51      1   1   AVAILABLE   SBT_TAPE    1js4tgij_1_1
  325. 52      52      1   1   AVAILABLE   SBT_TAPE    1ls4tgjd_1_1
  326. 53      53      1   1   AVAILABLE   SBT_TAPE    1ks4tgjd_1_1
  327. 54      54      1   1   AVAILABLE   SBT_TAPE    1ms4tgk7_1_1
  328. 55      55      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20170522-00
  329. 56      56      1   1   AVAILABLE   DISK        +FRA/orcl/autobackup/2017_09_16/s_954862192.324.954862193
  330. 57      57      1   1   AVAILABLE   DISK        +FRA/orcl/autobackup/2017_09_16/s_954862677.317.954862679
  331. deleted backup piece
  332. backup piece handle=+FRA/orcl/autobackup/2017_09_16/s_954862192.324.954862193 RECID=56 STAMP=954862193
  333. deleted backup piece
  334. backup piece handle=+FRA/orcl/autobackup/2017_09_16/s_954862677.317.954862679 RECID=57 STAMP=954862677
  335. Deleted 2 objects

  336. deleted backup piece
  337. backup piece handle=1js4tgij_1_1 RECID=51 STAMP=944685651
  338. deleted backup piece
  339. backup piece handle=1ls4tgjd_1_1 RECID=52 STAMP=944685678
  340. deleted backup piece
  341. backup piece handle=1ks4tgjd_1_1 RECID=53 STAMP=944685677
  342. deleted backup piece
  343. backup piece handle=1ms4tgk7_1_1 RECID=54 STAMP=944685703
  344. deleted backup piece
  345. backup piece handle=c-1343950367-20170522-00 RECID=55 STAMP=944685728
  346. Deleted 5 objects


  347. RMAN> list backup;

  348. specification does not match any backup in the repository

  349. RMAN> delete noprompt copy;

  350. released channel: ORA_DISK_1
  351. released channel: ORA_DISK_2
  352. released channel: ORA_DISK_3
  353. released channel: ORA_DISK_4
  354. released channel: ORA_DISK_5
  355. released channel: ORA_DISK_6
  356. released channel: ORA_DISK_7
  357. released channel: ORA_DISK_8
  358. released channel: ORA_SBT_TAPE_1
  359. released channel: ORA_SBT_TAPE_2
  360. allocated channel: ORA_DISK_1
  361. channel ORA_DISK_1: SID=131 device type=DISK
  362. allocated channel: ORA_DISK_2
  363. channel ORA_DISK_2: SID=192 device type=DISK
  364. allocated channel: ORA_DISK_3
  365. channel ORA_DISK_3: SID=8 device type=DISK
  366. allocated channel: ORA_DISK_4
  367. channel ORA_DISK_4: SID=69 device type=DISK
  368. allocated channel: ORA_DISK_5
  369. channel ORA_DISK_5: SID=132 device type=DISK
  370. allocated channel: ORA_DISK_6
  371. channel ORA_DISK_6: SID=193 device type=DISK
  372. allocated channel: ORA_DISK_7
  373. channel ORA_DISK_7: SID=9 device type=DISK
  374. allocated channel: ORA_DISK_8
  375. channel ORA_DISK_8: SID=70 device type=DISK
  376. specification does not match any datafile copy in the repository
  377. specification does not match any control file copy in the repository
  378. List of Archived Log Copies for database with db_unique_name ORCL
  379. =====================================================================

  380. Key     Thrd Seq     S Low Time
  381. ------- ---- ------- - ---------
  382. 100     1    108     A 22-MAY-17
  383.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765

  384. 101     1    109     A 16-SEP-17
  385.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333

  386. 102     1    110     A 16-SEP-17
  387.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887

  388. 103     1    111     A 16-SEP-17
  389.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455

  390. 104     1    112     A 16-SEP-17
  391.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455

  392. 105     1    113     A 16-SEP-17
  393.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467

  394. 106     1    114     A 16-SEP-17
  395.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469

  396. 107     1    115     A 16-SEP-17
  397.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_115.326.954861469

  398. 108     1    116     A 16-SEP-17
  399.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_116.325.954861473

  400. 110     1    117     A 16-SEP-17
  401.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_117.327.954862185

  402. 111     1    1       A 16-SEP-17
  403.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_1.323.954862277

  404. 112     1    2       A 16-SEP-17
  405.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_2.322.954862277

  406. 113     1    3       A 16-SEP-17
  407.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_3.321.954862279

  408. 114     1    4       A 16-SEP-17
  409.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_4.320.954862279

  410. 115     1    5       A 16-SEP-17
  411.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_5.319.954862283

  412. 116     1    6       A 16-SEP-17
  413.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_6.318.954862285

  414. deleted archived log
  415. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_108.330.954849765 RECID=100 STAMP=954849764
  416. deleted archived log
  417. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_109.331.954850333 RECID=101 STAMP=954850333
  418. deleted archived log
  419. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_110.329.954850887 RECID=102 STAMP=954850886
  420. deleted archived log
  421. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_111.332.954861455 RECID=103 STAMP=954861454
  422. deleted archived log
  423. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_112.333.954861455 RECID=104 STAMP=954861454
  424. deleted archived log
  425. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_113.328.954861467 RECID=105 STAMP=954861466
  426. deleted archived log
  427. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_115.326.954861469 RECID=107 STAMP=954861469
  428. deleted archived log
  429. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_116.325.954861473 RECID=108 STAMP=954861472
  430. deleted archived log
  431. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_117.327.954862185 RECID=110 STAMP=954862185
  432. deleted archived log
  433. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_1.323.954862277 RECID=111 STAMP=954862277
  434. deleted archived log
  435. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_2.322.954862277 RECID=112 STAMP=954862277
  436. deleted archived log
  437. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_3.321.954862279 RECID=113 STAMP=954862279
  438. deleted archived log
  439. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_4.320.954862279 RECID=114 STAMP=954862279
  440. deleted archived log
  441. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_5.319.954862283 RECID=115 STAMP=954862283
  442. deleted archived log
  443. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_6.318.954862285 RECID=116 STAMP=954862285
  444. Deleted 15 objects


  445. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
  446. RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
  447. RMAN-06210: List of Mismatched objects
  448. RMAN-06211: ==========================
  449. RMAN-06212:   Object Type   Filename/Handle
  450. RMAN-06213: --------------- ---------------------------------------------------
  451. RMAN-06214: Archivelog      +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  452. RMAN> list copy;

  453. specification does not match any datafile copy in the repository
  454. specification does not match any control file copy in the repository
  455. List of Archived Log Copies for database with db_unique_name ORCL
  456. =====================================================================

  457. Key     Thrd Seq     S Low Time
  458. ------- ---- ------- - ---------
  459. 106     1    114     A 16-SEP-17
  460.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  461. RMAN> delete noprompt copy;

  462. released channel: ORA_DISK_1
  463. released channel: ORA_DISK_2
  464. released channel: ORA_DISK_3
  465. released channel: ORA_DISK_4
  466. released channel: ORA_DISK_5
  467. released channel: ORA_DISK_6
  468. released channel: ORA_DISK_7
  469. released channel: ORA_DISK_8
  470. allocated channel: ORA_DISK_1
  471. channel ORA_DISK_1: SID=131 device type=DISK
  472. allocated channel: ORA_DISK_2
  473. channel ORA_DISK_2: SID=192 device type=DISK
  474. allocated channel: ORA_DISK_3
  475. channel ORA_DISK_3: SID=8 device type=DISK
  476. allocated channel: ORA_DISK_4
  477. channel ORA_DISK_4: SID=69 device type=DISK
  478. allocated channel: ORA_DISK_5
  479. channel ORA_DISK_5: SID=132 device type=DISK
  480. allocated channel: ORA_DISK_6
  481. channel ORA_DISK_6: SID=193 device type=DISK
  482. allocated channel: ORA_DISK_7
  483. channel ORA_DISK_7: SID=9 device type=DISK
  484. allocated channel: ORA_DISK_8
  485. channel ORA_DISK_8: SID=70 device type=DISK
  486. specification does not match any datafile copy in the repository
  487. specification does not match any control file copy in the repository
  488. List of Archived Log Copies for database with db_unique_name ORCL
  489. =====================================================================

  490. Key     Thrd Seq     S Low Time
  491. ------- ---- ------- - ---------
  492. 106     1    114     A 16-SEP-17
  493.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  494. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
  495. RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
  496. RMAN-06210: List of Mismatched objects
  497. RMAN-06211: ==========================
  498. RMAN-06212:   Object Type   Filename/Handle
  499. RMAN-06213: --------------- ---------------------------------------------------
  500. RMAN-06214: Archivelog      +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  501. RMAN> list backup;

  502. specification does not match any backup in the repository

  503. RMAN> list copy;

  504. specification does not match any datafile copy in the repository
  505. specification does not match any control file copy in the repository
  506. List of Archived Log Copies for database with db_unique_name ORCL
  507. =====================================================================

  508. Key     Thrd Seq     S Low Time
  509. ------- ---- ------- - ---------
  510. 106     1    114     A 16-SEP-17
  511.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  512. RMAN> crosscheck copy;

  513. released channel: ORA_DISK_1
  514. released channel: ORA_DISK_2
  515. released channel: ORA_DISK_3
  516. released channel: ORA_DISK_4
  517. released channel: ORA_DISK_5
  518. released channel: ORA_DISK_6
  519. released channel: ORA_DISK_7
  520. released channel: ORA_DISK_8
  521. allocated channel: ORA_DISK_1
  522. channel ORA_DISK_1: SID=131 device type=DISK
  523. allocated channel: ORA_DISK_2
  524. channel ORA_DISK_2: SID=192 device type=DISK
  525. allocated channel: ORA_DISK_3
  526. channel ORA_DISK_3: SID=8 device type=DISK
  527. allocated channel: ORA_DISK_4
  528. channel ORA_DISK_4: SID=69 device type=DISK
  529. allocated channel: ORA_DISK_5
  530. channel ORA_DISK_5: SID=132 device type=DISK
  531. allocated channel: ORA_DISK_6
  532. channel ORA_DISK_6: SID=193 device type=DISK
  533. allocated channel: ORA_DISK_7
  534. channel ORA_DISK_7: SID=9 device type=DISK
  535. allocated channel: ORA_DISK_8
  536. channel ORA_DISK_8: SID=70 device type=DISK
  537. specification does not match any datafile copy in the repository
  538. specification does not match any control file copy in the repository
  539. validation failed for archived log
  540. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469 RECID=106 STAMP=954861468
  541. Crosschecked 1 objects


  542. RMAN> list copy;

  543. specification does not match any datafile copy in the repository
  544. specification does not match any control file copy in the repository
  545. List of Archived Log Copies for database with db_unique_name ORCL
  546. =====================================================================

  547. Key     Thrd Seq     S Low Time
  548. ------- ---- ------- - ---------
  549. 106     1    114     X 16-SEP-17
  550.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  551. RMAN> delete expired copy;

  552. released channel: ORA_DISK_1
  553. released channel: ORA_DISK_2
  554. released channel: ORA_DISK_3
  555. released channel: ORA_DISK_4
  556. released channel: ORA_DISK_5
  557. released channel: ORA_DISK_6
  558. released channel: ORA_DISK_7
  559. released channel: ORA_DISK_8
  560. allocated channel: ORA_DISK_1
  561. channel ORA_DISK_1: SID=131 device type=DISK
  562. allocated channel: ORA_DISK_2
  563. channel ORA_DISK_2: SID=192 device type=DISK
  564. allocated channel: ORA_DISK_3
  565. channel ORA_DISK_3: SID=8 device type=DISK
  566. allocated channel: ORA_DISK_4
  567. channel ORA_DISK_4: SID=69 device type=DISK
  568. allocated channel: ORA_DISK_5
  569. channel ORA_DISK_5: SID=132 device type=DISK
  570. allocated channel: ORA_DISK_6
  571. channel ORA_DISK_6: SID=193 device type=DISK
  572. allocated channel: ORA_DISK_7
  573. channel ORA_DISK_7: SID=9 device type=DISK
  574. allocated channel: ORA_DISK_8
  575. channel ORA_DISK_8: SID=70 device type=DISK
  576. specification does not match any datafile copy in the repository
  577. specification does not match any control file copy in the repository
  578. List of Archived Log Copies for database with db_unique_name ORCL
  579. =====================================================================

  580. Key     Thrd Seq     S Low Time
  581. ------- ---- ------- - ---------
  582. 106     1    114     X 16-SEP-17
  583.         Name: +FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469


  584. Do you really want to delete the above objects (enter YES or NO)? YES
  585. deleted archived log
  586. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_114.327.954861469 RECID=106 STAMP=954861468
  587. Deleted 1 EXPIRED objects


  588. RMAN> list copy;

  589. specification does not match any datafile copy in the repository
  590. specification does not match any control file copy in the repository
  591. specification does not match any archived log in the repository

  592. RMAN> exit


  593. Recovery Manager complete.
  594. [oracle@station90 ~]$ echo $NLS_DATE_FORMAT

  595. [oracle@station90 ~]$ vim .bash_profile
  596. [oracle@station90 ~]$ . .bash_profile
  597. [oracle@station90 ~]$ echo $NLS_DATE_FORMAT
  598. YYYY-MM-DD:HH24:MI:SS
  599. [oracle@station90 ~]$ rman target /

  600. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Sep 16 15:54:31 2017

  601. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  602. connected to target database: ORCL (DBID=1343950367)

  603. RMAN> show all;

  604. using target database control file instead of recovery catalog
  605. RMAN configuration parameters for database with db_unique_name ORCL are:
  606. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  607. CONFIGURE BACKUP OPTIMIZATION ON;
  608. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  609. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  610. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  611. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  612. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  613. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  614. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  615. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  616. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  617. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  618. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  619. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  620. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  621. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  622. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  623. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  624. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  625. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  626. RMAN> backup tag '1T_INCR0_WHOLE' incremental level 0 database  plus archivelog delete all input;  


  627. Starting backup at 2017-09-16:15:57:01
  628. current log archived
  629. allocated channel: ORA_SBT_TAPE_1
  630. channel ORA_SBT_TAPE_1: SID=71 device type=SBT_TAPE
  631. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  632. allocated channel: ORA_SBT_TAPE_2
  633. channel ORA_SBT_TAPE_2: SID=147 device type=SBT_TAPE
  634. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  635. channel ORA_SBT_TAPE_1: starting archived log backup set
  636. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  637. input archived log thread=1 sequence=7 RECID=118 STAMP=954863821
  638. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-16:15:57:13
  639. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-16:15:57:38
  640. piece handle=1rsek46p_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  641. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  642. channel ORA_SBT_TAPE_1: deleting archived log(s)
  643. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_7.319.954863821 RECID=118 STAMP=954863821
  644. Finished backup at 2017-09-16:15:57:38

  645. Starting backup at 2017-09-16:15:57:38
  646. using channel ORA_SBT_TAPE_1
  647. using channel ORA_SBT_TAPE_2
  648. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  649. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  650. input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
  651. input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
  652. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
  653. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-16:15:57:38
  654. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  655. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  656. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
  657. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
  658. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-16:15:57:39
  659. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-16:15:58:14
  660. piece handle=1ssek47i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  661. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
  662. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-16:15:58:14
  663. piece handle=1tsek47i_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  664. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
  665. Finished backup at 2017-09-16:15:58:14

  666. Starting backup at 2017-09-16:15:58:14
  667. current log archived
  668. using channel ORA_SBT_TAPE_1
  669. using channel ORA_SBT_TAPE_2
  670. channel ORA_SBT_TAPE_1: starting archived log backup set
  671. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  672. input archived log thread=1 sequence=8 RECID=119 STAMP=954863894
  673. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-16:15:58:14
  674. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-16:15:58:33
  675. piece handle=1usek48m_1_1 tag=1T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  676. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:19
  677. channel ORA_SBT_TAPE_1: deleting archived log(s)
  678. archived log file name=+FRA/orcl/archivelog/2017_09_16/thread_1_seq_8.319.954863895 RECID=119 STAMP=954863894
  679. Finished backup at 2017-09-16:15:58:33

  680. Starting Control File and SPFILE Autobackup at 2017-09-16:15:58:34
  681. piece handle=c-1343950367-20170916-03 comment=API Version 2.0,MMS Version 10.4.0.4
  682. Finished Control File and SPFILE Autobackup at 2017-09-16:15:58:59

  683. RMAN> list backup;


  684. List of Backup Sets
  685. ===================


  686. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  687. ------- ---- -- ---------- ----------- ------------ -------------------
  688. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  689.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  690.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  691.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  692.   SPFILE db_unique_name: ORCL
  693.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  694. BS Key  Size       Device Type Elapsed Time Completion Time   
  695. ------- ---------- ----------- ------------ -------------------
  696. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  697.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  698.         Handle: 1rsek46p_1_1   Media: station90-000003

  699.   List of Archived Logs in backup set 59
  700.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  701.   ---- ------- ---------- ------------------- ---------- ---------
  702.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  703. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  704. ------- ---- -- ---------- ----------- ------------ -------------------
  705. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  706.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  707.         Handle: 1tsek47i_1_1   Media: station90-000004
  708.   List of Datafiles in backup set 60
  709.   File LV Type Ckp SCN    Ckp Time            Name
  710.   ---- -- ---- ---------- ------------------- ----
  711.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  712.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  713. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  714. ------- ---- -- ---------- ----------- ------------ -------------------
  715. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  716.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  717.         Handle: 1ssek47i_1_1   Media: station90-000003
  718.   List of Datafiles in backup set 61
  719.   File LV Type Ckp SCN    Ckp Time            Name
  720.   ---- -- ---- ---------- ------------------- ----
  721.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  722.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  723.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  724. BS Key  Size       Device Type Elapsed Time Completion Time   
  725. ------- ---------- ----------- ------------ -------------------
  726. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  727.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  728.         Handle: 1usek48m_1_1   Media: station90-000003

  729.   List of Archived Logs in backup set 62
  730.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  731.   ---- ------- ---------- ------------------- ---------- ---------
  732.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  733. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  734. ------- ---- -- ---------- ----------- ------------ -------------------
  735. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  736.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  737.         Handle: c-1343950367-20170916-03   Media: station90-000003
  738.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  739.   SPFILE db_unique_name: ORCL
  740.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  741. RMAN> exit


  742. Recovery Manager complete.
  743. [oracle@station90 ~]$ rman target /

  744. Recovery Manager: Release 11.2.0.3.0 - Production on Sun Sep 17 16:00:50 2017

  745. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  746. connected to target database: ORCL (DBID=1343950367)

  747. RMAN> backup tag '2T_INCR0_WHOLE' incremental level 0 database  plus archivelog delete all input;  


  748. Starting backup at 2017-09-17:16:01:14
  749. current log archived
  750. using target database control file instead of recovery catalog
  751. allocated channel: ORA_SBT_TAPE_1
  752. channel ORA_SBT_TAPE_1: SID=14 device type=SBT_TAPE
  753. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  754. allocated channel: ORA_SBT_TAPE_2
  755. channel ORA_SBT_TAPE_2: SID=16 device type=SBT_TAPE
  756. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  757. channel ORA_SBT_TAPE_1: starting archived log backup set
  758. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  759. input archived log thread=1 sequence=9 RECID=120 STAMP=954950475
  760. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-17:16:01:27
  761. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-17:16:01:52
  762. piece handle=20semoqn_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  763. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  764. channel ORA_SBT_TAPE_1: deleting archived log(s)
  765. archived log file name=+FRA/orcl/archivelog/2017_09_17/thread_1_seq_9.319.954950475 RECID=120 STAMP=954950475
  766. Finished backup at 2017-09-17:16:01:52

  767. Starting backup at 2017-09-17:16:01:52
  768. using channel ORA_SBT_TAPE_1
  769. using channel ORA_SBT_TAPE_2
  770. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  771. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  772. input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
  773. input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
  774. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
  775. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-17:16:01:52
  776. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  777. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  778. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
  779. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
  780. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-17:16:01:52
  781. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-17:16:02:27
  782. piece handle=21semorg_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  783. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
  784. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-17:16:02:27
  785. piece handle=22semorg_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  786. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
  787. Finished backup at 2017-09-17:16:02:27

  788. Starting backup at 2017-09-17:16:02:27
  789. current log archived
  790. using channel ORA_SBT_TAPE_1
  791. using channel ORA_SBT_TAPE_2
  792. channel ORA_SBT_TAPE_1: starting archived log backup set
  793. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  794. input archived log thread=1 sequence=10 RECID=121 STAMP=954950548
  795. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-17:16:02:28
  796. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-17:16:02:53
  797. piece handle=23semosk_1_1 tag=2T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  798. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  799. channel ORA_SBT_TAPE_1: deleting archived log(s)
  800. archived log file name=+FRA/orcl/archivelog/2017_09_17/thread_1_seq_10.319.954950547 RECID=121 STAMP=954950548
  801. Finished backup at 2017-09-17:16:02:53

  802. Starting Control File and SPFILE Autobackup at 2017-09-17:16:02:53
  803. piece handle=c-1343950367-20170917-00 comment=API Version 2.0,MMS Version 10.4.0.4
  804. Finished Control File and SPFILE Autobackup at 2017-09-17:16:03:18

  805. RMAN> report obsolete;

  806. RMAN retention policy will be applied to the command
  807. RMAN retention policy is set to recovery window of 1 days
  808. Report of obsolete backups and copies
  809. Type                 Key    Completion Time    Filename/Handle
  810. -------------------- ------ ------------------ --------------------
  811. Backup Set           58     2017-09-16:15:53:00
  812.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  813. Backup Set           59     2017-09-16:15:57:29
  814.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  815. RMAN> report need backup;

  816. RMAN retention policy will be applied to the command
  817. RMAN retention policy is set to recovery window of 1 days
  818. Report of files that must be backed up to satisfy 1 days recovery window
  819. File Days  Name
  820. ---- ----- -----------------------------------------------------

  821. RMAN> exit


  822. Recovery Manager complete.
  823. [oracle@station90 ~]$ rman target /

  824. Recovery Manager: Release 11.2.0.3.0 - Production on Sun Sep 17 23:59:02 2017

  825. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  826. connected to target database: ORCL (DBID=1343950367)

  827. RMAN> report obsolete;

  828. using target database control file instead of recovery catalog
  829. RMAN retention policy will be applied to the command
  830. RMAN retention policy is set to recovery window of 1 days
  831. Report of obsolete backups and copies
  832. Type                 Key    Completion Time    Filename/Handle
  833. -------------------- ------ ------------------ --------------------
  834. Backup Set           58     2017-09-16:15:53:00
  835.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  836. Backup Set           59     2017-09-16:15:57:29
  837.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  838. RMAN> report need backup;

  839. RMAN retention policy will be applied to the command
  840. RMAN retention policy is set to recovery window of 1 days
  841. Report of files that must be backed up to satisfy 1 days recovery window
  842. File Days  Name
  843. ---- ----- -----------------------------------------------------

  844. RMAN> report obsolete;

  845. RMAN retention policy will be applied to the command
  846. RMAN retention policy is set to recovery window of 1 days
  847. Report of obsolete backups and copies
  848. Type                 Key    Completion Time    Filename/Handle
  849. -------------------- ------ ------------------ --------------------
  850. Backup Set           58     2017-09-16:15:53:00
  851.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  852. Backup Set           59     2017-09-16:15:57:29
  853.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  854. RMAN> report need backup;

  855. RMAN retention policy will be applied to the command
  856. RMAN retention policy is set to recovery window of 1 days
  857. Report of files that must be backed up to satisfy 1 days recovery window
  858. File Days  Name
  859. ---- ----- -----------------------------------------------------

  860. RMAN> exit


  861. Recovery Manager complete.
  862. [oracle@station90 ~]$ rman target /

  863. Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 15:50:13 2017

  864. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  865. connected to target database: ORCL (DBID=1343950367)

  866. RMAN> report obsolete;

  867. using target database control file instead of recovery catalog
  868. RMAN retention policy will be applied to the command
  869. RMAN retention policy is set to recovery window of 1 days
  870. Report of obsolete backups and copies
  871. Type                 Key    Completion Time    Filename/Handle
  872. -------------------- ------ ------------------ --------------------
  873. Backup Set           58     2017-09-16:15:53:00
  874.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  875. Backup Set           59     2017-09-16:15:57:29
  876.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  877. RMAN> report need backup;

  878. RMAN retention policy will be applied to the command
  879. RMAN retention policy is set to recovery window of 1 days
  880. Report of files that must be backed up to satisfy 1 days recovery window
  881. File Days  Name
  882. ---- ----- -----------------------------------------------------

  883. RMAN> exit


  884. Recovery Manager complete.
  885. [oracle@station90 ~]$ rman target /

  886. Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 15:54:04 2017

  887. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  888. connected to target database: ORCL (DBID=1343950367)

  889. RMAN> report obsolete;

  890. using target database control file instead of recovery catalog
  891. RMAN retention policy will be applied to the command
  892. RMAN retention policy is set to recovery window of 1 days
  893. Report of obsolete backups and copies
  894. Type                 Key    Completion Time    Filename/Handle
  895. -------------------- ------ ------------------ --------------------
  896. Backup Set           58     2017-09-16:15:53:00
  897.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  898. Backup Set           59     2017-09-16:15:57:29
  899.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  900. RMAN> report obsolete;

  901. RMAN retention policy will be applied to the command
  902. RMAN retention policy is set to recovery window of 1 days
  903. Report of obsolete backups and copies
  904. Type                 Key    Completion Time    Filename/Handle
  905. -------------------- ------ ------------------ --------------------
  906. Backup Set           58     2017-09-16:15:53:00
  907.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  908. Backup Set           59     2017-09-16:15:57:29
  909.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  910. RMAN> report obsolete;

  911. RMAN retention policy will be applied to the command
  912. RMAN retention policy is set to recovery window of 1 days
  913. Report of obsolete backups and copies
  914. Type                 Key    Completion Time    Filename/Handle
  915. -------------------- ------ ------------------ --------------------
  916. Backup Set           58     2017-09-16:15:53:00
  917.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  918. Backup Set           59     2017-09-16:15:57:29
  919.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  920. RMAN> list backup;


  921. List of Backup Sets
  922. ===================


  923. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  924. ------- ---- -- ---------- ----------- ------------ -------------------
  925. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  926.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  927.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  928.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  929.   SPFILE db_unique_name: ORCL
  930.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  931. BS Key  Size       Device Type Elapsed Time Completion Time   
  932. ------- ---------- ----------- ------------ -------------------
  933. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  934.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  935.         Handle: 1rsek46p_1_1   Media: station90-000003

  936.   List of Archived Logs in backup set 59
  937.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  938.   ---- ------- ---------- ------------------- ---------- ---------
  939.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  940. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  941. ------- ---- -- ---------- ----------- ------------ -------------------
  942. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  943.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  944.         Handle: 1tsek47i_1_1   Media: station90-000004
  945.   List of Datafiles in backup set 60
  946.   File LV Type Ckp SCN    Ckp Time            Name
  947.   ---- -- ---- ---------- ------------------- ----
  948.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  949.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  950. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  951. ------- ---- -- ---------- ----------- ------------ -------------------
  952. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  953.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  954.         Handle: 1ssek47i_1_1   Media: station90-000003
  955.   List of Datafiles in backup set 61
  956.   File LV Type Ckp SCN    Ckp Time            Name
  957.   ---- -- ---- ---------- ------------------- ----
  958.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  959.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  960.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  961. BS Key  Size       Device Type Elapsed Time Completion Time   
  962. ------- ---------- ----------- ------------ -------------------
  963. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  964.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  965.         Handle: 1usek48m_1_1   Media: station90-000003

  966.   List of Archived Logs in backup set 62
  967.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  968.   ---- ------- ---------- ------------------- ---------- ---------
  969.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  970. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  971. ------- ---- -- ---------- ----------- ------------ -------------------
  972. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  973.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  974.         Handle: c-1343950367-20170916-03   Media: station90-000003
  975.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  976.   SPFILE db_unique_name: ORCL
  977.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  978. BS Key  Size       Device Type Elapsed Time Completion Time   
  979. ------- ---------- ----------- ------------ -------------------
  980. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  981.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  982.         Handle: 20semoqn_1_1   Media: station90-000003

  983.   List of Archived Logs in backup set 64
  984.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  985.   ---- ------- ---------- ------------------- ---------- ---------
  986.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  987. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  988. ------- ---- -- ---------- ----------- ------------ -------------------
  989. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  990.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  991.         Handle: 22semorg_1_1   Media: station90-000004
  992.   List of Datafiles in backup set 65
  993.   File LV Type Ckp SCN    Ckp Time            Name
  994.   ---- -- ---- ---------- ------------------- ----
  995.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  996.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  997. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  998. ------- ---- -- ---------- ----------- ------------ -------------------
  999. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  1000.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1001.         Handle: 21semorg_1_1   Media: station90-000003
  1002.   List of Datafiles in backup set 66
  1003.   File LV Type Ckp SCN    Ckp Time            Name
  1004.   ---- -- ---- ---------- ------------------- ----
  1005.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  1006.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  1007.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  1008. BS Key  Size       Device Type Elapsed Time Completion Time   
  1009. ------- ---------- ----------- ------------ -------------------
  1010. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  1011.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1012.         Handle: 23semosk_1_1   Media: station90-000003

  1013.   List of Archived Logs in backup set 67
  1014.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1015.   ---- ------- ---------- ------------------- ---------- ---------
  1016.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  1017. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1018. ------- ---- -- ---------- ----------- ------------ -------------------
  1019. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  1020.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  1021.         Handle: c-1343950367-20170917-00   Media: station90-000003
  1022.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1023.   SPFILE db_unique_name: ORCL
  1024.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  1025. RMAN> exit


  1026. Recovery Manager complete.
  1027. [oracle@station90 ~]$ rman target /

  1028. Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 15:58:02 2017

  1029. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  1030. connected to target database: ORCL (DBID=1343950367)

  1031. RMAN> list backup;

  1032. using target database control file instead of recovery catalog

  1033. List of Backup Sets
  1034. ===================


  1035. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1036. ------- ---- -- ---------- ----------- ------------ -------------------
  1037. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  1038.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  1039.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1040.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1041.   SPFILE db_unique_name: ORCL
  1042.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  1043. BS Key  Size       Device Type Elapsed Time Completion Time   
  1044. ------- ---------- ----------- ------------ -------------------
  1045. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  1046.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1047.         Handle: 1rsek46p_1_1   Media: station90-000003

  1048.   List of Archived Logs in backup set 59
  1049.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1050.   ---- ------- ---------- ------------------- ---------- ---------
  1051.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  1052. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1053. ------- ---- -- ---------- ----------- ------------ -------------------
  1054. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  1055.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1056.         Handle: 1tsek47i_1_1   Media: station90-000004
  1057.   List of Datafiles in backup set 60
  1058.   File LV Type Ckp SCN    Ckp Time            Name
  1059.   ---- -- ---- ---------- ------------------- ----
  1060.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  1061.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  1062. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1063. ------- ---- -- ---------- ----------- ------------ -------------------
  1064. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  1065.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1066.         Handle: 1ssek47i_1_1   Media: station90-000003
  1067.   List of Datafiles in backup set 61
  1068.   File LV Type Ckp SCN    Ckp Time            Name
  1069.   ---- -- ---- ---------- ------------------- ----
  1070.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  1071.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  1072.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  1073. BS Key  Size       Device Type Elapsed Time Completion Time   
  1074. ------- ---------- ----------- ------------ -------------------
  1075. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  1076.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1077.         Handle: 1usek48m_1_1   Media: station90-000003

  1078.   List of Archived Logs in backup set 62
  1079.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1080.   ---- ------- ---------- ------------------- ---------- ---------
  1081.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  1082. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1083. ------- ---- -- ---------- ----------- ------------ -------------------
  1084. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  1085.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  1086.         Handle: c-1343950367-20170916-03   Media: station90-000003
  1087.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1088.   SPFILE db_unique_name: ORCL
  1089.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  1090. BS Key  Size       Device Type Elapsed Time Completion Time   
  1091. ------- ---------- ----------- ------------ -------------------
  1092. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  1093.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1094.         Handle: 20semoqn_1_1   Media: station90-000003

  1095.   List of Archived Logs in backup set 64
  1096.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1097.   ---- ------- ---------- ------------------- ---------- ---------
  1098.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  1099. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1100. ------- ---- -- ---------- ----------- ------------ -------------------
  1101. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  1102.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1103.         Handle: 22semorg_1_1   Media: station90-000004
  1104.   List of Datafiles in backup set 65
  1105.   File LV Type Ckp SCN    Ckp Time            Name
  1106.   ---- -- ---- ---------- ------------------- ----
  1107.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  1108.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  1109. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1110. ------- ---- -- ---------- ----------- ------------ -------------------
  1111. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  1112.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1113.         Handle: 21semorg_1_1   Media: station90-000003
  1114.   List of Datafiles in backup set 66
  1115.   File LV Type Ckp SCN    Ckp Time            Name
  1116.   ---- -- ---- ---------- ------------------- ----
  1117.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  1118.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  1119.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  1120. BS Key  Size       Device Type Elapsed Time Completion Time   
  1121. ------- ---------- ----------- ------------ -------------------
  1122. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  1123.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1124.         Handle: 23semosk_1_1   Media: station90-000003

  1125.   List of Archived Logs in backup set 67
  1126.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1127.   ---- ------- ---------- ------------------- ---------- ---------
  1128.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  1129. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1130. ------- ---- -- ---------- ----------- ------------ -------------------
  1131. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  1132.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  1133.         Handle: c-1343950367-20170917-00   Media: station90-000003
  1134.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1135.   SPFILE db_unique_name: ORCL
  1136.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  1137. RMAN> report obsolete;

  1138. RMAN retention policy will be applied to the command
  1139. RMAN retention policy is set to recovery window of 1 days
  1140. Report of obsolete backups and copies
  1141. Type                 Key    Completion Time    Filename/Handle
  1142. -------------------- ------ ------------------ --------------------
  1143. Backup Set           58     2017-09-16:15:53:00
  1144.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1145. Backup Set           59     2017-09-16:15:57:29
  1146.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1147. RMAN> report obsolete;

  1148. RMAN retention policy will be applied to the command
  1149. RMAN retention policy is set to recovery window of 1 days
  1150. Report of obsolete backups and copies
  1151. Type                 Key    Completion Time    Filename/Handle
  1152. -------------------- ------ ------------------ --------------------
  1153. Backup Set           58     2017-09-16:15:53:00
  1154.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1155. Backup Set           59     2017-09-16:15:57:29
  1156.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1157. RMAN> report obsolete;

  1158. RMAN retention policy will be applied to the command
  1159. RMAN retention policy is set to recovery window of 1 days
  1160. Report of obsolete backups and copies
  1161. Type                 Key    Completion Time    Filename/Handle
  1162. -------------------- ------ ------------------ --------------------
  1163. Backup Set           58     2017-09-16:15:53:00
  1164.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1165. Backup Set           59     2017-09-16:15:57:29
  1166.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1167. RMAN> report obsolete;

  1168. RMAN retention policy will be applied to the command
  1169. RMAN retention policy is set to recovery window of 1 days
  1170. Report of obsolete backups and copies
  1171. Type                 Key    Completion Time    Filename/Handle
  1172. -------------------- ------ ------------------ --------------------
  1173. Backup Set           58     2017-09-16:15:53:00
  1174.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1175. Backup Set           59     2017-09-16:15:57:29
  1176.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1177. RMAN> report obsolete;

  1178. RMAN retention policy will be applied to the command
  1179. RMAN retention policy is set to recovery window of 1 days
  1180. Report of obsolete backups and copies
  1181. Type                 Key    Completion Time    Filename/Handle
  1182. -------------------- ------ ------------------ --------------------
  1183. Backup Set           58     2017-09-16:15:53:00
  1184.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1185. Backup Set           59     2017-09-16:15:57:29
  1186.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1187. RMAN> report obsolete;

  1188. RMAN retention policy will be applied to the command
  1189. RMAN retention policy is set to recovery window of 1 days
  1190. Report of obsolete backups and copies
  1191. Type                 Key    Completion Time    Filename/Handle
  1192. -------------------- ------ ------------------ --------------------
  1193. Backup Set           58     2017-09-16:15:53:00
  1194.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1195. Backup Set           59     2017-09-16:15:57:29
  1196.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1197. RMAN> report obsolete;

  1198. RMAN retention policy will be applied to the command
  1199. RMAN retention policy is set to recovery window of 1 days
  1200. Report of obsolete backups and copies
  1201. Type                 Key    Completion Time    Filename/Handle
  1202. -------------------- ------ ------------------ --------------------
  1203. Backup Set           58     2017-09-16:15:53:00
  1204.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1205. Backup Set           59     2017-09-16:15:57:29
  1206.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1207. RMAN> report obsolete;

  1208. RMAN retention policy will be applied to the command
  1209. RMAN retention policy is set to recovery window of 1 days
  1210. Report of obsolete backups and copies
  1211. Type                 Key    Completion Time    Filename/Handle
  1212. -------------------- ------ ------------------ --------------------
  1213. Backup Set           58     2017-09-16:15:53:00
  1214.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1215. Backup Set           59     2017-09-16:15:57:29
  1216.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1217. RMAN> report obsolete;

  1218. RMAN retention policy will be applied to the command
  1219. RMAN retention policy is set to recovery window of 1 days
  1220. Report of obsolete backups and copies
  1221. Type                 Key    Completion Time    Filename/Handle
  1222. -------------------- ------ ------------------ --------------------
  1223. Backup Set           58     2017-09-16:15:53:00
  1224.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1225. Backup Set           59     2017-09-16:15:57:29
  1226.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1227. RMAN> report obsolete;

  1228. RMAN retention policy will be applied to the command
  1229. RMAN retention policy is set to recovery window of 1 days
  1230. Report of obsolete backups and copies
  1231. Type                 Key    Completion Time    Filename/Handle
  1232. -------------------- ------ ------------------ --------------------
  1233. Backup Set           58     2017-09-16:15:53:00
  1234.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1235. Backup Set           59     2017-09-16:15:57:29
  1236.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1237. RMAN> report obsolete;

  1238. RMAN retention policy will be applied to the command
  1239. RMAN retention policy is set to recovery window of 1 days
  1240. Report of obsolete backups and copies
  1241. Type                 Key    Completion Time    Filename/Handle
  1242. -------------------- ------ ------------------ --------------------
  1243. Backup Set           58     2017-09-16:15:53:00
  1244.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1245. Backup Set           59     2017-09-16:15:57:29
  1246.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1247. RMAN> report obsolete;

  1248. RMAN retention policy will be applied to the command
  1249. RMAN retention policy is set to recovery window of 1 days
  1250. Report of obsolete backups and copies
  1251. Type                 Key    Completion Time    Filename/Handle
  1252. -------------------- ------ ------------------ --------------------
  1253. Backup Set           58     2017-09-16:15:53:00
  1254.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1255. Backup Set           59     2017-09-16:15:57:29
  1256.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1257. RMAN> report obsolete;

  1258. RMAN retention policy will be applied to the command
  1259. RMAN retention policy is set to recovery window of 1 days
  1260. Report of obsolete backups and copies
  1261. Type                 Key    Completion Time    Filename/Handle
  1262. -------------------- ------ ------------------ --------------------
  1263. Backup Set           58     2017-09-16:15:53:00
  1264.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1265. Backup Set           59     2017-09-16:15:57:29
  1266.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1267. RMAN> report obsolete;

  1268. RMAN retention policy will be applied to the command
  1269. RMAN retention policy is set to recovery window of 1 days
  1270. Report of obsolete backups and copies
  1271. Type                 Key    Completion Time    Filename/Handle
  1272. -------------------- ------ ------------------ --------------------
  1273. Backup Set           58     2017-09-16:15:53:00
  1274.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1275. Backup Set           59     2017-09-16:15:57:29
  1276.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1277. RMAN> report obsolete;

  1278. RMAN retention policy will be applied to the command
  1279. RMAN retention policy is set to recovery window of 1 days
  1280. Report of obsolete backups and copies
  1281. Type                 Key    Completion Time    Filename/Handle
  1282. -------------------- ------ ------------------ --------------------
  1283. Backup Set           58     2017-09-16:15:53:00
  1284.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1285. Backup Set           59     2017-09-16:15:57:29
  1286.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1287. RMAN> list backup;


  1288. List of Backup Sets
  1289. ===================


  1290. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1291. ------- ---- -- ---------- ----------- ------------ -------------------
  1292. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  1293.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  1294.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1295.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1296.   SPFILE db_unique_name: ORCL
  1297.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  1298. BS Key  Size       Device Type Elapsed Time Completion Time   
  1299. ------- ---------- ----------- ------------ -------------------
  1300. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  1301.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1302.         Handle: 1rsek46p_1_1   Media: station90-000003

  1303.   List of Archived Logs in backup set 59
  1304.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1305.   ---- ------- ---------- ------------------- ---------- ---------
  1306.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  1307. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1308. ------- ---- -- ---------- ----------- ------------ -------------------
  1309. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  1310.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1311.         Handle: 1tsek47i_1_1   Media: station90-000004
  1312.   List of Datafiles in backup set 60
  1313.   File LV Type Ckp SCN    Ckp Time            Name
  1314.   ---- -- ---- ---------- ------------------- ----
  1315.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  1316.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  1317. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1318. ------- ---- -- ---------- ----------- ------------ -------------------
  1319. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  1320.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1321.         Handle: 1ssek47i_1_1   Media: station90-000003
  1322.   List of Datafiles in backup set 61
  1323.   File LV Type Ckp SCN    Ckp Time            Name
  1324.   ---- -- ---- ---------- ------------------- ----
  1325.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  1326.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  1327.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  1328. BS Key  Size       Device Type Elapsed Time Completion Time   
  1329. ------- ---------- ----------- ------------ -------------------
  1330. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  1331.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1332.         Handle: 1usek48m_1_1   Media: station90-000003

  1333.   List of Archived Logs in backup set 62
  1334.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1335.   ---- ------- ---------- ------------------- ---------- ---------
  1336.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  1337. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1338. ------- ---- -- ---------- ----------- ------------ -------------------
  1339. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  1340.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  1341.         Handle: c-1343950367-20170916-03   Media: station90-000003
  1342.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1343.   SPFILE db_unique_name: ORCL
  1344.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  1345. BS Key  Size       Device Type Elapsed Time Completion Time   
  1346. ------- ---------- ----------- ------------ -------------------
  1347. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  1348.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1349.         Handle: 20semoqn_1_1   Media: station90-000003

  1350.   List of Archived Logs in backup set 64
  1351.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1352.   ---- ------- ---------- ------------------- ---------- ---------
  1353.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  1354. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1355. ------- ---- -- ---------- ----------- ------------ -------------------
  1356. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  1357.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1358.         Handle: 22semorg_1_1   Media: station90-000004
  1359.   List of Datafiles in backup set 65
  1360.   File LV Type Ckp SCN    Ckp Time            Name
  1361.   ---- -- ---- ---------- ------------------- ----
  1362.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  1363.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  1364. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1365. ------- ---- -- ---------- ----------- ------------ -------------------
  1366. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  1367.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1368.         Handle: 21semorg_1_1   Media: station90-000003
  1369.   List of Datafiles in backup set 66
  1370.   File LV Type Ckp SCN    Ckp Time            Name
  1371.   ---- -- ---- ---------- ------------------- ----
  1372.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  1373.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  1374.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  1375. BS Key  Size       Device Type Elapsed Time Completion Time   
  1376. ------- ---------- ----------- ------------ -------------------
  1377. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  1378.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1379.         Handle: 23semosk_1_1   Media: station90-000003

  1380.   List of Archived Logs in backup set 67
  1381.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1382.   ---- ------- ---------- ------------------- ---------- ---------
  1383.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  1384. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1385. ------- ---- -- ---------- ----------- ------------ -------------------
  1386. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  1387.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  1388.         Handle: c-1343950367-20170917-00   Media: station90-000003
  1389.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1390.   SPFILE db_unique_name: ORCL
  1391.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  1392. RMAN> report obsolete;

  1393. RMAN retention policy will be applied to the command
  1394. RMAN retention policy is set to recovery window of 1 days
  1395. Report of obsolete backups and copies
  1396. Type                 Key    Completion Time    Filename/Handle
  1397. -------------------- ------ ------------------ --------------------
  1398. Backup Set           58     2017-09-16:15:53:00
  1399.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1400. Backup Set           59     2017-09-16:15:57:29
  1401.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1402. RMAN> exit


  1403. Recovery Manager complete.
  1404. [oracle@station90 ~]$ rman target /

  1405. Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 16:01:03 2017

  1406. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  1407. connected to target database: ORCL (DBID=1343950367)

  1408. RMAN> report obsolete;

  1409. using target database control file instead of recovery catalog
  1410. RMAN retention policy will be applied to the command
  1411. RMAN retention policy is set to recovery window of 1 days
  1412. Report of obsolete backups and copies
  1413. Type                 Key    Completion Time    Filename/Handle
  1414. -------------------- ------ ------------------ --------------------
  1415. Backup Set           58     2017-09-16:15:53:00
  1416.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1417. Backup Set           59     2017-09-16:15:57:29
  1418.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1419. RMAN> report obsolete;

  1420. RMAN retention policy will be applied to the command
  1421. RMAN retention policy is set to recovery window of 1 days
  1422. Report of obsolete backups and copies
  1423. Type                 Key    Completion Time    Filename/Handle
  1424. -------------------- ------ ------------------ --------------------
  1425. Backup Set           58     2017-09-16:15:53:00
  1426.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1427. Backup Set           59     2017-09-16:15:57:29
  1428.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1429. RMAN> report obsolete;

  1430. RMAN retention policy will be applied to the command
  1431. RMAN retention policy is set to recovery window of 1 days
  1432. Report of obsolete backups and copies
  1433. Type                 Key    Completion Time    Filename/Handle
  1434. -------------------- ------ ------------------ --------------------
  1435. Backup Set           58     2017-09-16:15:53:00
  1436.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1437. Backup Set           59     2017-09-16:15:57:29
  1438.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1439. RMAN> report obsolete;

  1440. RMAN retention policy will be applied to the command
  1441. RMAN retention policy is set to recovery window of 1 days
  1442. Report of obsolete backups and copies
  1443. Type                 Key    Completion Time    Filename/Handle
  1444. -------------------- ------ ------------------ --------------------
  1445. Backup Set           58     2017-09-16:15:53:00
  1446.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1447. Backup Set           59     2017-09-16:15:57:29
  1448.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1449. RMAN> report obsolete;

  1450. RMAN retention policy will be applied to the command
  1451. RMAN retention policy is set to recovery window of 1 days
  1452. Report of obsolete backups and copies
  1453. Type                 Key    Completion Time    Filename/Handle
  1454. -------------------- ------ ------------------ --------------------
  1455. Backup Set           58     2017-09-16:15:53:00
  1456.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1457. Backup Set           59     2017-09-16:15:57:29
  1458.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1459. RMAN> report obsolete;

  1460. RMAN retention policy will be applied to the command
  1461. RMAN retention policy is set to recovery window of 1 days
  1462. Report of obsolete backups and copies
  1463. Type                 Key    Completion Time    Filename/Handle
  1464. -------------------- ------ ------------------ --------------------
  1465. Backup Set           58     2017-09-16:15:53:00
  1466.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1467. Backup Set           59     2017-09-16:15:57:29
  1468.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1469. RMAN> report obsolete;

  1470. RMAN retention policy will be applied to the command
  1471. RMAN retention policy is set to recovery window of 1 days
  1472. Report of obsolete backups and copies
  1473. Type                 Key    Completion Time    Filename/Handle
  1474. -------------------- ------ ------------------ --------------------
  1475. Backup Set           58     2017-09-16:15:53:00
  1476.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1477. Backup Set           59     2017-09-16:15:57:29
  1478.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1

  1479. RMAN> list backup ;


  1480. List of Backup Sets
  1481. ===================


  1482. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1483. ------- ---- -- ---------- ----------- ------------ -------------------
  1484. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  1485.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  1486.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1487.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1488.   SPFILE db_unique_name: ORCL
  1489.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  1490. BS Key  Size       Device Type Elapsed Time Completion Time   
  1491. ------- ---------- ----------- ------------ -------------------
  1492. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  1493.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1494.         Handle: 1rsek46p_1_1   Media: station90-000003

  1495.   List of Archived Logs in backup set 59
  1496.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1497.   ---- ------- ---------- ------------------- ---------- ---------
  1498.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  1499. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1500. ------- ---- -- ---------- ----------- ------------ -------------------
  1501. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  1502.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1503.         Handle: 1tsek47i_1_1   Media: station90-000004
  1504.   List of Datafiles in backup set 60
  1505.   File LV Type Ckp SCN    Ckp Time            Name
  1506.   ---- -- ---- ---------- ------------------- ----
  1507.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  1508.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  1509. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1510. ------- ---- -- ---------- ----------- ------------ -------------------
  1511. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  1512.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1513.         Handle: 1ssek47i_1_1   Media: station90-000003
  1514.   List of Datafiles in backup set 61
  1515.   File LV Type Ckp SCN    Ckp Time            Name
  1516.   ---- -- ---- ---------- ------------------- ----
  1517.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  1518.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  1519.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  1520. BS Key  Size       Device Type Elapsed Time Completion Time   
  1521. ------- ---------- ----------- ------------ -------------------
  1522. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  1523.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1524.         Handle: 1usek48m_1_1   Media: station90-000003

  1525.   List of Archived Logs in backup set 62
  1526.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1527.   ---- ------- ---------- ------------------- ---------- ---------
  1528.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  1529. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1530. ------- ---- -- ---------- ----------- ------------ -------------------
  1531. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  1532.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  1533.         Handle: c-1343950367-20170916-03   Media: station90-000003
  1534.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1535.   SPFILE db_unique_name: ORCL
  1536.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  1537. BS Key  Size       Device Type Elapsed Time Completion Time   
  1538. ------- ---------- ----------- ------------ -------------------
  1539. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  1540.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1541.         Handle: 20semoqn_1_1   Media: station90-000003

  1542.   List of Archived Logs in backup set 64
  1543.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1544.   ---- ------- ---------- ------------------- ---------- ---------
  1545.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  1546. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1547. ------- ---- -- ---------- ----------- ------------ -------------------
  1548. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  1549.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1550.         Handle: 22semorg_1_1   Media: station90-000004
  1551.   List of Datafiles in backup set 65
  1552.   File LV Type Ckp SCN    Ckp Time            Name
  1553.   ---- -- ---- ---------- ------------------- ----
  1554.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  1555.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  1556. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1557. ------- ---- -- ---------- ----------- ------------ -------------------
  1558. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  1559.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1560.         Handle: 21semorg_1_1   Media: station90-000003
  1561.   List of Datafiles in backup set 66
  1562.   File LV Type Ckp SCN    Ckp Time            Name
  1563.   ---- -- ---- ---------- ------------------- ----
  1564.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  1565.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  1566.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  1567. BS Key  Size       Device Type Elapsed Time Completion Time   
  1568. ------- ---------- ----------- ------------ -------------------
  1569. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  1570.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1571.         Handle: 23semosk_1_1   Media: station90-000003

  1572.   List of Archived Logs in backup set 67
  1573.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1574.   ---- ------- ---------- ------------------- ---------- ---------
  1575.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  1576. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1577. ------- ---- -- ---------- ----------- ------------ -------------------
  1578. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  1579.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  1580.         Handle: c-1343950367-20170917-00   Media: station90-000003
  1581.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1582.   SPFILE db_unique_name: ORCL
  1583.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  1584. RMAN> list backup  with tag '2T_INCR0_WHOLE';

  1585. RMAN-00571: ===========================================================
  1586. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  1587. RMAN-00571: ===========================================================
  1588. RMAN-00558: error encountered while parsing input commands
  1589. RMAN-01009: syntax error: found "with": expecting one of: "backed, by, completed, controlfile, device, for, like, of, recoverable, summary, tag, ;"
  1590. RMAN-01007: at line 1 column 14 file: standard input

  1591. RMAN> list backup ;


  1592. List of Backup Sets
  1593. ===================


  1594. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1595. ------- ---- -- ---------- ----------- ------------ -------------------
  1596. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  1597.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  1598.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1599.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1600.   SPFILE db_unique_name: ORCL
  1601.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  1602. BS Key  Size       Device Type Elapsed Time Completion Time   
  1603. ------- ---------- ----------- ------------ -------------------
  1604. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  1605.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1606.         Handle: 1rsek46p_1_1   Media: station90-000003

  1607.   List of Archived Logs in backup set 59
  1608.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1609.   ---- ------- ---------- ------------------- ---------- ---------
  1610.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  1611. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1612. ------- ---- -- ---------- ----------- ------------ -------------------
  1613. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  1614.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1615.         Handle: 1tsek47i_1_1   Media: station90-000004
  1616.   List of Datafiles in backup set 60
  1617.   File LV Type Ckp SCN    Ckp Time            Name
  1618.   ---- -- ---- ---------- ------------------- ----
  1619.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  1620.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  1621. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1622. ------- ---- -- ---------- ----------- ------------ -------------------
  1623. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  1624.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1625.         Handle: 1ssek47i_1_1   Media: station90-000003
  1626.   List of Datafiles in backup set 61
  1627.   File LV Type Ckp SCN    Ckp Time            Name
  1628.   ---- -- ---- ---------- ------------------- ----
  1629.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  1630.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  1631.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  1632. BS Key  Size       Device Type Elapsed Time Completion Time   
  1633. ------- ---------- ----------- ------------ -------------------
  1634. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  1635.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1636.         Handle: 1usek48m_1_1   Media: station90-000003

  1637.   List of Archived Logs in backup set 62
  1638.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1639.   ---- ------- ---------- ------------------- ---------- ---------
  1640.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  1641. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1642. ------- ---- -- ---------- ----------- ------------ -------------------
  1643. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  1644.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  1645.         Handle: c-1343950367-20170916-03   Media: station90-000003
  1646.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1647.   SPFILE db_unique_name: ORCL
  1648.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  1649. BS Key  Size       Device Type Elapsed Time Completion Time   
  1650. ------- ---------- ----------- ------------ -------------------
  1651. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  1652.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1653.         Handle: 20semoqn_1_1   Media: station90-000003

  1654.   List of Archived Logs in backup set 64
  1655.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1656.   ---- ------- ---------- ------------------- ---------- ---------
  1657.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  1658. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1659. ------- ---- -- ---------- ----------- ------------ -------------------
  1660. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  1661.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1662.         Handle: 22semorg_1_1   Media: station90-000004
  1663.   List of Datafiles in backup set 65
  1664.   File LV Type Ckp SCN    Ckp Time            Name
  1665.   ---- -- ---- ---------- ------------------- ----
  1666.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  1667.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  1668. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1669. ------- ---- -- ---------- ----------- ------------ -------------------
  1670. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  1671.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1672.         Handle: 21semorg_1_1   Media: station90-000003
  1673.   List of Datafiles in backup set 66
  1674.   File LV Type Ckp SCN    Ckp Time            Name
  1675.   ---- -- ---- ---------- ------------------- ----
  1676.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  1677.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  1678.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  1679. BS Key  Size       Device Type Elapsed Time Completion Time   
  1680. ------- ---------- ----------- ------------ -------------------
  1681. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  1682.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1683.         Handle: 23semosk_1_1   Media: station90-000003

  1684.   List of Archived Logs in backup set 67
  1685.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1686.   ---- ------- ---------- ------------------- ---------- ---------
  1687.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  1688. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1689. ------- ---- -- ---------- ----------- ------------ -------------------
  1690. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  1691.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  1692.         Handle: c-1343950367-20170917-00   Media: station90-000003
  1693.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1694.   SPFILE db_unique_name: ORCL
  1695.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  1696. RMAN> report obsolete;

  1697. RMAN retention policy will be applied to the command
  1698. RMAN retention policy is set to recovery window of 1 days
  1699. Report of obsolete backups and copies
  1700. Type                 Key    Completion Time    Filename/Handle
  1701. -------------------- ------ ------------------ --------------------
  1702. Backup Set           58     2017-09-16:15:53:00
  1703.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1704. Backup Set           59     2017-09-16:15:57:29
  1705.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1
  1706. Backup Set           61     2017-09-16:15:58:09
  1707.   Backup Piece       61     2017-09-16:15:58:09 1ssek47i_1_1

  1708. RMAN> report obsolete;

  1709. RMAN retention policy will be applied to the command
  1710. RMAN retention policy is set to recovery window of 1 days
  1711. Report of obsolete backups and copies
  1712. Type                 Key    Completion Time    Filename/Handle
  1713. -------------------- ------ ------------------ --------------------
  1714. Backup Set           58     2017-09-16:15:53:00
  1715.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1716. Backup Set           59     2017-09-16:15:57:29
  1717.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1
  1718. Backup Set           61     2017-09-16:15:58:09
  1719.   Backup Piece       61     2017-09-16:15:58:09 1ssek47i_1_1
  1720. Backup Set           60     2017-09-16:15:58:06
  1721.   Backup Piece       60     2017-09-16:15:58:06 1tsek47i_1_1
  1722. Backup Set           62     2017-09-16:15:58:30
  1723.   Backup Piece       62     2017-09-16:15:58:30 1usek48m_1_1

  1724. RMAN> report need backup;

  1725. RMAN retention policy will be applied to the command
  1726. RMAN retention policy is set to recovery window of 1 days
  1727. Report of files that must be backed up to satisfy 1 days recovery window
  1728. File Days  Name
  1729. ---- ----- -----------------------------------------------------

  1730. RMAN> exit


  1731. Recovery Manager complete.
  1732. [oracle@station90 ~]$ rman target /

  1733. Recovery Manager: Release 11.2.0.3.0 - Production on Mon Sep 18 23:59:03 2017

  1734. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  1735. connected to target database: ORCL (DBID=1343950367)

  1736. RMAN> report obsolete;

  1737. using target database control file instead of recovery catalog
  1738. RMAN retention policy will be applied to the command
  1739. RMAN retention policy is set to recovery window of 1 days
  1740. Report of obsolete backups and copies
  1741. Type                 Key    Completion Time    Filename/Handle
  1742. -------------------- ------ ------------------ --------------------
  1743. Backup Set           58     2017-09-16:15:53:00
  1744.   Backup Piece       58     2017-09-16:15:53:00 +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1745. Backup Set           59     2017-09-16:15:57:29
  1746.   Backup Piece       59     2017-09-16:15:57:29 1rsek46p_1_1
  1747. Backup Set           61     2017-09-16:15:58:09
  1748.   Backup Piece       61     2017-09-16:15:58:09 1ssek47i_1_1
  1749. Backup Set           60     2017-09-16:15:58:06
  1750.   Backup Piece       60     2017-09-16:15:58:06 1tsek47i_1_1
  1751. Backup Set           62     2017-09-16:15:58:30
  1752.   Backup Piece       62     2017-09-16:15:58:30 1usek48m_1_1
  1753. Backup Set           63     2017-09-16:15:58:50
  1754.   Backup Piece       63     2017-09-16:15:58:50 c-1343950367-20170916-03
  1755. Backup Set           64     2017-09-17:16:01:42
  1756.   Backup Piece       64     2017-09-17:16:01:42 20semoqn_1_1

  1757. RMAN> report need backup;

  1758. RMAN retention policy will be applied to the command
  1759. RMAN retention policy is set to recovery window of 1 days
  1760. Report of files that must be backed up to satisfy 1 days recovery window
  1761. File Days  Name
  1762. ---- ----- -----------------------------------------------------

  1763. RMAN> report need backup;

  1764. RMAN retention policy will be applied to the command
  1765. RMAN retention policy is set to recovery window of 1 days
  1766. Report of files that must be backed up to satisfy 1 days recovery window
  1767. File Days  Name
  1768. ---- ----- -----------------------------------------------------

  1769. RMAN> report need backup;

  1770. RMAN retention policy will be applied to the command
  1771. RMAN retention policy is set to recovery window of 1 days
  1772. Report of files that must be backed up to satisfy 1 days recovery window
  1773. File Days  Name
  1774. ---- ----- -----------------------------------------------------

  1775. RMAN> report need backup;

  1776. RMAN retention policy will be applied to the command
  1777. RMAN retention policy is set to recovery window of 1 days
  1778. Report of files that must be backed up to satisfy 1 days recovery window
  1779. File Days  Name
  1780. ---- ----- -----------------------------------------------------

  1781. RMAN> report need backup;

  1782. RMAN retention policy will be applied to the command
  1783. RMAN retention policy is set to recovery window of 1 days
  1784. Report of files that must be backed up to satisfy 1 days recovery window
  1785. File Days  Name
  1786. ---- ----- -----------------------------------------------------

  1787. RMAN> report need backup;

  1788. RMAN retention policy will be applied to the command
  1789. RMAN retention policy is set to recovery window of 1 days
  1790. Report of files that must be backed up to satisfy 1 days recovery window
  1791. File Days  Name
  1792. ---- ----- -----------------------------------------------------

  1793. RMAN> report need backup;

  1794. RMAN retention policy will be applied to the command
  1795. RMAN retention policy is set to recovery window of 1 days
  1796. Report of files that must be backed up to satisfy 1 days recovery window
  1797. File Days  Name
  1798. ---- ----- -----------------------------------------------------

  1799. RMAN> report need backup;

  1800. RMAN retention policy will be applied to the command
  1801. RMAN retention policy is set to recovery window of 1 days
  1802. Report of files that must be backed up to satisfy 1 days recovery window
  1803. File Days  Name
  1804. ---- ----- -----------------------------------------------------
  1805. 1    2     +DATA/orcl/datafile/system.257.954861995
  1806. 2    2     +DATA/orcl/datafile/sysaux.258.954861995
  1807. 3    2     +DATA/orcl/datafile/undotbs1.259.954861991
  1808. 4    2     +DATA/orcl/datafile/users.256.954863059
  1809. 5    2     +DATA/orcl/datafile/example.265.954861991

  1810. RMAN> exit


  1811. Recovery Manager complete.
  1812. [oracle@station90 ~]$ sqlplus /nolog

  1813. SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 19 08:00:17 2017

  1814. Copyright (c) 1982, 2011, Oracle.  All rights reserved.

  1815. SQL> conn / as sysdba
  1816. Connected.
  1817. SQL> alter tablespace users read only;

  1818. Tablespace altered.

  1819. SQL> exit
  1820. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
  1821. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  1822. and Real Application Testing options
  1823. [oracle@station90 ~]$ rman target /

  1824. Recovery Manager: Release 11.2.0.3.0 - Production on Tue Sep 19 08:00:33 2017

  1825. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  1826. connected to target database: ORCL (DBID=1343950367)

  1827. RMAN> backup tag '4T_INCR0_WHOLE' incremental level 0 database  plus archivelog delete all input;  


  1828. Starting backup at 2017-09-19:08:01:08
  1829. current log archived
  1830. using target database control file instead of recovery catalog
  1831. allocated channel: ORA_SBT_TAPE_1
  1832. channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
  1833. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  1834. allocated channel: ORA_SBT_TAPE_2
  1835. channel ORA_SBT_TAPE_2: SID=210 device type=SBT_TAPE
  1836. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  1837. channel ORA_SBT_TAPE_1: starting archived log backup set
  1838. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1839. input archived log thread=1 sequence=11 RECID=122 STAMP=954979207
  1840. input archived log thread=1 sequence=12 RECID=123 STAMP=954979211
  1841. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:08:01:21
  1842. channel ORA_SBT_TAPE_2: starting archived log backup set
  1843. channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
  1844. input archived log thread=1 sequence=13 RECID=124 STAMP=955065571
  1845. input archived log thread=1 sequence=14 RECID=125 STAMP=955094469
  1846. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-19:08:01:21
  1847. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:08:01:46
  1848. piece handle=25ser5eh_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  1849. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1850. channel ORA_SBT_TAPE_1: deleting archived log(s)
  1851. archived log file name=+FRA/orcl/archivelog/2017_09_18/thread_1_seq_11.319.954979207 RECID=122 STAMP=954979207
  1852. archived log file name=+FRA/orcl/archivelog/2017_09_18/thread_1_seq_12.320.954979211 RECID=123 STAMP=954979211
  1853. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-19:08:01:56
  1854. piece handle=26ser5eh_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  1855. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
  1856. channel ORA_SBT_TAPE_2: deleting archived log(s)
  1857. archived log file name=+FRA/orcl/archivelog/2017_09_18/thread_1_seq_13.321.955065571 RECID=124 STAMP=955065571
  1858. archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_14.322.955094469 RECID=125 STAMP=955094469
  1859. Finished backup at 2017-09-19:08:01:56

  1860. Starting backup at 2017-09-19:08:01:56
  1861. using channel ORA_SBT_TAPE_1
  1862. using channel ORA_SBT_TAPE_2
  1863. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  1864. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  1865. input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
  1866. input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
  1867. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
  1868. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:08:01:57
  1869. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  1870. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  1871. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
  1872. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
  1873. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-19:08:01:57
  1874. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:08:02:22
  1875. piece handle=27ser5fk_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  1876. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1877. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-19:08:02:22
  1878. piece handle=28ser5fl_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  1879. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  1880. Finished backup at 2017-09-19:08:02:22

  1881. Starting backup at 2017-09-19:08:02:22
  1882. current log archived
  1883. using channel ORA_SBT_TAPE_1
  1884. using channel ORA_SBT_TAPE_2
  1885. channel ORA_SBT_TAPE_1: starting archived log backup set
  1886. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  1887. input archived log thread=1 sequence=15 RECID=126 STAMP=955094542
  1888. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:08:02:22
  1889. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:08:02:47
  1890. piece handle=29ser5ge_1_1 tag=4T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  1891. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  1892. channel ORA_SBT_TAPE_1: deleting archived log(s)
  1893. archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_15.322.955094543 RECID=126 STAMP=955094542
  1894. Finished backup at 2017-09-19:08:02:48

  1895. Starting Control File and SPFILE Autobackup at 2017-09-19:08:02:48
  1896. piece handle=c-1343950367-20170919-00 comment=API Version 2.0,MMS Version 10.4.0.4
  1897. Finished Control File and SPFILE Autobackup at 2017-09-19:08:03:13

  1898. RMAN> show all;

  1899. RMAN configuration parameters for database with db_unique_name ORCL are:
  1900. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  1901. CONFIGURE BACKUP OPTIMIZATION ON;
  1902. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  1903. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  1904. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  1905. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  1906. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  1907. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  1908. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  1909. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  1910. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  1911. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  1912. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1913. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  1914. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  1915. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  1916. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  1917. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  1918. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  1919. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  1920. RMAN> list backup ;


  1921. List of Backup Sets
  1922. ===================


  1923. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1924. ------- ---- -- ---------- ----------- ------------ -------------------
  1925. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  1926.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  1927.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  1928.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1929.   SPFILE db_unique_name: ORCL
  1930.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  1931. BS Key  Size       Device Type Elapsed Time Completion Time   
  1932. ------- ---------- ----------- ------------ -------------------
  1933. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  1934.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1935.         Handle: 1rsek46p_1_1   Media: station90-000003

  1936.   List of Archived Logs in backup set 59
  1937.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1938.   ---- ------- ---------- ------------------- ---------- ---------
  1939.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  1940. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1941. ------- ---- -- ---------- ----------- ------------ -------------------
  1942. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  1943.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1944.         Handle: 1tsek47i_1_1   Media: station90-000004
  1945.   List of Datafiles in backup set 60
  1946.   File LV Type Ckp SCN    Ckp Time            Name
  1947.   ---- -- ---- ---------- ------------------- ----
  1948.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  1949.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  1950. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1951. ------- ---- -- ---------- ----------- ------------ -------------------
  1952. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  1953.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1954.         Handle: 1ssek47i_1_1   Media: station90-000003
  1955.   List of Datafiles in backup set 61
  1956.   File LV Type Ckp SCN    Ckp Time            Name
  1957.   ---- -- ---- ---------- ------------------- ----
  1958.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  1959.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  1960.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  1961. BS Key  Size       Device Type Elapsed Time Completion Time   
  1962. ------- ---------- ----------- ------------ -------------------
  1963. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  1964.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  1965.         Handle: 1usek48m_1_1   Media: station90-000003

  1966.   List of Archived Logs in backup set 62
  1967.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1968.   ---- ------- ---------- ------------------- ---------- ---------
  1969.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  1970. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1971. ------- ---- -- ---------- ----------- ------------ -------------------
  1972. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  1973.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  1974.         Handle: c-1343950367-20170916-03   Media: station90-000003
  1975.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  1976.   SPFILE db_unique_name: ORCL
  1977.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  1978. BS Key  Size       Device Type Elapsed Time Completion Time   
  1979. ------- ---------- ----------- ------------ -------------------
  1980. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  1981.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1982.         Handle: 20semoqn_1_1   Media: station90-000003

  1983.   List of Archived Logs in backup set 64
  1984.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  1985.   ---- ------- ---------- ------------------- ---------- ---------
  1986.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  1987. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1988. ------- ---- -- ---------- ----------- ------------ -------------------
  1989. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  1990.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  1991.         Handle: 22semorg_1_1   Media: station90-000004
  1992.   List of Datafiles in backup set 65
  1993.   File LV Type Ckp SCN    Ckp Time            Name
  1994.   ---- -- ---- ---------- ------------------- ----
  1995.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  1996.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  1997. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  1998. ------- ---- -- ---------- ----------- ------------ -------------------
  1999. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  2000.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  2001.         Handle: 21semorg_1_1   Media: station90-000003
  2002.   List of Datafiles in backup set 66
  2003.   File LV Type Ckp SCN    Ckp Time            Name
  2004.   ---- -- ---- ---------- ------------------- ----
  2005.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  2006.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  2007.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  2008. BS Key  Size       Device Type Elapsed Time Completion Time   
  2009. ------- ---------- ----------- ------------ -------------------
  2010. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  2011.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  2012.         Handle: 23semosk_1_1   Media: station90-000003

  2013.   List of Archived Logs in backup set 67
  2014.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2015.   ---- ------- ---------- ------------------- ---------- ---------
  2016.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  2017. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2018. ------- ---- -- ---------- ----------- ------------ -------------------
  2019. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  2020.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  2021.         Handle: c-1343950367-20170917-00   Media: station90-000003
  2022.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2023.   SPFILE db_unique_name: ORCL
  2024.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  2025. BS Key  Size       Device Type Elapsed Time Completion Time   
  2026. ------- ---------- ----------- ------------ -------------------
  2027. 69      82.25M     SBT_TAPE    00:00:15     2017-09-19:08:01:36
  2028.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2029.         Handle: 25ser5eh_1_1   Media: station90-000003

  2030.   List of Archived Logs in backup set 69
  2031.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2032.   ---- ------- ---------- ------------------- ---------- ---------
  2033.   1    11      2116162    2017-09-17:16:02:27 2128971    2017-09-18:00:00:07
  2034.   1    12      2128971    2017-09-18:00:00:07 2149527    2017-09-18:00:00:10

  2035. BS Key  Size       Device Type Elapsed Time Completion Time   
  2036. ------- ---------- ----------- ------------ -------------------
  2037. 70      57.00M     SBT_TAPE    00:00:30     2017-09-19:08:01:51
  2038.         BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2039.         Handle: 26ser5eh_1_1   Media: station90-000004

  2040.   List of Archived Logs in backup set 70
  2041.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2042.   ---- ------- ---------- ------------------- ---------- ---------
  2043.   1    13      2149527    2017-09-18:00:00:10 2158292    2017-09-18:23:59:30
  2044.   1    14      2158292    2017-09-18:23:59:30 2164478    2017-09-19:08:01:08

  2045. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2046. ------- ---- -- ---------- ----------- ------------ -------------------
  2047. 71      Incr 0  87.25M     SBT_TAPE    00:00:21     2017-09-19:08:02:18
  2048.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2049.         Handle: 28ser5fl_1_1   Media: station90-000004
  2050.   List of Datafiles in backup set 71
  2051.   File LV Type Ckp SCN    Ckp Time            Name
  2052.   ---- -- ---- ---------- ------------------- ----
  2053.   3    0  Incr 2164600    2017-09-19:08:02:00 +DATA/orcl/datafile/undotbs1.259.954861991
  2054.   5    0  Incr 2164600    2017-09-19:08:02:00 +DATA/orcl/datafile/example.265.954861991

  2055. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2056. ------- ---- -- ---------- ----------- ------------ -------------------
  2057. 72      Incr 0  1.08G      SBT_TAPE    00:00:25     2017-09-19:08:02:21
  2058.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2059.         Handle: 27ser5fk_1_1   Media: station90-000003
  2060.   List of Datafiles in backup set 72
  2061.   File LV Type Ckp SCN    Ckp Time            Name
  2062.   ---- -- ---- ---------- ------------------- ----
  2063.   1    0  Incr 2164596    2017-09-19:08:01:57 +DATA/orcl/datafile/system.257.954861995
  2064.   2    0  Incr 2164596    2017-09-19:08:01:57 +DATA/orcl/datafile/sysaux.258.954861995
  2065.   4    0  Incr 2164140    2017-09-19:08:00:27 +DATA/orcl/datafile/users.256.954863059

  2066. BS Key  Size       Device Type Elapsed Time Completion Time   
  2067. ------- ---------- ----------- ------------ -------------------
  2068. 73      512.00K    SBT_TAPE    00:00:16     2017-09-19:08:02:38
  2069.         BP Key: 73   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2070.         Handle: 29ser5ge_1_1   Media: station90-000003

  2071.   List of Archived Logs in backup set 73
  2072.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2073.   ---- ------- ---------- ------------------- ---------- ---------
  2074.   1    15      2164478    2017-09-19:08:01:08 2164666    2017-09-19:08:02:22

  2075. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2076. ------- ---- -- ---------- ----------- ------------ -------------------
  2077. 74      Full    9.75M      SBT_TAPE    00:00:24     2017-09-19:08:03:12
  2078.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20170919T080248
  2079.         Handle: c-1343950367-20170919-00   Media: station90-000003
  2080.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2081.   SPFILE db_unique_name: ORCL
  2082.   Control File Included: Ckp SCN: 2164686      Ckp time: 2017-09-19:08:02:48

  2083. RMAN> exit


  2084. Recovery Manager complete.
  2085. [oracle@station90 ~]$ rman target /

  2086. Recovery Manager: Release 11.2.0.3.0 - Production on Tue Sep 19 23:50:09 2017

  2087. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  2088. connected to target database: ORCL (DBID=1343950367)

  2089. RMAN> backup tag '4T2_INCR0_WHOLE' incremental level 0 database  plus archivelog delete all input;  


  2090. Starting backup at 2017-09-19:23:50:25
  2091. current log archived
  2092. using target database control file instead of recovery catalog
  2093. allocated channel: ORA_SBT_TAPE_1
  2094. channel ORA_SBT_TAPE_1: SID=20 device type=SBT_TAPE
  2095. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  2096. allocated channel: ORA_SBT_TAPE_2
  2097. channel ORA_SBT_TAPE_2: SID=147 device type=SBT_TAPE
  2098. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  2099. channel ORA_SBT_TAPE_1: starting archived log backup set
  2100. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2101. input archived log thread=1 sequence=16 RECID=127 STAMP=955151425
  2102. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:23:50:36
  2103. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:23:51:01
  2104. piece handle=2bsest2c_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2105. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2106. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2107. archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_16.322.955151425 RECID=127 STAMP=955151425
  2108. Finished backup at 2017-09-19:23:51:01

  2109. Starting backup at 2017-09-19:23:51:01
  2110. using channel ORA_SBT_TAPE_1
  2111. using channel ORA_SBT_TAPE_2
  2112. skipping datafile 4; already backed up 1 time(s)
  2113. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  2114. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  2115. input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
  2116. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
  2117. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:23:51:02
  2118. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  2119. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  2120. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
  2121. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
  2122. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-19:23:51:02
  2123. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:23:51:27
  2124. piece handle=2csest35_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2125. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2126. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-19:23:51:27
  2127. piece handle=2dsest36_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2128. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  2129. Finished backup at 2017-09-19:23:51:27

  2130. Starting backup at 2017-09-19:23:51:27
  2131. current log archived
  2132. using channel ORA_SBT_TAPE_1
  2133. using channel ORA_SBT_TAPE_2
  2134. channel ORA_SBT_TAPE_1: starting archived log backup set
  2135. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2136. input archived log thread=1 sequence=17 RECID=128 STAMP=955151487
  2137. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-19:23:51:27
  2138. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-19:23:51:42
  2139. piece handle=2esest3v_1_1 tag=4T2_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2140. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
  2141. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2142. archived log file name=+FRA/orcl/archivelog/2017_09_19/thread_1_seq_17.322.955151487 RECID=128 STAMP=955151487
  2143. Finished backup at 2017-09-19:23:51:43

  2144. Starting Control File and SPFILE Autobackup at 2017-09-19:23:51:43
  2145. piece handle=c-1343950367-20170919-01 comment=API Version 2.0,MMS Version 10.4.0.4
  2146. Finished Control File and SPFILE Autobackup at 2017-09-19:23:52:08

  2147. RMAN> list backup ;


  2148. List of Backup Sets
  2149. ===================


  2150. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2151. ------- ---- -- ---------- ----------- ------------ -------------------
  2152. 58      Full    9.45M      DISK        00:00:00     2017-09-16:15:53:00
  2153.         BP Key: 58   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155300
  2154.         Piece Name: +FRA/orcl/autobackup/2017_09_16/s_954863580.318.954863581
  2155.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2156.   SPFILE db_unique_name: ORCL
  2157.   Control File Included: Ckp SCN: 2105817      Ckp time: 2017-09-16:15:53:00

  2158. BS Key  Size       Device Type Elapsed Time Completion Time   
  2159. ------- ---------- ----------- ------------ -------------------
  2160. 59      6.00M      SBT_TAPE    00:00:16     2017-09-16:15:57:29
  2161.         BP Key: 59   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  2162.         Handle: 1rsek46p_1_1   Media: station90-000003

  2163.   List of Archived Logs in backup set 59
  2164.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2165.   ---- ------- ---------- ------------------- ---------- ---------
  2166.   1    7       2102389    2017-09-16:15:31:25 2106112    2017-09-16:15:57:01

  2167. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2168. ------- ---- -- ---------- ----------- ------------ -------------------
  2169. 60      Incr 0  227.50M    SBT_TAPE    00:00:28     2017-09-16:15:58:06
  2170.         BP Key: 60   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  2171.         Handle: 1tsek47i_1_1   Media: station90-000004
  2172.   List of Datafiles in backup set 60
  2173.   File LV Type Ckp SCN    Ckp Time            Name
  2174.   ---- -- ---- ---------- ------------------- ----
  2175.   3    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/undotbs1.259.954861991
  2176.   5    0  Incr 2106146    2017-09-16:15:57:39 +DATA/orcl/datafile/example.265.954861991

  2177. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2178. ------- ---- -- ---------- ----------- ------------ -------------------
  2179. 61      Incr 0  1.06G      SBT_TAPE    00:00:31     2017-09-16:15:58:09
  2180.         BP Key: 61   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  2181.         Handle: 1ssek47i_1_1   Media: station90-000003
  2182.   List of Datafiles in backup set 61
  2183.   File LV Type Ckp SCN    Ckp Time            Name
  2184.   ---- -- ---- ---------- ------------------- ----
  2185.   1    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/system.257.954861995
  2186.   2    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/sysaux.258.954861995
  2187.   4    0  Incr 2106143    2017-09-16:15:57:39 +DATA/orcl/datafile/users.256.954863059

  2188. BS Key  Size       Device Type Elapsed Time Completion Time   
  2189. ------- ---------- ----------- ------------ -------------------
  2190. 62      256.00K    SBT_TAPE    00:00:16     2017-09-16:15:58:30
  2191.         BP Key: 62   Status: AVAILABLE  Compressed: NO  Tag: 1T_INCR0_WHOLE
  2192.         Handle: 1usek48m_1_1   Media: station90-000003

  2193.   List of Archived Logs in backup set 62
  2194.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2195.   ---- ------- ---------- ------------------- ---------- ---------
  2196.   1    8       2106112    2017-09-16:15:57:01 2106178    2017-09-16:15:58:14

  2197. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2198. ------- ---- -- ---------- ----------- ------------ -------------------
  2199. 63      Full    9.50M      SBT_TAPE    00:00:16     2017-09-16:15:58:50
  2200.         BP Key: 63   Status: AVAILABLE  Compressed: NO  Tag: TAG20170916T155834
  2201.         Handle: c-1343950367-20170916-03   Media: station90-000003
  2202.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2203.   SPFILE db_unique_name: ORCL
  2204.   Control File Included: Ckp SCN: 2106194      Ckp time: 2017-09-16:15:58:34

  2205. BS Key  Size       Device Type Elapsed Time Completion Time   
  2206. ------- ---------- ----------- ------------ -------------------
  2207. 64      27.00M     SBT_TAPE    00:00:15     2017-09-17:16:01:42
  2208.         BP Key: 64   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  2209.         Handle: 20semoqn_1_1   Media: station90-000003

  2210.   List of Archived Logs in backup set 64
  2211.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2212.   ---- ------- ---------- ------------------- ---------- ---------
  2213.   1    9       2106178    2017-09-16:15:58:14 2114767    2017-09-17:16:01:14

  2214. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2215. ------- ---- -- ---------- ----------- ------------ -------------------
  2216. 65      Incr 0  100.75M    SBT_TAPE    00:00:25     2017-09-17:16:02:17
  2217.         BP Key: 65   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  2218.         Handle: 22semorg_1_1   Media: station90-000004
  2219.   List of Datafiles in backup set 65
  2220.   File LV Type Ckp SCN    Ckp Time            Name
  2221.   ---- -- ---- ---------- ------------------- ----
  2222.   3    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/undotbs1.259.954861991
  2223.   5    0  Incr 2116132    2017-09-17:16:01:58 +DATA/orcl/datafile/example.265.954861991

  2224. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2225. ------- ---- -- ---------- ----------- ------------ -------------------
  2226. 66      Incr 0  1.07G      SBT_TAPE    00:00:27     2017-09-17:16:02:19
  2227.         BP Key: 66   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  2228.         Handle: 21semorg_1_1   Media: station90-000003
  2229.   List of Datafiles in backup set 66
  2230.   File LV Type Ckp SCN    Ckp Time            Name
  2231.   ---- -- ---- ---------- ------------------- ----
  2232.   1    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/system.257.954861995
  2233.   2    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/sysaux.258.954861995
  2234.   4    0  Incr 2116128    2017-09-17:16:01:53 +DATA/orcl/datafile/users.256.954863059

  2235. BS Key  Size       Device Type Elapsed Time Completion Time   
  2236. ------- ---------- ----------- ------------ -------------------
  2237. 67      13.25M     SBT_TAPE    00:00:15     2017-09-17:16:02:43
  2238.         BP Key: 67   Status: AVAILABLE  Compressed: NO  Tag: 2T_INCR0_WHOLE
  2239.         Handle: 23semosk_1_1   Media: station90-000003

  2240.   List of Archived Logs in backup set 67
  2241.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2242.   ---- ------- ---------- ------------------- ---------- ---------
  2243.   1    10      2114767    2017-09-17:16:01:14 2116162    2017-09-17:16:02:27

  2244. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2245. ------- ---- -- ---------- ----------- ------------ -------------------
  2246. 68      Full    9.50M      SBT_TAPE    00:00:16     2017-09-17:16:03:09
  2247.         BP Key: 68   Status: AVAILABLE  Compressed: NO  Tag: TAG20170917T160253
  2248.         Handle: c-1343950367-20170917-00   Media: station90-000003
  2249.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2250.   SPFILE db_unique_name: ORCL
  2251.   Control File Included: Ckp SCN: 2116250      Ckp time: 2017-09-17:16:02:53

  2252. BS Key  Size       Device Type Elapsed Time Completion Time   
  2253. ------- ---------- ----------- ------------ -------------------
  2254. 69      82.25M     SBT_TAPE    00:00:15     2017-09-19:08:01:36
  2255.         BP Key: 69   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2256.         Handle: 25ser5eh_1_1   Media: station90-000003

  2257.   List of Archived Logs in backup set 69
  2258.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2259.   ---- ------- ---------- ------------------- ---------- ---------
  2260.   1    11      2116162    2017-09-17:16:02:27 2128971    2017-09-18:00:00:07
  2261.   1    12      2128971    2017-09-18:00:00:07 2149527    2017-09-18:00:00:10

  2262. BS Key  Size       Device Type Elapsed Time Completion Time   
  2263. ------- ---------- ----------- ------------ -------------------
  2264. 70      57.00M     SBT_TAPE    00:00:30     2017-09-19:08:01:51
  2265.         BP Key: 70   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2266.         Handle: 26ser5eh_1_1   Media: station90-000004

  2267.   List of Archived Logs in backup set 70
  2268.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2269.   ---- ------- ---------- ------------------- ---------- ---------
  2270.   1    13      2149527    2017-09-18:00:00:10 2158292    2017-09-18:23:59:30
  2271.   1    14      2158292    2017-09-18:23:59:30 2164478    2017-09-19:08:01:08

  2272. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2273. ------- ---- -- ---------- ----------- ------------ -------------------
  2274. 71      Incr 0  87.25M     SBT_TAPE    00:00:21     2017-09-19:08:02:18
  2275.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2276.         Handle: 28ser5fl_1_1   Media: station90-000004
  2277.   List of Datafiles in backup set 71
  2278.   File LV Type Ckp SCN    Ckp Time            Name
  2279.   ---- -- ---- ---------- ------------------- ----
  2280.   3    0  Incr 2164600    2017-09-19:08:02:00 +DATA/orcl/datafile/undotbs1.259.954861991
  2281.   5    0  Incr 2164600    2017-09-19:08:02:00 +DATA/orcl/datafile/example.265.954861991

  2282. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2283. ------- ---- -- ---------- ----------- ------------ -------------------
  2284. 72      Incr 0  1.08G      SBT_TAPE    00:00:25     2017-09-19:08:02:21
  2285.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2286.         Handle: 27ser5fk_1_1   Media: station90-000003
  2287.   List of Datafiles in backup set 72
  2288.   File LV Type Ckp SCN    Ckp Time            Name
  2289.   ---- -- ---- ---------- ------------------- ----
  2290.   1    0  Incr 2164596    2017-09-19:08:01:57 +DATA/orcl/datafile/system.257.954861995
  2291.   2    0  Incr 2164596    2017-09-19:08:01:57 +DATA/orcl/datafile/sysaux.258.954861995
  2292.   4    0  Incr 2164140    2017-09-19:08:00:27 +DATA/orcl/datafile/users.256.954863059

  2293. BS Key  Size       Device Type Elapsed Time Completion Time   
  2294. ------- ---------- ----------- ------------ -------------------
  2295. 73      512.00K    SBT_TAPE    00:00:16     2017-09-19:08:02:38
  2296.         BP Key: 73   Status: AVAILABLE  Compressed: NO  Tag: 4T_INCR0_WHOLE
  2297.         Handle: 29ser5ge_1_1   Media: station90-000003

  2298.   List of Archived Logs in backup set 73
  2299.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2300.   ---- ------- ---------- ------------------- ---------- ---------
  2301.   1    15      2164478    2017-09-19:08:01:08 2164666    2017-09-19:08:02:22

  2302. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2303. ------- ---- -- ---------- ----------- ------------ -------------------
  2304. 74      Full    9.75M      SBT_TAPE    00:00:24     2017-09-19:08:03:12
  2305.         BP Key: 74   Status: AVAILABLE  Compressed: NO  Tag: TAG20170919T080248
  2306.         Handle: c-1343950367-20170919-00   Media: station90-000003
  2307.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2308.   SPFILE db_unique_name: ORCL
  2309.   Control File Included: Ckp SCN: 2164686      Ckp time: 2017-09-19:08:02:48

  2310. BS Key  Size       Device Type Elapsed Time Completion Time   
  2311. ------- ---------- ----------- ------------ -------------------
  2312. 75      21.50M     SBT_TAPE    00:00:15     2017-09-19:23:50:51
  2313.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: 4T2_INCR0_WHOLE
  2314.         Handle: 2bsest2c_1_1   Media: station90-000003

  2315.   List of Archived Logs in backup set 75
  2316.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2317.   ---- ------- ---------- ------------------- ---------- ---------
  2318.   1    16      2164666    2017-09-19:08:02:22 2170841    2017-09-19:23:50:25

  2319. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2320. ------- ---- -- ---------- ----------- ------------ -------------------
  2321. 76      Incr 0  86.25M     SBT_TAPE    00:00:19     2017-09-19:23:51:21
  2322.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: 4T2_INCR0_WHOLE
  2323.         Handle: 2dsest36_1_1   Media: station90-000004
  2324.   List of Datafiles in backup set 76
  2325.   File LV Type Ckp SCN    Ckp Time            Name
  2326.   ---- -- ---- ---------- ------------------- ----
  2327.   3    0  Incr 2171173    2017-09-19:23:51:04 +DATA/orcl/datafile/undotbs1.259.954861991
  2328.   5    0  Incr 2171173    2017-09-19:23:51:04 +DATA/orcl/datafile/example.265.954861991

  2329. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2330. ------- ---- -- ---------- ----------- ------------ -------------------
  2331. 77      Incr 0  1.08G      SBT_TAPE    00:00:23     2017-09-19:23:51:24
  2332.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: 4T2_INCR0_WHOLE
  2333.         Handle: 2csest35_1_1   Media: station90-000003
  2334.   List of Datafiles in backup set 77
  2335.   File LV Type Ckp SCN    Ckp Time            Name
  2336.   ---- -- ---- ---------- ------------------- ----
  2337.   1    0  Incr 2171159    2017-09-19:23:51:02 +DATA/orcl/datafile/system.257.954861995
  2338.   2    0  Incr 2171159    2017-09-19:23:51:02 +DATA/orcl/datafile/sysaux.258.954861995

  2339. BS Key  Size       Device Type Elapsed Time Completion Time   
  2340. ------- ---------- ----------- ------------ -------------------
  2341. 78      2.25M      SBT_TAPE    00:00:15     2017-09-19:23:51:42
  2342.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: 4T2_INCR0_WHOLE
  2343.         Handle: 2esest3v_1_1   Media: station90-000003

  2344.   List of Archived Logs in backup set 78
  2345.   Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  2346.   ---- ------- ---------- ------------------- ---------- ---------
  2347.   1    17      2170841    2017-09-19:23:50:25 2171222    2017-09-19:23:51:27

  2348. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
  2349. ------- ---- -- ---------- ----------- ------------ -------------------
  2350. 79      Full    9.75M      SBT_TAPE    00:00:15     2017-09-19:23:51:58
  2351.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20170919T235143
  2352.         Handle: c-1343950367-20170919-01   Media: station90-000003
  2353.   SPFILE Included: Modification time: 2017-09-16:15:45:57
  2354.   SPFILE db_unique_name: ORCL
  2355.   Control File Included: Ckp SCN: 2171262      Ckp time: 2017-09-19:23:51:43

  2356. RMAN> exit


  2357. Recovery Manager complete.
  2358. [oracle@station90 ~]$ rman target /

  2359. Recovery Manager: Release 11.2.0.3.0 - Production on Wed Sep 20 00:00:05 2017

  2360. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  2361. connected to target database: ORCL (DBID=1343950367)

  2362. RMAN> backup tag '5T_INCR0_WHOLE' incremental level 0 database  plus archivelog delete all input;  


  2363. Starting backup at 2017-09-20:00:00:14
  2364. current log archived
  2365. using target database control file instead of recovery catalog
  2366. allocated channel: ORA_SBT_TAPE_1
  2367. channel ORA_SBT_TAPE_1: SID=16 device type=SBT_TAPE
  2368. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  2369. allocated channel: ORA_SBT_TAPE_2
  2370. channel ORA_SBT_TAPE_2: SID=69 device type=SBT_TAPE
  2371. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  2372. channel ORA_SBT_TAPE_1: starting archived log backup set
  2373. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2374. input archived log thread=1 sequence=18 RECID=129 STAMP=955152015
  2375. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-20:00:00:26
  2376. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-20:00:00:51
  2377. piece handle=2gsestkq_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2378. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2379. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2380. archived log file name=+FRA/orcl/archivelog/2017_09_20/thread_1_seq_18.322.955152015 RECID=129 STAMP=955152015
  2381. Finished backup at 2017-09-20:00:00:51

  2382. Starting backup at 2017-09-20:00:00:51
  2383. using channel ORA_SBT_TAPE_1
  2384. using channel ORA_SBT_TAPE_2
  2385. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
  2386. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  2387. input datafile file number=00001 name=+DATA/orcl/datafile/system.257.954861995
  2388. input datafile file number=00004 name=+DATA/orcl/datafile/users.256.954863059
  2389. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.954861995
  2390. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-20:00:00:52
  2391. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
  2392. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  2393. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.954861991
  2394. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.954861991
  2395. channel ORA_SBT_TAPE_2: starting piece 1 at 2017-09-20:00:00:52
  2396. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-20:00:01:17
  2397. piece handle=2hsestlk_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2398. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2399. channel ORA_SBT_TAPE_2: finished piece 1 at 2017-09-20:00:01:17
  2400. piece handle=2isestlk_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2401. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  2402. Finished backup at 2017-09-20:00:01:17

  2403. Starting backup at 2017-09-20:00:01:17
  2404. current log archived
  2405. using channel ORA_SBT_TAPE_1
  2406. using channel ORA_SBT_TAPE_2
  2407. channel ORA_SBT_TAPE_1: starting archived log backup set
  2408. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
  2409. input archived log thread=1 sequence=19 RECID=130 STAMP=955152078
  2410. channel ORA_SBT_TAPE_1: starting piece 1 at 2017-09-20:00:01:18
  2411. channel ORA_SBT_TAPE_1: finished piece 1 at 2017-09-20:00:01:43
  2412. piece handle=2jsestme_1_1 tag=5T_INCR0_WHOLE comment=API Version 2.0,MMS Version 10.4.0.4
  2413. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  2414. channel ORA_SBT_TAPE_1: deleting archived log(s)
  2415. archived log file name=+FRA/orcl/archivelog/2017_09_20/thread_1_seq_19.322.955152077 RECID=130 STAMP=955152078
  2416. Finished backup at 2017-09-20:00:01:43

  2417. Starting Control File and SPFILE Autobackup at 2017-09-20:00:01:43
  2418. piece handle=c-1343950367-20170920-00 comment=API Version 2.0,MMS Version 10.4.0.4
  2419. Finished Control File and SPFILE Autobackup at 2017-09-20:00:02:07

  2420. RMAN>
复制代码
  1. ORACLE_HOME=...
  2. ORACLE_BASE=...
  3. ORACLE_SID=...

  4. 0,5,10,15,20,25  1 * * 1-5  /u01/app/oracle/product/11.2.0/dbhome_1/bin/rman target / cmdfile=/home/oracle/ttio.rcv
复制代码
  1. SQL> conn / as sysdba
  2. Connected.
  3. SQL> create directory dir1 as '/home/oracle';

  4. Directory created.

  5. SQL> exit
  6. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  7. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  8. [oracle@station90 ~]$ expdp system/oracle_4U directory=dir1 dumpfile=u90.dmp schemas='U90'

  9. Export: Release 11.2.0.1.0 - Production on Wed Sep 20 01:27:36 2017

  10. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  11. UDE-28002: operation generated ORACLE error 28002
  12. ORA-28002: the password will expire within 7 days

  13. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  14. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  15. Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=dir1 dumpfile=u90.dmp schemas=U90
  16. Estimate in progress using BLOCKS method...
  17. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
  18. Total estimation using BLOCKS method: 1.75 MB
  19. Processing object type SCHEMA_EXPORT/USER
  20. Processing object type SCHEMA_EXPORT/ROLE_GRANT
  21. Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
  22. Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
  23. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  24. Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
  25. Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
  26. Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
  27. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  28. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  29. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  30. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  31. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
  32. Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
  33. Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
  34. Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
  35. Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
  36. Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
  37. Processing object type SCHEMA_EXPORT/VIEW/VIEW
  38. Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
  39. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
  40. Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
  41. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
  42. Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
  43. . . exported "U90"."CFS"                                 89.83 KB     157 rows
  44. . . exported "U90"."BCF"                                 10.29 KB       1 rows
  45. . . exported "U90"."BDF"                                 16.85 KB       5 rows
  46. . . exported "U90"."BP"                                  15.61 KB       5 rows
  47. . . exported "U90"."BRL"                                 10.33 KB       2 rows
  48. . . exported "U90"."BS"                                  12.60 KB       5 rows
  49. . . exported "U90"."BSF"                                 7.835 KB       1 rows
  50. . . exported "U90"."CKP"                                 8.664 KB       1 rows
  51. . . exported "U90"."CONF"                                7.945 KB       8 rows
  52. . . exported "U90"."CONFIG"                              5.421 KB       1 rows
  53. . . exported "U90"."DB"                                  5.820 KB       1 rows
  54. . . exported "U90"."DBINC"                               7.476 KB       2 rows
  55. . . exported "U90"."DF"                                  15.05 KB       5 rows
  56. . . exported "U90"."NODE"                                20.59 KB       1 rows
  57. . . exported "U90"."OFFR"                                8.828 KB       5 rows
  58. . . exported "U90"."ORL"                                 7.796 KB       6 rows
  59. . . exported "U90"."RCVER"                               5.023 KB       1 rows
  60. . . exported "U90"."RLH"                                 8.726 KB       3 rows
  61. . . exported "U90"."ROUT"                                7.554 KB      11 rows
  62. . . exported "U90"."RSR"                                 14.08 KB       2 rows
  63. . . exported "U90"."RT"                                  7.828 KB       1 rows
  64. . . exported "U90"."SITE_DFATT"                          6.062 KB       5 rows
  65. . . exported "U90"."SITE_TFATT"                          8.265 KB       1 rows
  66. . . exported "U90"."TF"                                  8.226 KB       1 rows
  67. . . exported "U90"."TS"                                  9.257 KB       6 rows
  68. . . exported "U90"."TSATT"                               7.125 KB       6 rows
  69. . . exported "U90"."AL"                                      0 KB       0 rows
  70. . . exported "U90"."BCB"                                     0 KB       0 rows
  71. . . exported "U90"."BCR"                                     0 KB       0 rows
  72. . . exported "U90"."CCB"                                     0 KB       0 rows
  73. . . exported "U90"."CCF"                                     0 KB       0 rows
  74. . . exported "U90"."CDF"                                     0 KB       0 rows
  75. . . exported "U90"."FB"                                      0 KB       0 rows
  76. . . exported "U90"."GRSP"                                    0 KB       0 rows
  77. . . exported "U90"."NRSP"                                    0 KB       0 rows
  78. . . exported "U90"."RR"                                      0 KB       0 rows
  79. . . exported "U90"."SCR"                                     0 KB       0 rows
  80. . . exported "U90"."SCRL"                                    0 KB       0 rows
  81. . . exported "U90"."TEMPRES"                                 0 KB       0 rows
  82. . . exported "U90"."VPC_DATABASES"                           0 KB       0 rows
  83. . . exported "U90"."VPC_USERS"                               0 KB       0 rows
  84. . . exported "U90"."XAL"                                     0 KB       0 rows
  85. . . exported "U90"."XCF"                                     0 KB       0 rows
  86. . . exported "U90"."XDF"                                     0 KB       0 rows
  87. Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
  88. ******************************************************************************
  89. Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
  90.   /home/oracle/u90.dmp
  91. Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 01:28:20

  92. [oracle@station90 ~]$ sqlplus /nolog

  93. SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 20 01:28:47 2017

  94. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  95. SQL> conn / as sysdba
  96. Connected.
  97. SQL> drop user u90 cascade;

  98. User dropped.

  99. SQL> exit
  100. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  101. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  102. [oracle@station90 ~]$ impdp system/oracle_4U directory=dir1 dumpfile=u90.dmp schemas='U90'

  103. Import: Release 11.2.0.1.0 - Production on Wed Sep 20 01:29:38 2017

  104. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  105. UDI-28002: operation generated ORACLE error 28002
  106. ORA-28002: the password will expire within 7 days

  107. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  108. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  109. Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
  110. Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** directory=dir1 dumpfile=u90.dmp schemas=U90
  111. Processing object type SCHEMA_EXPORT/USER
  112. Processing object type SCHEMA_EXPORT/ROLE_GRANT
  113. Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
  114. Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
  115. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  116. Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
  117. Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
  118. Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
  119. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  120. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
  121. . . imported "U90"."CFS"                                 89.83 KB     157 rows
  122. . . imported "U90"."BCF"                                 10.29 KB       1 rows
  123. . . imported "U90"."BDF"                                 16.85 KB       5 rows
  124. . . imported "U90"."BP"                                  15.61 KB       5 rows
  125. . . imported "U90"."BRL"                                 10.33 KB       2 rows
  126. . . imported "U90"."BS"                                  12.60 KB       5 rows
  127. . . imported "U90"."BSF"                                 7.835 KB       1 rows
  128. . . imported "U90"."CKP"                                 8.664 KB       1 rows
  129. . . imported "U90"."CONF"                                7.945 KB       8 rows
  130. . . imported "U90"."CONFIG"                              5.421 KB       1 rows
  131. . . imported "U90"."DB"                                  5.820 KB       1 rows
  132. . . imported "U90"."DBINC"                               7.476 KB       2 rows
  133. . . imported "U90"."DF"                                  15.05 KB       5 rows
  134. . . imported "U90"."NODE"                                20.59 KB       1 rows
  135. . . imported "U90"."OFFR"                                8.828 KB       5 rows
  136. . . imported "U90"."ORL"                                 7.796 KB       6 rows
  137. . . imported "U90"."RCVER"                               5.023 KB       1 rows
  138. . . imported "U90"."RLH"                                 8.726 KB       3 rows
  139. . . imported "U90"."ROUT"                                7.554 KB      11 rows
  140. . . imported "U90"."RSR"                                 14.08 KB       2 rows
  141. . . imported "U90"."RT"                                  7.828 KB       1 rows
  142. . . imported "U90"."SITE_DFATT"                          6.062 KB       5 rows
  143. . . imported "U90"."SITE_TFATT"                          8.265 KB       1 rows
  144. . . imported "U90"."TF"                                  8.226 KB       1 rows
  145. . . imported "U90"."TS"                                  9.257 KB       6 rows
  146. . . imported "U90"."TSATT"                               7.125 KB       6 rows
  147. . . imported "U90"."AL"                                      0 KB       0 rows
  148. . . imported "U90"."BCB"                                     0 KB       0 rows
  149. . . imported "U90"."BCR"                                     0 KB       0 rows
  150. . . imported "U90"."CCB"                                     0 KB       0 rows
  151. . . imported "U90"."CCF"                                     0 KB       0 rows
  152. . . imported "U90"."CDF"                                     0 KB       0 rows
  153. . . imported "U90"."FB"                                      0 KB       0 rows
  154. . . imported "U90"."GRSP"                                    0 KB       0 rows
  155. . . imported "U90"."NRSP"                                    0 KB       0 rows
  156. . . imported "U90"."RR"                                      0 KB       0 rows
  157. . . imported "U90"."SCR"                                     0 KB       0 rows
  158. . . imported "U90"."SCRL"                                    0 KB       0 rows
  159. . . imported "U90"."TEMPRES"                                 0 KB       0 rows
  160. . . imported "U90"."VPC_DATABASES"                           0 KB       0 rows
  161. . . imported "U90"."VPC_USERS"                               0 KB       0 rows
  162. . . imported "U90"."XAL"                                     0 KB       0 rows
  163. . . imported "U90"."XCF"                                     0 KB       0 rows
  164. . . imported "U90"."XDF"                                     0 KB       0 rows
  165. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  166. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  167. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  168. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
  169. Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
  170. Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
  171. Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
  172. Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
  173. Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
  174. Processing object type SCHEMA_EXPORT/VIEW/VIEW
  175. Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
  176. Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
  177. Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
  178. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
  179. Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
  180. Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 01:30:36

  181. [oracle@station90 ~]$ sqlplus /nolog

  182. SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 20 01:30:48 2017

  183. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  184. SQL> coonn / as sysdba
  185. SP2-0734: unknown command beginning "coonn / as..." - rest of line ignored.
  186. SQL> conn / as sysdba
  187. Connected.
  188. SQL> alter user u90 identified by oracle_4U account unlock;

  189. User altered.

  190. SQL>

复制代码




回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 01:12 , Processed in 0.052992 second(s), 27 queries .

快速回复 返回顶部 返回列表