I come, I see, I conquer

                    —Gaius Julius Caesar

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 :: 管理 ::

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>

posted on 2016-03-23 09:35  jcsu  阅读(566)  评论(0)    收藏  举报