1、查看角色的权限
select * from dba_sys_privs where GRANTEE='RESOURCE';
select * from dba_sys_privs where GRANTEE='CONNECT';
2、查看数据库版本
select version from v$instance;
3、查看登录用户的权限
上图是system用户的权限
以上是普通用户的权限
select * from session_privs;
4、查看用户所在表空间
select username,default_tablespace from dba_users;
5、查看表空间的名称及大小
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
6、查看表空间物理文件的名称及大小
SELECT tablespace_name,file_id, file_name,round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;
7、查看表空间的使用情况
SELECT SUM(bytes) / (1024 * 1024) AS free_space, tablespace_name
FROM dba_free_space
GROUP BY tablespace_name;
SELECT a.tablespace_name, a.bytes total, b.bytes used, c.bytes free,
(b.bytes * 100) / a.bytes "% USED ",
(c.bytes * 100) / a.bytes "% FREE "
FROM sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c
WHERE a.tablespace_name = b.tablespace_name
AND a.tablespace_name = c.tablespace_name;
SELECT a.tablespace_name "表空间名",
total "表空间大小",
free "表空间剩余大小",
(total - free) "表空间使用大小",
total / (1024 * 1024 * 1024) "表空间大小(G)",
free / (1024 * 1024 * 1024) "表空间剩余大小(G)",
(total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)",
round((total - free) / total, 4) * 100 "使用率 %"
FROM (SELECT tablespace_name, SUM(bytes) free
FROM dba_free_space
GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM(bytes) total
FROM dba_data_files
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name
8、查看数据文件情况
select name, bytes/1024/1024/1024 GB_SIZE, creation_time, last_time from v$datafile order by creation_time desc;
按月统计如下：
9、查看控制文件和日志文件
查看控制文件：
select * from v$controlfile
查看控制文件中各个记录文档段的信息：
select * from v$controlfile_record_section;
重做日志缓冲区(Redo Log Buffer)：
Oracle重做日志的概念是记录每个数据块插入某个值或者删除某个值的语句。假设某个Update语句更新了10个数据块，则按照Oracle重做日志的概念，会针对每个数据块记录一对删除旧值和插入新值的语句，因为有10个数据块，所以会有10对类似的语句被记录下来。而为了减少I/O的次数，Oracle在内存结构里的系统全局区中，划分一块内存块专门存放这些变更的数据，这块区域就叫做重做日志缓冲区(Redo Log Buffer)，所以说，重做日志缓冲区是用来跟踪并记录最近变更过的数据记录的。
Redo Log Buffer是 SGA中一段保存数据库修改信息的缓存。这些信息被存储在重做条目(Redo Entry)中.重做条目中包含了由于INSERT、UPDATE、DELETE、CREATE、ALTER或DROP所做的修改操作而需要对数据库重新组织或重做的必须信息。在必要时，重做条目还可以用于数据库恢复。重做条目是Oracle数据库进程从用户内存中拷贝到Redo Log Buffer中去的。重做条目在内存中是连续相连的。后台进程LGWR负责将Redo Log Buffer中的信息写入到磁盘上活动的重做日志文件（Redo Log File）或文件组中去的。参数LOG_BUFFER决定了Redo Log Buffer的大小。它的默认值是512K（一般这个大小都是足够的），最大可以到4G。当系统中存在很多的大事务或者事务数量非常多时，可能会导致日志文件IO增加，降低性能。这时就可以考虑增加LOG_BUFFER。
查看数据库归档模式：
查看当前在线重做日志组状态：
select group#,members,bytes/1024/1024 MB,status from v$log;
select * from v$log;
日志组状态说明：
UNUSED ： 表示该联机重做日志文件组对应的文件还从未被写入过数据，通常是刚刚创建的联机重做日志文件或重建后的联机重做日志文件。
CURRENT ： 表示当前正在使用的日志文件组。该联机重做日志组是活动的。
ACTIVE ： 表示该组是活动的但不是当前组，实例恢复时需要这组日志。如果处于这一状态，表示虽然当前并未使用，文件中的数据没有全部写入数据文件，一旦需要实例恢复，必须借助该文件中保存的内容。可以是已归档或没归档。
INACTIVE： 表示实例恢复已不再需要这组联机重做日志组了，文件中的数据全部写入数据文件。该组联机重做日志当前处于空闲状态。可以是已归档或没归档。
CLEARING：在执行了 ALTER DATABASE CLEAR LOGFILE 后，表示该组重做日志文件正被重建（重建后该状态会变成UNUSED）。
CLEARING_CURRENT：表示该组重做日志重建时出现错误，如io错误。
查看在线日志文件物理位置和所属分组：
select * from v$logfile order by group#;
10、查看归档日志文件情况
数据库的归档与非归档模式：
1．当数据库处于NOACRCHIVELOG模式时，不对重做日志文件进行归档，直接覆盖旧的重做日志文件，此时数据库只能从例程失败中进行恢复。
特点：
a. 发生日志切换时（alter system switch logfile），LGWR后台进程可以无条件覆盖原来的已经变为非活动的（INACTIVE）重做日志文件的内容。
b. 进行数据库备份时，必须先使用SHUTDOWN 或者SHUTDOWN IMMEDIATE命令先关闭数据库，然后才能通过操作系统备份所有的物理文件。即冷备份。不能进行联机的热备份。
c. NOACRCHIVELOG模式时，只能保护数据库免于例程失败，但不能保护数据库免于介质失败。
d. NOACRCHIVELOG模式不需要考虑存储空间的问题。
2．当数据库处于ACRCHIVELOG模式时候，系统通过后台进程ARCn来帮助DBA自动完成对重做日志文件进行归档，归档之后才覆盖旧的重做日志文件，并将其复制到一个指定的位置，成为归档日志文件，此时数据库还能进一步从介质失败中恢复。即可将数据的损失减少到最小，可用性提高到最高。
特点：
a. 当ACRCHIVELOG模式时。可以对数据库进行联机的热备份。
b. 当出现数据文件损坏时，除了SYSTEM表空间的数据文件，其他表空间都可以在数据库处于OPEN时恢复。
c. 执行数据库备份时，不仅可以进行完成恢复，也可以指定恢复到某个特定的时间点。
归档日志文件：是处于非活动（INACTIVE）的状态的重做日志文件的备份。它对ORACLE数据库的备份和恢复起至关重要的作用。是联机重做日志文件的一个副本，与被复制的成员完成一样，即重做记录相同，日志序列号相同。
查看每天的归档日志情况
select trunc(COMPLETION_TIME,'DDD') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024/1024 SIZE_GB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,'DDD') order by 1;
select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024/1024 SIZE_GB from V$ARCHIVED_LOG group by trunc(COMPLETION_TIME) order by 1;
查看每小时的归档日志情况
select trunc(COMPLETION_TIME,'HH24') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024/1024 SIZE_GB from V$ARCHIVED_LOG group by trunc(COMPLETION_TIME,'HH24') order by 1;
查看每个月的归档日志情况
select trunc(COMPLETION_TIME,'MM') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024/1024 SIZE_GB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,'MM') order by 1;
按星期统计：
select trunc(COMPLETION_TIME,'WW') TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024/1024 SIZE_GB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,'WW') order by 1;
11、客户端查询结果为乱码（更改客户端字符集）
从环境变量-->系统变量中更改：
在命令行中查看更改结果：
12、服务名和服务命名
在选择Database时，用命名后的服务非常方便，如右图：
等同方式1：
等同方式2：
等同方式3：
13、导出dmp文件命令exp的使用
windows中的批处理: exp username/"""passw@rd"""@orcl file=d:\abc.dmp owner=username log=d:\abc.log
windows中的命令行：exp username/"passw@rd"@ip:port/orcl ......
aix中的命令行：exp username/\"passw@rd\"@orcl ....
14、rman备份归档日志的使用
脚本：
export ORACLE_SID=abc1
rman target / << EOF
backup archivelog all format '/arch_rman/%d_T_%U_arc.rman' delete input;
exit;
EOF
备份前：
$ pwd
/arch_rman
$ ls
abc_T_0esm10kp_1_1_arc.rman
abc_T_0fsm10oa_1_1_arc.rman
abc_T_0gsm10rr_1_1_arc.rman
abc_T_0hsm10vd_1_1_arc.rman
abc_T_0ism1131_1_1_arc.rman
abc_T_0jsm116l_1_1_arc.rman
abc_T_0ksm11a5_1_1_arc.rman
abc_T_0lsm11dn_1_1_arc.rman
abc_T_0msm11h9_1_1_arc.rman
abc_T_0nsm11kr_1_1_arc.rman
abc_T_0osm11oe_1_1_arc.rman
abc_T_0psm11rv_1_1_arc.rman
abc_T_0qsm11vh_1_1_arc.rman
abc_T_0rsm1234_1_1_arc.rman
abc_T_0ssm126k_1_1_arc.rman
abc_T_0tsm12ak_1_1_arc.rman
abc_T_0usm12d2_1_1_arc.rman
abc_T_0vsm12el_1_1_arc.rman
abc_T_10sm12fj_1_1_arc.rman
abc_T_11sm12gi_1_1_arc.rman
nohup.out
rman_arch_ldhygeia.sh
rman_arch_abc.sh
RMAN> list archivelog all;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - ------------------- ----
2348 1 2090 A 2017/12/13 12:09:35 +DATA/abc/archivelog/2017_12_13/thread_1_seq_2090.25218.962639423
2349 1 2091 A 2017/12/13 15:50:22 +DATA/abc/archivelog/2017_12_14/thread_1_seq_2091.25130.962670153
2351 1 2092 A 2017/12/14 00:22:31 +DATA/abc/archivelog/2017_12_14/thread_1_seq_2092.26206.962709235
2352 1 2093 A 2017/12/14 11:13:54 +DATA/abc/archivelog/2017_12_14/thread_1_seq_2093.33587.962727251
2353 1 2094 A 2017/12/14 16:14:10 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2094.33486.962768827
2355 1 2095 A 2017/12/15 03:47:07 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2095.33474.962785215
2356 1 2096 A 2017/12/15 08:20:14 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2096.33469.962785317
2357 1 2097 A 2017/12/15 08:21:57 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2097.33468.962785405
2358 1 2098 A 2017/12/15 08:23:25 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2098.33466.962785475
2360 1 2099 A 2017/12/15 08:24:34 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2099.33461.962785539
2361 1 2100 A 2017/12/15 08:25:38 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2100.33448.962787533
2363 1 2101 A 2017/12/15 08:58:52 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2101.29522.962788787
2364 1 2102 A 2017/12/15 09:19:46 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2102.29490.962790307
2365 1 2103 A 2017/12/15 09:45:06 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2103.29466.962791577
2367 1 2104 A 2017/12/15 10:06:17 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2104.29452.962794047
2368 1 2105 A 2017/12/15 10:47:27 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2105.29430.962796013
2369 1 2106 A 2017/12/15 11:20:12 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2106.19047.962810259
2371 1 2107 A 2017/12/15 15:17:38 +DATA/abc/archivelog/2017_12_15/thread_1_seq_2107.18946.962833323
2372 1 2108 A 2017/12/15 21:42:01 +DATA/abc/archivelog/2017_12_16/thread_1_seq_2108.19828.962901925
2373 1 2109 A 2017/12/16 16:45:24 +DATA/abc/archivelog/2017_12_17/thread_1_seq_2109.19330.962971141
2374 1 2110 A 2017/12/17 11:59:00 +DATA/abc/archivelog/2017_12_17/thread_1_seq_2110.19264.962999151
2376 1 2111 A 2017/12/17 19:45:51 +DATA/abc/archivelog/2017_12_18/thread_1_seq_2111.23161.963051077
2377 1 2112 A 2017/12/18 10:11:17 +DATA/abc/archivelog/2017_12_18/thread_1_seq_2112.23107.963064719
2379 1 2113 A 2017/12/18 13:58:38 +DATA/abc/archivelog/2017_12_18/thread_1_seq_2113.23078.963072617
2380 1 2114 A 2017/12/18 16:10:16 +DATA/abc/archivelog/2017_12_18/thread_1_seq_2114.25004.963090529
2381 1 2115 A 2017/12/18 21:08:49 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2115.24980.963131055
2382 1 2116 A 2017/12/19 08:24:14 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2116.24978.963131199
2384 1 2117 A 2017/12/19 08:26:38 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2117.24975.963131315
2385 1 2118 A 2017/12/19 08:28:34 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2118.24972.963131403
2386 1 2119 A 2017/12/19 08:30:02 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2119.24970.963131459
2388 1 2120 A 2017/12/19 08:30:59 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2120.24967.963131501
2389 1 2121 A 2017/12/19 08:31:41 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2121.28896.963142637
2391 1 2122 A 2017/12/19 11:37:16 +DATA/abc/archivelog/2017_12_19/thread_1_seq_2122.28809.963156295
2392 1 2123 A 2017/12/19 15:24:53 +DATA/abc/archivelog/2017_12_20/thread_1_seq_2123.24432.963215995
2393 1 2124 A 2017/12/20 07:59:54 +DATA/abc/archivelog/2017_12_20/thread_1_seq_2124.24428.963216097
2395 1 2125 A 2017/12/20 08:01:36 +DATA/abc/archivelog/2017_12_20/thread_1_seq_2125.24346.963226037
2396 1 2126 A 2017/12/20 10:47:17 +DATA/abc/archivelog/2017_12_20/thread_1_seq_2126.20923.963238571
2397 1 2127 A 2017/12/20 14:16:10 +DATA/abc/archivelog/2017_12_20/thread_1_seq_2127.20869.963243431
2399 1 2128 A 2017/12/20 15:37:10 +DATA/abc/archivelog/2017_12_20/thread_1_seq_2128.20803.963251453
2400 1 2129 A 2017/12/20 17:50:53 +DATA/abc/archivelog/2017_12_21/thread_1_seq_2129.20688.963306957
2401 1 2130 A 2017/12/21 09:15:56 +DATA/abc/archivelog/2017_12_21/thread_1_seq_2130.20556.963318365
2403 1 2131 A 2017/12/21 12:26:05 +DATA/abc/archivelog/2017_12_21/thread_1_seq_2131.20110.963352817
2404 1 2132 A 2017/12/21 22:00:16 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2132.20080.963374531
2405 1 2133 A 2017/12/22 04:02:11 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2133.20076.963375215
2407 1 2134 A 2017/12/22 04:13:34 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2134.20072.963375233
2408 1 2135 A 2017/12/22 04:13:52 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2135.20066.963375307
2409 1 2136 A 2017/12/22 04:15:06 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2136.20063.963375341
2411 1 2137 A 2017/12/22 04:15:41 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2137.23108.963413793
2412 1 2138 A 2017/12/22 14:56:32 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2138.19219.963420109
2413 1 2139 A 2017/12/22 16:41:47 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2139.19212.963421083
2415 1 2140 A 2017/12/22 16:58:03 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2140.19194.963422197
2416 1 2141 A 2017/12/22 17:16:36 +DATA/abc/archivelog/2017_12_22/thread_1_seq_2141.19149.963428147
2417 1 2142 A 2017/12/22 18:55:46 +DATA/abc/archivelog/2017_12_23/thread_1_seq_2142.19091.963459381
2419 1 2143 A 2017/12/23 03:36:20 +DATA/abc/archivelog/2017_12_23/thread_1_seq_2143.20921.963499721
2420 1 2144 A 2017/12/23 14:48:38 +DATA/abc/archivelog/2017_12_24/thread_1_seq_2144.23347.963585663
2421 1 2145 A 2017/12/24 14:41:02 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2145.21772.963655049
2423 1 2146 A 2017/12/25 09:57:29 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2146.19540.963672755
2424 1 2147 A 2017/12/25 14:52:35 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2147.25657.963677735
2425 1 2148 A 2017/12/25 16:15:34 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2148.25650.963677839
2426 1 2149 A 2017/12/25 16:17:19 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2149.25648.963677909
2428 1 2150 A 2017/12/25 16:18:28 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2150.25644.963677961
2429 1 2151 A 2017/12/25 16:19:21 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2151.25642.963678005
2431 1 2152 A 2017/12/25 16:20:04 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2152.25641.963678045
2432 1 2153 A 2017/12/25 16:20:45 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2153.25638.963678091
2433 1 2154 A 2017/12/25 16:21:30 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2154.25636.963678129
2435 1 2155 A 2017/12/25 16:22:08 +DATA/abc/archivelog/2017_12_25/thread_1_seq_2155.25615.963679519
2436 1 2156 A 2017/12/25 16:45:18 +DATA/abc/archivelog/2017_12_26/thread_1_seq_2156.33462.963742359
2437 1 2157 A 2017/12/26 10:12:39 +DATA/abc/archivelog/2017_12_26/thread_1_seq_2157.30291.963763153
2438 1 2158 A 2017/12/26 15:59:13 +DATA/abc/archivelog/2017_12_26/thread_1_seq_2158.30274.963764477
2440 1 2159 A 2017/12/26 16:21:17 +DATA/abc/archivelog/2017_12_26/thread_1_seq_2159.30263.963765953
2441 1 2160 A 2017/12/26 16:45:52 +DATA/abc/archivelog/2017_12_27/thread_1_seq_2160.30179.963823815
2443 1 2161 A 2017/12/27 08:50:14 +DATA/abc/archivelog/2017_12_27/thread_1_seq_2161.20849.963850577
2444 1 2162 A 2017/12/27 16:16:16 +DATA/abc/archivelog/2017_12_27/thread_1_seq_2162.20838.963852295
2445 1 2163 A 2017/12/27 16:44:55 +DATA/abc/archivelog/2017_12_27/thread_1_seq_2163.20828.963854343
2447 1 2164 A 2017/12/27 17:19:03 +DATA/abc/archivelog/2017_12_28/thread_1_seq_2164.32573.963908411
2448 1 2165 A 2017/12/28 08:20:10 +DATA/abc/archivelog/2017_12_28/thread_1_seq_2165.32565.963909531
2449 1 2166 A 2017/12/28 08:38:50 +DATA/abc/archivelog/2017_12_28/thread_1_seq_2166.32552.963910895
2451 1 2167 A 2017/12/28 09:01:34 +DATA/abc/archivelog/2017_12_28/thread_1_seq_2167.32487.963918029
2452 1 2168 A 2017/12/28 11:00:29 +DATA/abc/archivelog/2017_12_28/thread_1_seq_2168.33071.963961211
2453 1 2169 A 2017/12/28 23:00:10 +DATA/abc/archivelog/2017_12_29/thread_1_seq_2169.30193.964006373
2455 1 2170 A 2017/12/29 11:32:52 +DATA/abc/archivelog/2017_12_29/thread_1_seq_2170.30157.964016983
2456 1 2171 A 2017/12/29 14:29:43 +DATA/abc/archivelog/2017_12_29/thread_1_seq_2171.30149.964018713
2457 1 2172 A 2017/12/29 14:58:33 +DATA/abc/archivelog/2017_12_29/thread_1_seq_2172.30125.964023167
2458 1 2173 A 2017/12/29 16:12:47 +DATA/abc/archivelog/2017_12_29/thread_1_seq_2173.32975.964039973
2460 1 2174 A 2017/12/29 20:52:52 +DATA/abc/archivelog/2017_12_29/thread_1_seq_2174.32962.964042043
2461 1 2175 A 2017/12/29 21:27:23 +DATA/abc/archivelog/2018_01_01/thread_1_seq_2175.22948.964249279
2463 1 2176 A 2018/01/01 07:01:18 +DATA/abc/archivelog/2018_01_02/thread_1_seq_2176.26328.964368129
2464 1 2177 A 2018/01/02 16:02:08 +DATA/abc/archivelog/2018_01_02/thread_1_seq_2177.26276.964386149
2465 1 2178 A 2018/01/02 21:02:28 +DATA/abc/archivelog/2018_01_02/thread_1_seq_2178.18771.964393311
2467 1 2179 A 2018/01/02 23:01:50 +DATA/abc/archivelog/2018_01_03/thread_1_seq_2179.18763.964422165
2468 1 2180 A 2018/01/03 07:02:43 +DATA/abc/archivelog/2018_01_03/thread_1_seq_2180.25151.964455345
2469 1 2181 A 2018/01/03 16:15:45 +DATA/abc/archivelog/2018_01_03/thread_1_seq_2181.25148.964455439
2470 1 2182 A 2018/01/03 16:17:19 +DATA/abc/archivelog/2018_01_03/thread_1_seq_2182.32308.964474721
2472 1 2183 A 2018/01/03 21:38:41 +DATA/abc/archivelog/2018_01_04/thread_1_seq_2183.23681.964544071
2473 1 2184 A 2018/01/04 16:54:30 +DATA/abc/archivelog/2018_01_06/thread_1_seq_2184.34206.964681491
2475 1 2185 A 2018/01/06 07:04:50 +DATA/abc/archivelog/2018_01_08/thread_1_seq_2185.20105.964908011
2476 1 2186 A 2018/01/08 22:00:11 +DATA/abc/archivelog/2018_01_09/thread_1_seq_2186.20085.964947391
2477 1 2187 A 2018/01/09 08:56:31 +DATA/abc/archivelog/2018_01_10/thread_1_seq_2187.27293.965057589
2478 1 2188 A 2018/01/10 15:33:08 +DATA/abc/archivelog/2018_01_12/thread_1_seq_2188.23922.965227297
2480 1 2189 A 2018/01/12 14:41:37 +DATA/abc/archivelog/2018_01_13/thread_1_seq_2189.31746.965336415
2550 1 2240 A 2018/02/02 17:10:34 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2240.31408.967051009
2551 1 2241 A 2018/02/02 17:16:49 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2241.31405.967051807
2553 1 2242 A 2018/02/02 17:30:07 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2242.31389.967055217
2554 1 2243 A 2018/02/02 18:26:57 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2243.31382.967058895
2555 1 2244 A 2018/02/02 19:28:14 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2244.31374.967062855
2557 1 2245 A 2018/02/02 20:34:14 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2245.31369.967065053
2558 1 2246 A 2018/02/02 21:10:52 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2246.31366.967066147
2559 1 2247 A 2018/02/02 21:29:06 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2247.31364.967066203
2561 1 2248 A 2018/02/02 21:30:02 +DATA/abc/archivelog/2018_02_02/thread_1_seq_2248.31352.967069361
2562 1 2249 A 2018/02/02 22:22:41 +DATA/abc/archivelog/2018_02_05/thread_1_seq_2249.24074.967280427
2563 1 2250 A 2018/02/05 09:00:27 +DATA/abc/archivelog/2018_02_05/thread_1_seq_2250.24031.967284041
2564 1 2251 A 2018/02/05 10:00:40 +DATA/abc/archivelog/2018_02_06/thread_1_seq_2251.31479.967374729
2566 1 2252 A 2018/02/06 11:12:08 +DATA/abc/archivelog/2018_02_08/thread_1_seq_2252.32957.967548627
2568 1 2253 A 2018/02/08 11:30:26 +DATA/abc/archivelog/2018_02_11/thread_1_seq_2253.27975.967820925
2569 1 2254 A 2018/02/11 15:08:44 +DATA/abc/archivelog/2018_02_13/thread_1_seq_2254.19904.967964809
2571 1 2255 A 2018/02/13 07:06:47 +DATA/abc/archivelog/2018_02_16/thread_1_seq_2255.25057.968224135
2572 1 2256 A 2018/02/16 07:08:54 +DATA/abc/archivelog/2018_02_19/thread_1_seq_2256.19659.968461241
2573 1 2257 A 2018/02/19 01:00:40 +DATA/abc/archivelog/2018_02_22/thread_1_seq_2257.21382.968738417
2575 1 2258 A 2018/02/22 06:00:16 +DATA/abc/archivelog/2018_02_23/thread_1_seq_2258.30372.968836399
2576 1 2259 A 2018/02/23 09:13:19 +DATA/abc/archivelog/2018_02_23/thread_1_seq_2259.30351.968841745
2577 1 2260 A 2018/02/23 10:42:25 +DATA/abc/archivelog/2018_02_23/thread_1_seq_2260.30315.968856653
2579 1 2261 A 2018/02/23 14:50:53 +DATA/abc/archivelog/2018_02_23/thread_1_seq_2261.21906.968861931
2580 1 2262 A 2018/02/23 16:18:50 +DATA/abc/archivelog/2018_02_23/thread_1_seq_2262.34093.968883281
2582 1 2263 A 2018/02/23 22:14:41 +DATA/abc/archivelog/2018_02_24/thread_1_seq_2263.25790.968922289
2583 1 2264 A 2018/02/24 09:04:47 +DATA/abc/archivelog/2018_02_25/thread_1_seq_2264.27003.969056161
2584 1 2265 A 2018/02/25 22:16:01 +DATA/abc/archivelog/2018_02_26/thread_1_seq_2265.26973.969097899
2586 1 2266 A 2018/02/26 09:51:38 +DATA/abc/archivelog/2018_02_26/thread_1_seq_2266.26962.969100339
2587 1 2267 A 2018/02/26 10:32:17 +DATA/abc/archivelog/2018_02_26/thread_1_seq_2267.30945.969142605
2588 1 2268 A 2018/02/26 22:16:45 +DATA/abc/archivelog/2018_02_28/thread_1_seq_2268.28498.969274221
2589 1 2269 A 2018/02/28 10:50:20 +DATA/abc/archivelog/2018_03_01/thread_1_seq_2269.31869.969632445
2591 1 2270 A 2018/03/01 14:20:44 +DATA/abc/archivelog/2018_03_02/thread_1_seq_2270.31322.969696063
2592 1 2271 A 2018/03/02 08:01:02 +DATA/abc/archivelog/2018_03_02/thread_1_seq_2271.21988.969747587
2593 1 2272 A 2018/03/02 22:19:46 +DATA/abc/archivelog/2018_03_05/thread_1_seq_2272.22251.969962415
2596 1 2273 A 2018/03/05 10:00:14 +DATA/abc/archivelog/2018_03_06/thread_1_seq_2273.20415.970046717
2350 2 259 A 2017/12/13 12:09:36 +DATA/abc/archivelog/2017_12_14/thread_2_seq_259.26204.962709235
2354 2 260 A 2017/12/14 11:13:54 +DATA/abc/archivelog/2017_12_15/thread_2_seq_260.33471.962785215
2359 2 261 A 2017/12/15 08:20:15 +DATA/abc/archivelog/2017_12_15/thread_2_seq_261.33463.962785477
2362 2 262 A 2017/12/15 08:24:36 +DATA/abc/archivelog/2017_12_15/thread_2_seq_262.29518.962788789
2366 2 263 A 2017/12/15 09:19:48 +DATA/abc/archivelog/2017_12_15/thread_2_seq_263.29450.962794049
2370 2 264 A 2017/12/15 10:47:28 +DATA/abc/archivelog/2017_12_15/thread_2_seq_264.18943.962833323
2375 2 265 A 2017/12/15 21:42:02 +DATA/abc/archivelog/2017_12_17/thread_2_seq_265.19263.962999155
2378 2 266 A 2017/12/17 19:45:53 +DATA/abc/archivelog/2017_12_18/thread_2_seq_266.23074.963072619
2383 2 267 A 2017/12/18 16:10:17 +DATA/abc/archivelog/2017_12_19/thread_2_seq_267.24976.963131201
2387 2 268 A 2017/12/19 08:26:40 +DATA/abc/archivelog/2017_12_19/thread_2_seq_268.24969.963131463
2390 2 269 A 2017/12/19 08:31:01 +DATA/abc/archivelog/2017_12_19/thread_2_seq_269.28806.963156295
2394 2 270 A 2017/12/19 15:24:53 +DATA/abc/archivelog/2017_12_20/thread_2_seq_270.24342.963226039
2398 2 271 A 2017/12/20 10:47:17 +DATA/abc/archivelog/2017_12_20/thread_2_seq_271.20802.963251455
2402 2 272 A 2017/12/20 17:50:54 +DATA/abc/archivelog/2017_12_21/thread_2_seq_272.20106.963352817
2406 2 273 A 2017/12/21 22:00:17 +DATA/abc/archivelog/2017_12_22/thread_2_seq_273.20068.963375235
2410 2 274 A 2017/12/22 04:13:53 +DATA/abc/archivelog/2017_12_22/thread_2_seq_274.23105.963413795
2414 2 275 A 2017/12/22 14:56:34 +DATA/abc/archivelog/2017_12_22/thread_2_seq_275.19191.963422199
2418 2 276 A 2017/12/22 17:16:37 +DATA/abc/archivelog/2017_12_23/thread_2_seq_276.20920.963499723
2422 2 277 A 2017/12/23 14:48:41 +DATA/abc/archivelog/2017_12_25/thread_2_seq_277.19539.963672757
2427 2 278 A 2017/12/25 14:52:36 +DATA/abc/archivelog/2017_12_25/thread_2_seq_278.25646.963677911
2430 2 279 A 2017/12/25 16:18:31 +DATA/abc/archivelog/2017_12_25/thread_2_seq_279.25639.963678047
2434 2 280 A 2017/12/25 16:20:46 +DATA/abc/archivelog/2017_12_25/thread_2_seq_280.25614.963679519
2439 2 281 A 2017/12/25 16:45:19 +DATA/abc/archivelog/2017_12_26/thread_2_seq_281.30273.963764481
2442 2 282 A 2017/12/26 16:21:19 +DATA/abc/archivelog/2017_12_27/thread_2_seq_282.20848.963850577
2446 2 283 A 2017/12/27 16:16:17 +DATA/abc/archivelog/2017_12_28/thread_2_seq_283.32571.963908411
2450 2 284 A 2017/12/28 08:20:10 +DATA/abc/archivelog/2017_12_28/thread_2_seq_284.32485.963918033
2454 2 285 A 2017/12/28 11:00:31 +DATA/abc/archivelog/2017_12_29/thread_2_seq_285.30156.964016985
2459 2 286 A 2017/12/29 14:29:45 +DATA/abc/archivelog/2017_12_29/thread_2_seq_286.32972.964039975
2462 2 287 A 2017/12/29 20:52:55 +DATA/abc/archivelog/2018_01_02/thread_2_seq_287.26327.964368129
2466 2 288 A 2018/01/02 16:02:08 +DATA/abc/archivelog/2018_01_03/thread_2_seq_288.18761.964422165
2471 2 289 A 2018/01/03 07:02:44 +DATA/abc/archivelog/2018_01_03/thread_2_seq_289.32304.964474725
2474 2 290 A 2018/01/03 21:38:43 +DATA/abc/archivelog/2018_01_08/thread_2_seq_290.20104.964908011
2479 2 291 A 2018/01/08 22:00:11 +DATA/abc/archivelog/2018_01_12/thread_2_seq_291.23920.965227299
2482 2 292 A 2018/01/12 14:41:39 +DATA/abc/archivelog/2018_01_15/thread_2_seq_292.24678.965513401
2486 2 293 A 2018/01/15 22:10:00 +DATA/abc/archivelog/2018_01_19/thread_2_seq_293.34549.965814127
2490 2 294 A 2018/01/19 09:42:06 +DATA/abc/archivelog/2018_01_22/thread_2_seq_294.27518.966074035
2494 2 295 A 2018/01/22 09:53:55 +DATA/abc/archivelog/2018_01_23/thread_2_seq_295.27106.966176991
2497 2 296 A 2018/01/23 14:29:50 +DATA/abc/archivelog/2018_01_23/thread_2_seq_296.27098.966177685
2501 2 297 A 2018/01/23 14:41:23 +DATA/abc/archivelog/2018_01_23/thread_2_seq_297.27090.966178281
2505 2 298 A 2018/01/23 14:51:20 +DATA/abc/archivelog/2018_01_23/thread_2_seq_298.33820.966178587
2509 2 299 A 2018/01/23 14:56:26 +DATA/abc/archivelog/2018_01_23/thread_2_seq_299.33809.966178713
2513 2 300 A 2018/01/23 14:58:33 +DATA/abc/archivelog/2018_01_23/thread_2_seq_300.33798.966178953
2518 2 301 A 2018/01/23 15:02:33 +DATA/abc/archivelog/2018_01_23/thread_2_seq_301.33766.966181677
2521 2 302 A 2018/01/23 15:47:57 +DATA/abc/archivelog/2018_01_23/thread_2_seq_302.33753.966182329
2523 2 303 A 2018/01/23 15:58:48 +DATA/abc/archivelog/2018_01_24/thread_2_seq_303.32421.966237177
2527 2 304 A 2018/01/24 07:12:56 +DATA/abc/archivelog/2018_01_26/thread_2_seq_304.28647.966413641
2531 2 305 A 2018/01/26 08:14:01 +DATA/abc/archivelog/2018_01_28/thread_2_seq_305.28259.966638047
2533 2 306 A 2018/01/28 22:34:06 +DATA/abc/archivelog/2018_02_01/thread_2_seq_306.23307.966928519
2537 2 307 A 2018/02/01 07:15:18 +DATA/abc/archivelog/2018_02_02/thread_2_seq_307.21332.967024117
2541 2 308 A 2018/02/02 09:48:36 +DATA/abc/archivelog/2018_02_02/thread_2_seq_308.32030.967044239
2544 2 309 A 2018/02/02 15:23:58 +DATA/abc/archivelog/2018_02_02/thread_2_seq_309.32003.967047343
2549 2 310 A 2018/02/02 16:15:43 +DATA/abc/archivelog/2018_02_02/thread_2_seq_310.31420.967050639
2552 2 311 A 2018/02/02 17:10:37 +DATA/abc/archivelog/2018_02_02/thread_2_seq_311.31387.967055219
2556 2 312 A 2018/02/02 18:26:58 +DATA/abc/archivelog/2018_02_02/thread_2_seq_312.31368.967065053
2560 2 313 A 2018/02/02 21:10:53 +DATA/abc/archivelog/2018_02_02/thread_2_seq_313.31350.967069361
2565 2 314 A 2018/02/02 22:22:41 +DATA/abc/archivelog/2018_02_06/thread_2_seq_314.31478.967374729
2567 2 315 A 2018/02/06 11:12:09 +DATA/abc/archivelog/2018_02_09/thread_2_seq_315.24907.967672847
2570 2 316 A 2018/02/09 22:00:47 +DATA/abc/archivelog/2018_02_15/thread_2_seq_316.25084.968158811
2574 2 317 A 2018/02/15 13:00:11 +DATA/abc/archivelog/2018_02_22/thread_2_seq_317.21380.968738419
2578 2 318 A 2018/02/22 06:00:18 +DATA/abc/archivelog/2018_02_23/thread_2_seq_318.30313.968856655
2581 2 319 A 2018/02/23 14:50:55 +DATA/abc/archivelog/2018_02_24/thread_2_seq_319.25778.968922289
2585 2 320 A 2018/02/24 09:04:49 +DATA/abc/archivelog/2018_02_26/thread_2_seq_320.26961.969100341
2590 2 321 A 2018/02/26 10:32:20 +DATA/abc/archivelog/2018_03_01/thread_2_seq_321.31868.969632447
2594 2 322 A 2018/03/01 14:20:46 +DATA/abc/archivelog/2018_03_05/thread_2_seq_322.22250.969962417
2595 2 323 A 2018/03/05 10:00:16 +DATA/abc/archivelog/2018_03_06/thread_2_seq_323.20414.970046717
RMAN>
运行备份脚本：
$ ./rman_arch_abc.sh
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Mar 6 09:25:14 2018
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: abc (DBID=207178794)
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: abc (DBID=207178794)
RMAN>
Starting backup at 2018/03/06 09:25:15
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1988 instance=abc1 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2190 recid=2481 stamp=965512834
input archive log thread=1 sequence=2191 recid=2483 stamp=965718033
input archive log thread=1 sequence=2192 recid=2484 stamp=965812471
input archive log thread=1 sequence=2193 recid=2485 stamp=965814128
input archive log thread=1 sequence=2194 recid=2487 stamp=965820375
input archive log thread=1 sequence=2195 recid=2488 stamp=966070041
input archive log thread=1 sequence=2196 recid=2489 stamp=966074038
input archive log thread=1 sequence=2197 recid=2491 stamp=966086144
input archive log thread=1 sequence=2198 recid=2492 stamp=966086278
input archive log thread=1 sequence=2199 recid=2493 stamp=966176990
input archive log thread=1 sequence=2200 recid=2495 stamp=966177231
input archive log thread=1 sequence=2201 recid=2496 stamp=966177456
input archive log thread=1 sequence=2202 recid=2498 stamp=966177685
input archive log thread=1 sequence=2203 recid=2499 stamp=966177917
input archive log thread=1 sequence=2204 recid=2500 stamp=966178146
input archive log thread=1 sequence=2205 recid=2502 stamp=966178283
input archive log thread=1 sequence=2206 recid=2503 stamp=966178425
input archive log thread=1 sequence=2207 recid=2504 stamp=966178519
input archive log thread=1 sequence=2208 recid=2506 stamp=966178587
input archive log thread=1 sequence=2209 recid=2507 stamp=966178631
input archive log thread=1 sequence=2210 recid=2508 stamp=966178671
input archive log thread=1 sequence=2211 recid=2510 stamp=966178714
input archive log thread=1 sequence=2212 recid=2511 stamp=966178822
input archive log thread=1 sequence=2213 recid=2512 stamp=966178886
input archive log thread=1 sequence=2214 recid=2514 stamp=966178954
input archive log thread=1 sequence=2215 recid=2515 stamp=966179157
input archive log thread=1 sequence=2216 recid=2516 stamp=966181446
input archive log thread=1 sequence=2217 recid=2517 stamp=966181676
input archive log thread=1 sequence=2218 recid=2519 stamp=966181895
input archive log thread=1 sequence=2219 recid=2520 stamp=966182113
input archive log thread=1 sequence=2220 recid=2522 stamp=966182329
input archive log thread=1 sequence=2221 recid=2524 stamp=966252878
input archive log thread=1 sequence=2222 recid=2525 stamp=966265659
input archive log thread=1 sequence=2223 recid=2526 stamp=966413640
input archive log thread=1 sequence=2224 recid=2528 stamp=966436837
input archive log thread=1 sequence=2225 recid=2529 stamp=966440442
input archive log thread=1 sequence=2226 recid=2530 stamp=966638048
input archive log thread=1 sequence=2227 recid=2532 stamp=966895212
input archive log thread=1 sequence=2228 recid=2534 stamp=966938147
input archive log thread=1 sequence=2229 recid=2535 stamp=966981617
input archive log thread=1 sequence=2230 recid=2536 stamp=967024117
input archive log thread=1 sequence=2231 recid=2538 stamp=967040734
input archive log thread=1 sequence=2232 recid=2539 stamp=967042481
input archive log thread=1 sequence=2233 recid=2540 stamp=967044237
input archive log thread=1 sequence=2234 recid=2542 stamp=967045282
input archive log thread=1 sequence=2235 recid=2543 stamp=967046279
input archive log thread=1 sequence=2236 recid=2545 stamp=967047346
input archive log thread=1 sequence=2237 recid=2546 stamp=967048423
input archive log thread=1 sequence=2238 recid=2547 stamp=967049275
input archive log thread=1 sequence=2239 recid=2548 stamp=967050637
channel ORA_DISK_1: starting piece 1 at 2018/03/06 09:25:34
channel ORA_DISK_1: finished piece 1 at 2018/03/06 09:27:29
piece handle=/arch_rman/abc_T_13st3f8d_1_1_arc.rman tag=TAG20180306T092526 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:56
channel ORA_DISK_1: deleting archive log(s)
archive log filename=+DATA/abc/archivelog/2018_01_15/thread_1_seq_2190.20136.965512831 recid=2481 stamp=965512834
archive log filename=+DATA/abc/archivelog/2018_01_18/thread_1_seq_2191.32324.965718031 recid=2483 stamp=965718033
archive log filename=+DATA/abc/archivelog/2018_01_19/thread_1_seq_2192.34561.965812469 recid=2484 stamp=965812471
archive log filename=+DATA/abc/archivelog/2018_01_19/thread_1_seq_2193.34550.965814125 recid=2485 stamp=965814128
archive log filename=+DATA/abc/archivelog/2018_01_19/thread_1_seq_2194.34506.965820373 recid=2487 stamp=965820375
archive log filename=+DATA/abc/archivelog/2018_01_22/thread_1_seq_2195.27542.966070039 recid=2488 stamp=966070041
archive log filename=+DATA/abc/archivelog/2018_01_22/thread_1_seq_2196.27519.966074035 recid=2489 stamp=966074038
archive log filename=+DATA/abc/archivelog/2018_01_22/thread_1_seq_2197.20695.966086141 recid=2491 stamp=966086144
archive log filename=+DATA/abc/archivelog/2018_01_22/thread_1_seq_2198.20694.966086277 recid=2492 stamp=966086278
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2199.27107.966176989 recid=2493 stamp=966176990
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2200.27103.966177229 recid=2495 stamp=966177231
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2201.27102.966177455 recid=2496 stamp=966177456
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2202.27099.966177683 recid=2498 stamp=966177685
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2203.27095.966177915 recid=2499 stamp=966177917
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2204.27092.966178145 recid=2500 stamp=966178146
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2205.27091.966178281 recid=2502 stamp=966178283
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2206.27088.966178423 recid=2503 stamp=966178425
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2207.27086.966178517 recid=2504 stamp=966178519
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2208.27084.966178585 recid=2506 stamp=966178587
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2209.33818.966178629 recid=2507 stamp=966178631
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2210.33814.966178669 recid=2508 stamp=966178671
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2211.33811.966178713 recid=2510 stamp=966178714
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2212.33807.966178821 recid=2511 stamp=966178822
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2213.33805.966178885 recid=2512 stamp=966178886
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2214.33803.966178953 recid=2514 stamp=966178954
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2215.33791.966179155 recid=2515 stamp=966179157
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2216.33770.966181445 recid=2516 stamp=966181446
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2217.33768.966181675 recid=2517 stamp=966181676
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2218.33760.966181893 recid=2519 stamp=966181895
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2219.33758.966182111 recid=2520 stamp=966182113
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_1_seq_2220.33756.966182327 recid=2522 stamp=966182329
archive log filename=+DATA/abc/archivelog/2018_01_24/thread_1_seq_2221.32348.966252875 recid=2524 stamp=966252878
archive log filename=+DATA/abc/archivelog/2018_01_24/thread_1_seq_2222.20587.966265657 recid=2525 stamp=966265659
archive log filename=+DATA/abc/archivelog/2018_01_26/thread_1_seq_2223.28648.966413639 recid=2526 stamp=966413640
archive log filename=+DATA/abc/archivelog/2018_01_26/thread_1_seq_2224.27455.966436835 recid=2528 stamp=966436837
archive log filename=+DATA/abc/archivelog/2018_01_26/thread_1_seq_2225.27431.966440441 recid=2529 stamp=966440442
archive log filename=+DATA/abc/archivelog/2018_01_28/thread_1_seq_2226.28261.966638045 recid=2530 stamp=966638048
archive log filename=+DATA/abc/archivelog/2018_01_31/thread_1_seq_2227.25992.966895209 recid=2532 stamp=966895212
archive log filename=+DATA/abc/archivelog/2018_02_01/thread_1_seq_2228.23269.966938145 recid=2534 stamp=966938147
archive log filename=+DATA/abc/archivelog/2018_02_01/thread_1_seq_2229.22549.966981615 recid=2535 stamp=966981617
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2230.21334.967024115 recid=2536 stamp=967024117
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2231.32062.967040731 recid=2538 stamp=967040734
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2232.32051.967042479 recid=2539 stamp=967042481
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2233.32033.967044235 recid=2540 stamp=967044237
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2234.32023.967045279 recid=2542 stamp=967045282
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2235.32016.967046277 recid=2543 stamp=967046279
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2236.32006.967047343 recid=2545 stamp=967047346
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2237.31447.967048421 recid=2546 stamp=967048423
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2238.31430.967049273 recid=2547 stamp=967049275
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2239.31422.967050635 recid=2548 stamp=967050637
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2090 recid=2348 stamp=962639425
input archive log thread=1 sequence=2091 recid=2349 stamp=962670154
input archive log thread=1 sequence=2092 recid=2351 stamp=962709236
input archive log thread=1 sequence=2093 recid=2352 stamp=962727253
input archive log thread=1 sequence=2094 recid=2353 stamp=962768830
input archive log thread=1 sequence=2095 recid=2355 stamp=962785216
input archive log thread=1 sequence=2096 recid=2356 stamp=962785319
input archive log thread=1 sequence=2097 recid=2357 stamp=962785407
input archive log thread=1 sequence=2098 recid=2358 stamp=962785476
input archive log thread=1 sequence=2099 recid=2360 stamp=962785540
input archive log thread=1 sequence=2100 recid=2361 stamp=962787535
input archive log thread=1 sequence=2101 recid=2363 stamp=962788790
input archive log thread=1 sequence=2102 recid=2364 stamp=962790309
input archive log thread=1 sequence=2103 recid=2365 stamp=962791579
input archive log thread=1 sequence=2104 recid=2367 stamp=962794051
input archive log thread=1 sequence=2105 recid=2368 stamp=962796015
input archive log thread=1 sequence=2106 recid=2369 stamp=962810261
input archive log thread=1 sequence=2107 recid=2371 stamp=962833326
input archive log thread=1 sequence=2108 recid=2372 stamp=962901927
input archive log thread=1 sequence=2109 recid=2373 stamp=962971143
input archive log thread=1 sequence=2110 recid=2374 stamp=962999153
input archive log thread=1 sequence=2111 recid=2376 stamp=963051079
input archive log thread=1 sequence=2112 recid=2377 stamp=963064721
input archive log thread=1 sequence=2113 recid=2379 stamp=963072620
input archive log thread=1 sequence=2114 recid=2380 stamp=963090532
input archive log thread=1 sequence=2115 recid=2381 stamp=963131057
input archive log thread=1 sequence=2116 recid=2382 stamp=963131201
input archive log thread=1 sequence=2117 recid=2384 stamp=963131316
input archive log thread=1 sequence=2118 recid=2385 stamp=963131404
input archive log thread=1 sequence=2119 recid=2386 stamp=963131461
input archive log thread=1 sequence=2120 recid=2388 stamp=963131503
input archive log thread=1 sequence=2121 recid=2389 stamp=963142639
input archive log thread=1 sequence=2122 recid=2391 stamp=963156296
input archive log thread=1 sequence=2123 recid=2392 stamp=963215996
input archive log thread=1 sequence=2124 recid=2393 stamp=963216099
input archive log thread=1 sequence=2125 recid=2395 stamp=963226040
input archive log thread=1 sequence=2126 recid=2396 stamp=963238572
input archive log thread=1 sequence=2127 recid=2397 stamp=963243433
input archive log thread=1 sequence=2128 recid=2399 stamp=963251456
input archive log thread=1 sequence=2129 recid=2400 stamp=963306959
input archive log thread=1 sequence=2130 recid=2401 stamp=963318368
input archive log thread=1 sequence=2131 recid=2403 stamp=963352819
input archive log thread=1 sequence=2132 recid=2404 stamp=963374534
input archive log thread=1 sequence=2133 recid=2405 stamp=963375217
input archive log thread=1 sequence=2134 recid=2407 stamp=963375235
input archive log thread=1 sequence=2135 recid=2408 stamp=963375309
input archive log thread=1 sequence=2136 recid=2409 stamp=963375344
input archive log thread=1 sequence=2137 recid=2411 stamp=963413795
input archive log thread=1 sequence=2138 recid=2412 stamp=963420110
input archive log thread=1 sequence=2139 recid=2413 stamp=963421085
channel ORA_DISK_1: starting piece 1 at 2018/03/06 09:27:36
channel ORA_DISK_1: finished piece 1 at 2018/03/06 09:29:21
piece handle=/arch_rman/abc_T_14st3fc6_1_1_arc.rman tag=TAG20180306T092526 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:47
channel ORA_DISK_1: deleting archive log(s)
archive log filename=+DATA/abc/archivelog/2017_12_13/thread_1_seq_2090.25218.962639423 recid=2348 stamp=962639425
archive log filename=+DATA/abc/archivelog/2017_12_14/thread_1_seq_2091.25130.962670153 recid=2349 stamp=962670154
archive log filename=+DATA/abc/archivelog/2017_12_14/thread_1_seq_2092.26206.962709235 recid=2351 stamp=962709236
archive log filename=+DATA/abc/archivelog/2017_12_14/thread_1_seq_2093.33587.962727251 recid=2352 stamp=962727253
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2094.33486.962768827 recid=2353 stamp=962768830
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2095.33474.962785215 recid=2355 stamp=962785216
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2096.33469.962785317 recid=2356 stamp=962785319
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2097.33468.962785405 recid=2357 stamp=962785407
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2098.33466.962785475 recid=2358 stamp=962785476
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2099.33461.962785539 recid=2360 stamp=962785540
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2100.33448.962787533 recid=2361 stamp=962787535
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2101.29522.962788787 recid=2363 stamp=962788790
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2102.29490.962790307 recid=2364 stamp=962790309
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2103.29466.962791577 recid=2365 stamp=962791579
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2104.29452.962794047 recid=2367 stamp=962794051
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2105.29430.962796013 recid=2368 stamp=962796015
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2106.19047.962810259 recid=2369 stamp=962810261
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_1_seq_2107.18946.962833323 recid=2371 stamp=962833326
archive log filename=+DATA/abc/archivelog/2017_12_16/thread_1_seq_2108.19828.962901925 recid=2372 stamp=962901927
archive log filename=+DATA/abc/archivelog/2017_12_17/thread_1_seq_2109.19330.962971141 recid=2373 stamp=962971143
archive log filename=+DATA/abc/archivelog/2017_12_17/thread_1_seq_2110.19264.962999151 recid=2374 stamp=962999153
archive log filename=+DATA/abc/archivelog/2017_12_18/thread_1_seq_2111.23161.963051077 recid=2376 stamp=963051079
archive log filename=+DATA/abc/archivelog/2017_12_18/thread_1_seq_2112.23107.963064719 recid=2377 stamp=963064721
archive log filename=+DATA/abc/archivelog/2017_12_18/thread_1_seq_2113.23078.963072617 recid=2379 stamp=963072620
archive log filename=+DATA/abc/archivelog/2017_12_18/thread_1_seq_2114.25004.963090529 recid=2380 stamp=963090532
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2115.24980.963131055 recid=2381 stamp=963131057
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2116.24978.963131199 recid=2382 stamp=963131201
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2117.24975.963131315 recid=2384 stamp=963131316
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2118.24972.963131403 recid=2385 stamp=963131404
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2119.24970.963131459 recid=2386 stamp=963131461
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2120.24967.963131501 recid=2388 stamp=963131503
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2121.28896.963142637 recid=2389 stamp=963142639
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_1_seq_2122.28809.963156295 recid=2391 stamp=963156296
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_1_seq_2123.24432.963215995 recid=2392 stamp=963215996
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_1_seq_2124.24428.963216097 recid=2393 stamp=963216099
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_1_seq_2125.24346.963226037 recid=2395 stamp=963226040
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_1_seq_2126.20923.963238571 recid=2396 stamp=963238572
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_1_seq_2127.20869.963243431 recid=2397 stamp=963243433
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_1_seq_2128.20803.963251453 recid=2399 stamp=963251456
archive log filename=+DATA/abc/archivelog/2017_12_21/thread_1_seq_2129.20688.963306957 recid=2400 stamp=963306959
archive log filename=+DATA/abc/archivelog/2017_12_21/thread_1_seq_2130.20556.963318365 recid=2401 stamp=963318368
archive log filename=+DATA/abc/archivelog/2017_12_21/thread_1_seq_2131.20110.963352817 recid=2403 stamp=963352819
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2132.20080.963374531 recid=2404 stamp=963374534
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2133.20076.963375215 recid=2405 stamp=963375217
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2134.20072.963375233 recid=2407 stamp=963375235
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2135.20066.963375307 recid=2408 stamp=963375309
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2136.20063.963375341 recid=2409 stamp=963375344
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2137.23108.963413793 recid=2411 stamp=963413795
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2138.19219.963420109 recid=2412 stamp=963420110
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2139.19212.963421083 recid=2413 stamp=963421085
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2140 recid=2415 stamp=963422199
input archive log thread=1 sequence=2141 recid=2416 stamp=963428148
input archive log thread=1 sequence=2142 recid=2417 stamp=963459382
input archive log thread=1 sequence=2143 recid=2419 stamp=963499725
input archive log thread=1 sequence=2144 recid=2420 stamp=963585665
input archive log thread=1 sequence=2145 recid=2421 stamp=963655051
input archive log thread=1 sequence=2146 recid=2423 stamp=963672758
input archive log thread=1 sequence=2147 recid=2424 stamp=963677737
input archive log thread=1 sequence=2148 recid=2425 stamp=963677841
input archive log thread=1 sequence=2149 recid=2426 stamp=963677911
input archive log thread=1 sequence=2150 recid=2428 stamp=963677963
input archive log thread=1 sequence=2151 recid=2429 stamp=963678006
input archive log thread=1 sequence=2152 recid=2431 stamp=963678047
input archive log thread=1 sequence=2153 recid=2432 stamp=963678093
input archive log thread=1 sequence=2154 recid=2433 stamp=963678131
input archive log thread=1 sequence=2155 recid=2435 stamp=963679520
input archive log thread=1 sequence=2156 recid=2436 stamp=963742362
input archive log thread=1 sequence=2157 recid=2437 stamp=963763156
input archive log thread=1 sequence=2158 recid=2438 stamp=963764480
input archive log thread=1 sequence=2159 recid=2440 stamp=963765954
input archive log thread=1 sequence=2160 recid=2441 stamp=963823817
input archive log thread=1 sequence=2161 recid=2443 stamp=963850579
input archive log thread=1 sequence=2162 recid=2444 stamp=963852298
input archive log thread=1 sequence=2163 recid=2445 stamp=963854345
input archive log thread=1 sequence=2164 recid=2447 stamp=963908413
input archive log thread=1 sequence=2165 recid=2448 stamp=963909533
input archive log thread=1 sequence=2166 recid=2449 stamp=963910896
input archive log thread=1 sequence=2167 recid=2451 stamp=963918032
input archive log thread=1 sequence=2168 recid=2452 stamp=963961212
input archive log thread=1 sequence=2169 recid=2453 stamp=964006374
input archive log thread=1 sequence=2170 recid=2455 stamp=964016986
input archive log thread=1 sequence=2171 recid=2456 stamp=964018716
input archive log thread=1 sequence=2172 recid=2457 stamp=964023169
input archive log thread=1 sequence=2173 recid=2458 stamp=964039975
input archive log thread=1 sequence=2174 recid=2460 stamp=964042045
input archive log thread=1 sequence=2175 recid=2461 stamp=964249281
input archive log thread=1 sequence=2176 recid=2463 stamp=964368132
input archive log thread=1 sequence=2177 recid=2464 stamp=964386150
input archive log thread=1 sequence=2178 recid=2465 stamp=964393312
input archive log thread=1 sequence=2179 recid=2467 stamp=964422166
input archive log thread=1 sequence=2180 recid=2468 stamp=964455348
input archive log thread=1 sequence=2181 recid=2469 stamp=964455442
input archive log thread=1 sequence=2182 recid=2470 stamp=964474723
input archive log thread=1 sequence=2183 recid=2472 stamp=964544073
input archive log thread=1 sequence=2184 recid=2473 stamp=964681493
input archive log thread=1 sequence=2185 recid=2475 stamp=964908014
input archive log thread=1 sequence=2186 recid=2476 stamp=964947394
input archive log thread=1 sequence=2187 recid=2477 stamp=965057590
input archive log thread=1 sequence=2188 recid=2478 stamp=965227299
input archive log thread=1 sequence=2189 recid=2480 stamp=965336418
channel ORA_DISK_1: starting piece 1 at 2018/03/06 09:29:29
channel ORA_DISK_1: finished piece 1 at 2018/03/06 09:31:14
piece handle=/arch_rman/abc_T_15st3ffo_1_1_arc.rman tag=TAG20180306T092526 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:47
channel ORA_DISK_1: deleting archive log(s)
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2140.19194.963422197 recid=2415 stamp=963422199
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_1_seq_2141.19149.963428147 recid=2416 stamp=963428148
archive log filename=+DATA/abc/archivelog/2017_12_23/thread_1_seq_2142.19091.963459381 recid=2417 stamp=963459382
archive log filename=+DATA/abc/archivelog/2017_12_23/thread_1_seq_2143.20921.963499721 recid=2419 stamp=963499725
archive log filename=+DATA/abc/archivelog/2017_12_24/thread_1_seq_2144.23347.963585663 recid=2420 stamp=963585665
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2145.21772.963655049 recid=2421 stamp=963655051
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2146.19540.963672755 recid=2423 stamp=963672758
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2147.25657.963677735 recid=2424 stamp=963677737
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2148.25650.963677839 recid=2425 stamp=963677841
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2149.25648.963677909 recid=2426 stamp=963677911
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2150.25644.963677961 recid=2428 stamp=963677963
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2151.25642.963678005 recid=2429 stamp=963678006
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2152.25641.963678045 recid=2431 stamp=963678047
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2153.25638.963678091 recid=2432 stamp=963678093
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2154.25636.963678129 recid=2433 stamp=963678131
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_1_seq_2155.25615.963679519 recid=2435 stamp=963679520
archive log filename=+DATA/abc/archivelog/2017_12_26/thread_1_seq_2156.33462.963742359 recid=2436 stamp=963742362
archive log filename=+DATA/abc/archivelog/2017_12_26/thread_1_seq_2157.30291.963763153 recid=2437 stamp=963763156
archive log filename=+DATA/abc/archivelog/2017_12_26/thread_1_seq_2158.30274.963764477 recid=2438 stamp=963764480
archive log filename=+DATA/abc/archivelog/2017_12_26/thread_1_seq_2159.30263.963765953 recid=2440 stamp=963765954
archive log filename=+DATA/abc/archivelog/2017_12_27/thread_1_seq_2160.30179.963823815 recid=2441 stamp=963823817
archive log filename=+DATA/abc/archivelog/2017_12_27/thread_1_seq_2161.20849.963850577 recid=2443 stamp=963850579
archive log filename=+DATA/abc/archivelog/2017_12_27/thread_1_seq_2162.20838.963852295 recid=2444 stamp=963852298
archive log filename=+DATA/abc/archivelog/2017_12_27/thread_1_seq_2163.20828.963854343 recid=2445 stamp=963854345
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_1_seq_2164.32573.963908411 recid=2447 stamp=963908413
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_1_seq_2165.32565.963909531 recid=2448 stamp=963909533
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_1_seq_2166.32552.963910895 recid=2449 stamp=963910896
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_1_seq_2167.32487.963918029 recid=2451 stamp=963918032
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_1_seq_2168.33071.963961211 recid=2452 stamp=963961212
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_1_seq_2169.30193.964006373 recid=2453 stamp=964006374
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_1_seq_2170.30157.964016983 recid=2455 stamp=964016986
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_1_seq_2171.30149.964018713 recid=2456 stamp=964018716
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_1_seq_2172.30125.964023167 recid=2457 stamp=964023169
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_1_seq_2173.32975.964039973 recid=2458 stamp=964039975
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_1_seq_2174.32962.964042043 recid=2460 stamp=964042045
archive log filename=+DATA/abc/archivelog/2018_01_01/thread_1_seq_2175.22948.964249279 recid=2461 stamp=964249281
archive log filename=+DATA/abc/archivelog/2018_01_02/thread_1_seq_2176.26328.964368129 recid=2463 stamp=964368132
archive log filename=+DATA/abc/archivelog/2018_01_02/thread_1_seq_2177.26276.964386149 recid=2464 stamp=964386150
archive log filename=+DATA/abc/archivelog/2018_01_02/thread_1_seq_2178.18771.964393311 recid=2465 stamp=964393312
archive log filename=+DATA/abc/archivelog/2018_01_03/thread_1_seq_2179.18763.964422165 recid=2467 stamp=964422166
archive log filename=+DATA/abc/archivelog/2018_01_03/thread_1_seq_2180.25151.964455345 recid=2468 stamp=964455348
archive log filename=+DATA/abc/archivelog/2018_01_03/thread_1_seq_2181.25148.964455439 recid=2469 stamp=964455442
archive log filename=+DATA/abc/archivelog/2018_01_03/thread_1_seq_2182.32308.964474721 recid=2470 stamp=964474723
archive log filename=+DATA/abc/archivelog/2018_01_04/thread_1_seq_2183.23681.964544071 recid=2472 stamp=964544073
archive log filename=+DATA/abc/archivelog/2018_01_06/thread_1_seq_2184.34206.964681491 recid=2473 stamp=964681493
archive log filename=+DATA/abc/archivelog/2018_01_08/thread_1_seq_2185.20105.964908011 recid=2475 stamp=964908014
archive log filename=+DATA/abc/archivelog/2018_01_09/thread_1_seq_2186.20085.964947391 recid=2476 stamp=964947394
archive log filename=+DATA/abc/archivelog/2018_01_10/thread_1_seq_2187.27293.965057589 recid=2477 stamp=965057590
archive log filename=+DATA/abc/archivelog/2018_01_12/thread_1_seq_2188.23922.965227297 recid=2478 stamp=965227299
archive log filename=+DATA/abc/archivelog/2018_01_13/thread_1_seq_2189.31746.965336415 recid=2480 stamp=965336418
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2240 recid=2550 stamp=967051011
input archive log thread=1 sequence=2241 recid=2551 stamp=967051809
input archive log thread=1 sequence=2242 recid=2553 stamp=967055219
input archive log thread=1 sequence=2243 recid=2554 stamp=967058897
input archive log thread=1 sequence=2244 recid=2555 stamp=967062856
input archive log thread=1 sequence=2245 recid=2557 stamp=967065054
input archive log thread=1 sequence=2246 recid=2558 stamp=967066148
input archive log thread=1 sequence=2247 recid=2559 stamp=967066204
input archive log thread=1 sequence=2248 recid=2561 stamp=967069364
input archive log thread=1 sequence=2249 recid=2562 stamp=967280430
input archive log thread=1 sequence=2250 recid=2563 stamp=967284043
input archive log thread=1 sequence=2251 recid=2564 stamp=967374731
input archive log thread=1 sequence=2252 recid=2566 stamp=967548629
input archive log thread=1 sequence=2253 recid=2568 stamp=967820927
input archive log thread=1 sequence=2254 recid=2569 stamp=967964810
input archive log thread=1 sequence=2255 recid=2571 stamp=968224136
input archive log thread=1 sequence=2256 recid=2572 stamp=968461243
input archive log thread=1 sequence=2257 recid=2573 stamp=968738419
input archive log thread=1 sequence=2258 recid=2575 stamp=968836402
input archive log thread=1 sequence=2259 recid=2576 stamp=968841747
input archive log thread=1 sequence=2260 recid=2577 stamp=968856656
input archive log thread=1 sequence=2261 recid=2579 stamp=968861933
input archive log thread=1 sequence=2262 recid=2580 stamp=968883284
input archive log thread=1 sequence=2263 recid=2582 stamp=968922291
input archive log thread=1 sequence=2264 recid=2583 stamp=969056164
input archive log thread=1 sequence=2265 recid=2584 stamp=969097900
input archive log thread=1 sequence=2266 recid=2586 stamp=969100341
input archive log thread=1 sequence=2267 recid=2587 stamp=969142608
input archive log thread=1 sequence=2268 recid=2588 stamp=969274223
input archive log thread=1 sequence=2269 recid=2589 stamp=969632446
input archive log thread=1 sequence=2270 recid=2591 stamp=969696064
input archive log thread=1 sequence=2271 recid=2592 stamp=969747589
input archive log thread=1 sequence=2272 recid=2593 stamp=969962417
input archive log thread=1 sequence=2273 recid=2596 stamp=970046719
input archive log thread=2 sequence=259 recid=2350 stamp=962709235
input archive log thread=2 sequence=260 recid=2354 stamp=962785216
input archive log thread=2 sequence=261 recid=2359 stamp=962785476
input archive log thread=2 sequence=262 recid=2362 stamp=962788789
input archive log thread=2 sequence=263 recid=2366 stamp=962794048
input archive log thread=2 sequence=264 recid=2370 stamp=962833323
input archive log thread=2 sequence=265 recid=2375 stamp=962999154
input archive log thread=2 sequence=266 recid=2378 stamp=963072618
input archive log thread=2 sequence=267 recid=2383 stamp=963131201
input archive log thread=2 sequence=268 recid=2387 stamp=963131462
input archive log thread=2 sequence=269 recid=2390 stamp=963156294
input archive log thread=2 sequence=270 recid=2394 stamp=963226038
input archive log thread=2 sequence=271 recid=2398 stamp=963251455
input archive log thread=2 sequence=272 recid=2402 stamp=963352818
input archive log thread=2 sequence=273 recid=2406 stamp=963375234
input archive log thread=2 sequence=274 recid=2410 stamp=963413794
input archive log thread=2 sequence=275 recid=2414 stamp=963422198
input archive log thread=2 sequence=276 recid=2418 stamp=963499722
input archive log thread=2 sequence=277 recid=2422 stamp=963672757
input archive log thread=2 sequence=278 recid=2427 stamp=963677911
input archive log thread=2 sequence=279 recid=2430 stamp=963678046
input archive log thread=2 sequence=280 recid=2434 stamp=963679519
input archive log thread=2 sequence=281 recid=2439 stamp=963764480
input archive log thread=2 sequence=282 recid=2442 stamp=963850578
input archive log thread=2 sequence=283 recid=2446 stamp=963908411
input archive log thread=2 sequence=284 recid=2450 stamp=963918032
input archive log thread=2 sequence=285 recid=2454 stamp=964016986
input archive log thread=2 sequence=286 recid=2459 stamp=964039975
input archive log thread=2 sequence=287 recid=2462 stamp=964368131
input archive log thread=2 sequence=288 recid=2466 stamp=964422164
channel ORA_DISK_1: starting piece 1 at 2018/03/06 09:31:22
channel ORA_DISK_1: finished piece 1 at 2018/03/06 09:32:37
piece handle=/arch_rman/abc_T_16st3fj8_1_1_arc.rman tag=TAG20180306T092526 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:17
channel ORA_DISK_1: deleting archive log(s)
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2240.31408.967051009 recid=2550 stamp=967051011
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2241.31405.967051807 recid=2551 stamp=967051809
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2242.31389.967055217 recid=2553 stamp=967055219
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2243.31382.967058895 recid=2554 stamp=967058897
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2244.31374.967062855 recid=2555 stamp=967062856
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2245.31369.967065053 recid=2557 stamp=967065054
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2246.31366.967066147 recid=2558 stamp=967066148
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2247.31364.967066203 recid=2559 stamp=967066204
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_1_seq_2248.31352.967069361 recid=2561 stamp=967069364
archive log filename=+DATA/abc/archivelog/2018_02_05/thread_1_seq_2249.24074.967280427 recid=2562 stamp=967280430
archive log filename=+DATA/abc/archivelog/2018_02_05/thread_1_seq_2250.24031.967284041 recid=2563 stamp=967284043
archive log filename=+DATA/abc/archivelog/2018_02_06/thread_1_seq_2251.31479.967374729 recid=2564 stamp=967374731
archive log filename=+DATA/abc/archivelog/2018_02_08/thread_1_seq_2252.32957.967548627 recid=2566 stamp=967548629
archive log filename=+DATA/abc/archivelog/2018_02_11/thread_1_seq_2253.27975.967820925 recid=2568 stamp=967820927
archive log filename=+DATA/abc/archivelog/2018_02_13/thread_1_seq_2254.19904.967964809 recid=2569 stamp=967964810
archive log filename=+DATA/abc/archivelog/2018_02_16/thread_1_seq_2255.25057.968224135 recid=2571 stamp=968224136
archive log filename=+DATA/abc/archivelog/2018_02_19/thread_1_seq_2256.19659.968461241 recid=2572 stamp=968461243
archive log filename=+DATA/abc/archivelog/2018_02_22/thread_1_seq_2257.21382.968738417 recid=2573 stamp=968738419
archive log filename=+DATA/abc/archivelog/2018_02_23/thread_1_seq_2258.30372.968836399 recid=2575 stamp=968836402
archive log filename=+DATA/abc/archivelog/2018_02_23/thread_1_seq_2259.30351.968841745 recid=2576 stamp=968841747
archive log filename=+DATA/abc/archivelog/2018_02_23/thread_1_seq_2260.30315.968856653 recid=2577 stamp=968856656
archive log filename=+DATA/abc/archivelog/2018_02_23/thread_1_seq_2261.21906.968861931 recid=2579 stamp=968861933
archive log filename=+DATA/abc/archivelog/2018_02_23/thread_1_seq_2262.34093.968883281 recid=2580 stamp=968883284
archive log filename=+DATA/abc/archivelog/2018_02_24/thread_1_seq_2263.25790.968922289 recid=2582 stamp=968922291
archive log filename=+DATA/abc/archivelog/2018_02_25/thread_1_seq_2264.27003.969056161 recid=2583 stamp=969056164
archive log filename=+DATA/abc/archivelog/2018_02_26/thread_1_seq_2265.26973.969097899 recid=2584 stamp=969097900
archive log filename=+DATA/abc/archivelog/2018_02_26/thread_1_seq_2266.26962.969100339 recid=2586 stamp=969100341
archive log filename=+DATA/abc/archivelog/2018_02_26/thread_1_seq_2267.30945.969142605 recid=2587 stamp=969142608
archive log filename=+DATA/abc/archivelog/2018_02_28/thread_1_seq_2268.28498.969274221 recid=2588 stamp=969274223
archive log filename=+DATA/abc/archivelog/2018_03_01/thread_1_seq_2269.31869.969632445 recid=2589 stamp=969632446
archive log filename=+DATA/abc/archivelog/2018_03_02/thread_1_seq_2270.31322.969696063 recid=2591 stamp=969696064
archive log filename=+DATA/abc/archivelog/2018_03_02/thread_1_seq_2271.21988.969747587 recid=2592 stamp=969747589
archive log filename=+DATA/abc/archivelog/2018_03_05/thread_1_seq_2272.22251.969962415 recid=2593 stamp=969962417
archive log filename=+DATA/abc/archivelog/2018_03_06/thread_1_seq_2273.20415.970046717 recid=2596 stamp=970046719
archive log filename=+DATA/abc/archivelog/2017_12_14/thread_2_seq_259.26204.962709235 recid=2350 stamp=962709235
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_2_seq_260.33471.962785215 recid=2354 stamp=962785216
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_2_seq_261.33463.962785477 recid=2359 stamp=962785476
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_2_seq_262.29518.962788789 recid=2362 stamp=962788789
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_2_seq_263.29450.962794049 recid=2366 stamp=962794048
archive log filename=+DATA/abc/archivelog/2017_12_15/thread_2_seq_264.18943.962833323 recid=2370 stamp=962833323
archive log filename=+DATA/abc/archivelog/2017_12_17/thread_2_seq_265.19263.962999155 recid=2375 stamp=962999154
archive log filename=+DATA/abc/archivelog/2017_12_18/thread_2_seq_266.23074.963072619 recid=2378 stamp=963072618
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_2_seq_267.24976.963131201 recid=2383 stamp=963131201
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_2_seq_268.24969.963131463 recid=2387 stamp=963131462
archive log filename=+DATA/abc/archivelog/2017_12_19/thread_2_seq_269.28806.963156295 recid=2390 stamp=963156294
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_2_seq_270.24342.963226039 recid=2394 stamp=963226038
archive log filename=+DATA/abc/archivelog/2017_12_20/thread_2_seq_271.20802.963251455 recid=2398 stamp=963251455
archive log filename=+DATA/abc/archivelog/2017_12_21/thread_2_seq_272.20106.963352817 recid=2402 stamp=963352818
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_2_seq_273.20068.963375235 recid=2406 stamp=963375234
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_2_seq_274.23105.963413795 recid=2410 stamp=963413794
archive log filename=+DATA/abc/archivelog/2017_12_22/thread_2_seq_275.19191.963422199 recid=2414 stamp=963422198
archive log filename=+DATA/abc/archivelog/2017_12_23/thread_2_seq_276.20920.963499723 recid=2418 stamp=963499722
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_2_seq_277.19539.963672757 recid=2422 stamp=963672757
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_2_seq_278.25646.963677911 recid=2427 stamp=963677911
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_2_seq_279.25639.963678047 recid=2430 stamp=963678046
archive log filename=+DATA/abc/archivelog/2017_12_25/thread_2_seq_280.25614.963679519 recid=2434 stamp=963679519
archive log filename=+DATA/abc/archivelog/2017_12_26/thread_2_seq_281.30273.963764481 recid=2439 stamp=963764480
archive log filename=+DATA/abc/archivelog/2017_12_27/thread_2_seq_282.20848.963850577 recid=2442 stamp=963850578
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_2_seq_283.32571.963908411 recid=2446 stamp=963908411
archive log filename=+DATA/abc/archivelog/2017_12_28/thread_2_seq_284.32485.963918033 recid=2450 stamp=963918032
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_2_seq_285.30156.964016985 recid=2454 stamp=964016986
archive log filename=+DATA/abc/archivelog/2017_12_29/thread_2_seq_286.32972.964039975 recid=2459 stamp=964039975
archive log filename=+DATA/abc/archivelog/2018_01_02/thread_2_seq_287.26327.964368129 recid=2462 stamp=964368131
archive log filename=+DATA/abc/archivelog/2018_01_03/thread_2_seq_288.18761.964422165 recid=2466 stamp=964422164
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=2 sequence=289 recid=2471 stamp=964474724
input archive log thread=2 sequence=290 recid=2474 stamp=964908013
input archive log thread=2 sequence=291 recid=2479 stamp=965227301
input archive log thread=2 sequence=292 recid=2482 stamp=965513403
input archive log thread=2 sequence=293 recid=2486 stamp=965814129
input archive log thread=2 sequence=294 recid=2490 stamp=966074038
input archive log thread=2 sequence=295 recid=2494 stamp=966176992
input archive log thread=2 sequence=296 recid=2497 stamp=966177684
input archive log thread=2 sequence=297 recid=2501 stamp=966178281
input archive log thread=2 sequence=298 recid=2505 stamp=966178587
input archive log thread=2 sequence=299 recid=2509 stamp=966178713
input archive log thread=2 sequence=300 recid=2513 stamp=966178953
input archive log thread=2 sequence=301 recid=2518 stamp=966181677
input archive log thread=2 sequence=302 recid=2521 stamp=966182328
input archive log thread=2 sequence=303 recid=2523 stamp=966237178
input archive log thread=2 sequence=304 recid=2527 stamp=966413642
input archive log thread=2 sequence=305 recid=2531 stamp=966638048
input archive log thread=2 sequence=306 recid=2533 stamp=966928521
input archive log thread=2 sequence=307 recid=2537 stamp=967024117
input archive log thread=2 sequence=308 recid=2541 stamp=967044238
input archive log thread=2 sequence=309 recid=2544 stamp=967047344
input archive log thread=2 sequence=310 recid=2549 stamp=967050638
input archive log thread=2 sequence=311 recid=2552 stamp=967055219
input archive log thread=2 sequence=312 recid=2556 stamp=967065053
input archive log thread=2 sequence=313 recid=2560 stamp=967069363
input archive log thread=2 sequence=314 recid=2565 stamp=967374732
input archive log thread=2 sequence=315 recid=2567 stamp=967672850
input archive log thread=2 sequence=316 recid=2570 stamp=968158814
input archive log thread=2 sequence=317 recid=2574 stamp=968738420
input archive log thread=2 sequence=318 recid=2578 stamp=968856656
input archive log thread=2 sequence=319 recid=2581 stamp=968922290
input archive log thread=2 sequence=320 recid=2585 stamp=969100341
input archive log thread=2 sequence=321 recid=2590 stamp=969632448
input archive log thread=2 sequence=322 recid=2594 stamp=969962418
input archive log thread=2 sequence=323 recid=2595 stamp=970046718
channel ORA_DISK_1: starting piece 1 at 2018/03/06 09:32:43
channel ORA_DISK_1: finished piece 1 at 2018/03/06 09:33:18
piece handle=/arch_rman/abc_T_17st3flq_1_1_arc.rman tag=TAG20180306T092526 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_1: deleting archive log(s)
archive log filename=+DATA/abc/archivelog/2018_01_03/thread_2_seq_289.32304.964474725 recid=2471 stamp=964474724
archive log filename=+DATA/abc/archivelog/2018_01_08/thread_2_seq_290.20104.964908011 recid=2474 stamp=964908013
archive log filename=+DATA/abc/archivelog/2018_01_12/thread_2_seq_291.23920.965227299 recid=2479 stamp=965227301
archive log filename=+DATA/abc/archivelog/2018_01_15/thread_2_seq_292.24678.965513401 recid=2482 stamp=965513403
archive log filename=+DATA/abc/archivelog/2018_01_19/thread_2_seq_293.34549.965814127 recid=2486 stamp=965814129
archive log filename=+DATA/abc/archivelog/2018_01_22/thread_2_seq_294.27518.966074035 recid=2490 stamp=966074038
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_295.27106.966176991 recid=2494 stamp=966176992
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_296.27098.966177685 recid=2497 stamp=966177684
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_297.27090.966178281 recid=2501 stamp=966178281
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_298.33820.966178587 recid=2505 stamp=966178587
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_299.33809.966178713 recid=2509 stamp=966178713
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_300.33798.966178953 recid=2513 stamp=966178953
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_301.33766.966181677 recid=2518 stamp=966181677
archive log filename=+DATA/abc/archivelog/2018_01_23/thread_2_seq_302.33753.966182329 recid=2521 stamp=966182328
archive log filename=+DATA/abc/archivelog/2018_01_24/thread_2_seq_303.32421.966237177 recid=2523 stamp=966237178
archive log filename=+DATA/abc/archivelog/2018_01_26/thread_2_seq_304.28647.966413641 recid=2527 stamp=966413642
archive log filename=+DATA/abc/archivelog/2018_01_28/thread_2_seq_305.28259.966638047 recid=2531 stamp=966638048
archive log filename=+DATA/abc/archivelog/2018_02_01/thread_2_seq_306.23307.966928519 recid=2533 stamp=966928521
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_307.21332.967024117 recid=2537 stamp=967024117
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_308.32030.967044239 recid=2541 stamp=967044238
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_309.32003.967047343 recid=2544 stamp=967047344
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_310.31420.967050639 recid=2549 stamp=967050638
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_311.31387.967055219 recid=2552 stamp=967055219
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_312.31368.967065053 recid=2556 stamp=967065053
archive log filename=+DATA/abc/archivelog/2018_02_02/thread_2_seq_313.31350.967069361 recid=2560 stamp=967069363
archive log filename=+DATA/abc/archivelog/2018_02_06/thread_2_seq_314.31478.967374729 recid=2565 stamp=967374732
archive log filename=+DATA/abc/archivelog/2018_02_09/thread_2_seq_315.24907.967672847 recid=2567 stamp=967672850
archive log filename=+DATA/abc/archivelog/2018_02_15/thread_2_seq_316.25084.968158811 recid=2570 stamp=968158814
archive log filename=+DATA/abc/archivelog/2018_02_22/thread_2_seq_317.21380.968738419 recid=2574 stamp=968738420
archive log filename=+DATA/abc/archivelog/2018_02_23/thread_2_seq_318.30313.968856655 recid=2578 stamp=968856656
archive log filename=+DATA/abc/archivelog/2018_02_24/thread_2_seq_319.25778.968922289 recid=2581 stamp=968922290
archive log filename=+DATA/abc/archivelog/2018_02_26/thread_2_seq_320.26961.969100341 recid=2585 stamp=969100341
archive log filename=+DATA/abc/archivelog/2018_03_01/thread_2_seq_321.31868.969632447 recid=2590 stamp=969632448
archive log filename=+DATA/abc/archivelog/2018_03_05/thread_2_seq_322.22250.969962417 recid=2594 stamp=969962418
archive log filename=+DATA/abc/archivelog/2018_03_06/thread_2_seq_323.20414.970046717 recid=2595 stamp=970046718
Finished backup at 2018/03/06 09:33:20
Starting Control File and SPFILE Autobackup at 2018/03/06 09:33:20
piece handle=/s01/db/dbs/c-207178794-20180306-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2018/03/06 09:33:22
RMAN>
备份完成后：
$ pwd
/arch_rman
$ ls
abc_T_0esm10kp_1_1_arc.rman
abc_T_0fsm10oa_1_1_arc.rman
abc_T_0gsm10rr_1_1_arc.rman
abc_T_0hsm10vd_1_1_arc.rman
abc_T_0ism1131_1_1_arc.rman
abc_T_0jsm116l_1_1_arc.rman
abc_T_0ksm11a5_1_1_arc.rman
abc_T_0lsm11dn_1_1_arc.rman
abc_T_0msm11h9_1_1_arc.rman
abc_T_0nsm11kr_1_1_arc.rman
abc_T_0osm11oe_1_1_arc.rman
abc_T_0psm11rv_1_1_arc.rman
abc_T_0qsm11vh_1_1_arc.rman
abc_T_0rsm1234_1_1_arc.rman
abc_T_0ssm126k_1_1_arc.rman
abc_T_0tsm12ak_1_1_arc.rman
abc_T_0usm12d2_1_1_arc.rman
abc_T_0vsm12el_1_1_arc.rman
abc_T_10sm12fj_1_1_arc.rman
abc_T_11sm12gi_1_1_arc.rman
abc_T_13st3f8d_1_1_arc.rman
abc_T_14st3fc6_1_1_arc.rman
abc_T_15st3ffo_1_1_arc.rman
abc_T_16st3fj8_1_1_arc.rman
abc_T_17st3flq_1_1_arc.rman
nohup.out
rman_arch_ldhygeia.sh
rman_arch_abc.sh
$
$ export ORACLE_SID=abc1
$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Mar 6 09:41:05 2018
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: abc (DBID=207178794)
RMAN> list archivelog all;
using target database control file instead of recovery catalog
specification does not match any archive log in the recovery catalog
RMAN>
浙公网安备 33010602011771号