rman异地恢复过程日志

备份脚本https://blog.51cto.com/860143/2413679

成都创新互联公司是一家集网站建设,麦盖提企业网站建设,麦盖提品牌网站建设,网站定制,麦盖提网站建设报价,网络营销,网络优化,麦盖提网站推广为一体的创新建站企业，帮助传统企业提升企业形象加强企业竞争力。可充分满足这一群体相比中小企业更为丰富、高端、多元的互联网需求。同时我们时刻保持专业、时尚、前沿，时刻以成就客户成长自我，坚持不断学习、思考、沉淀、净化自己，让我们为更多的企业打造出实用型网站。

[oracle@localhost dbs]$ ll
总用量 8
-rw-rw---- 1 oracle oinstall 1552 12月 25 11:08 hc_TSH1.dat
-rw-r--r-- 1 oracle oinstall 1091 12月 25 09:26 initTSH1.ora
[oracle@localhost dbs]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Dec 25 11:21:24 2019

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

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area 1224736768 bytes

Fixed Size 2020384 bytes
Variable Size 318770144 bytes
Database Buffers 889192448 bytes
Redo Buffers 14753792 bytes

RMAN> exit

Recovery Manager complete.
[oracle@localhost dbs]$ ll /u01/app/backup/
总用量 10995524
-rw-r----- 1 oracle oinstall 14179328 12月 19 01:13 rman_arch_KEHLCOM_23806_20191219_1_7uujpbeb_1_1.bkupset
-rw-r----- 1 oracle oinstall 11728384 12月 19 01:13 rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset
-rw-r----- 1 oracle oinstall 2560 12月 19 01:13 rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset
-rw-r----- 1 oracle oinstall 13533184 12月 19 01:13 rman_control_7sujpbe3_1_1.ctl
-rw-r----- 1 oracle oinstall 5725913088 12月 19 01:13 rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset
-rw-r----- 1 oracle oinstall 2552856576 12月 19 01:07 rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset
-rw-r----- 1 oracle oinstall 2939002880 12月 19 01:09 rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset
-rw-r----- 1 oracle oinstall 1998848 12月 19 01:07 rman_db_KEHLCOM_23802_20191219_1_7qujpb2k_1_1.bkupset
-rw-r----- 1 oracle oinstall 98304 12月 19 01:07 rman_db_KEHLCOM_23803_20191219_1_7rujpb2m_1_1.bkupset
-rw-r----- 1 oracle oinstall 98304 12月 19 01:13 kehl_spfile_7tujpbe4_1_1
[oracle@localhost dbs]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Dec 25 11:23:21 2019

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

connected to target database: kehlcom (not mounted)

RMAN> restore spfile from '/u01/app/backup/kehl_spfile_7tujpbe4_1_1';

Starting restore at 25-DEC-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=431 devtype=DISK

channel ORA_DISK_1: autobackup found: /u01/app/backup/kehl_spfile_7tujpbe4_1_1
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 25-DEC-19

RMAN> shutdown immediate;

Oracle instance shut down

RMAN> exit

Recovery Manager complete.
[oracle@localhost dbs]$ ll
总用量 12
-rw-rw---- 1 oracle oinstall 1552 12月 25 11:23 hc_TSH1.dat
-rw-r--r-- 1 oracle oinstall 1091 12月 25 09:26 initTSH1.ora
-rw-r----- 1 oracle oinstall 3584 12月 25 11:23 spfileTSH1.ora
[oracle@localhost dbs]$ strings spfileTSH1.ora
kehlcom.db_cache_size=8237613056
kehlcom.java_pool_size=16777216
kehlcom.large_pool_size=16777216
kehlcom.shared_pool_size=301989888
kehlcom.streams_pool_size=0
.audit_file_dest='/u01/oracle/admin/kehlcom/adump'
.audit_sys_operations=TRUE
.audit_trail='db','extended'
.background_dump_dest='/u01/oracle/admin/kehlcom/bdump'
.control_files='/u01/oradata/kehlcom/control1.ctl','/u01/oradata/kehlcom/control2.ctl','/u01/oradata/kehlcom/control3.','ctl'
.core_dump_dest='/u01/oracle/admin/kehlcom/cdump'
.db_block_size=8192
.db_create_file_dest='/u01/oradata'
.db_create_online_log_dest_1='/u01/oradata'
.db_domain='kehlcom'
.db_name='kehlcom'
.db_recovery_file_dest_size=21474836480
.db_recovery_file_dest='/u01/arch/flashbakdb'
.db_unique_name='kehlcom'
.job_queue_processes=10
.log_archive_dest_1='LOCATION=/u01/arch/kehlcom'
.log_archiveformat='log%t%s%r.arc'
.open_cursors=1500
.processes=400
.sga_max_size=8192M
.sga_target=8192M
.undo_management='AUTO'
.undo_retention=10800
.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/admin/kehlcom/udump'
[oracle@localhost dbs]$ strings spfileTSH1.ora >initTSH1.ora
[oracle@localhost dbs]$ rm initTSH1.ora
[oracle@localhost dbs]$ cp /tmp/initTSH1.ora .
[oracle@localhost dbs]$ cat initTSH1.ora
kehlcom.db_cache_size=838860800
kehlcom.java_pool_size=16777216
kehlcom.large_pool_size=16777216
kehlcom.shared_pool_size=251658240
kehlcom.streams_pool_size=0
.audit_file_dest='/u01/oracle/admin/kehlcom/adump'
.audit_sys_operations=TRUE
.audit_trail='db','extended'
.background_dump_dest='/u01/oracle/admin/kehlcom/bdump'
.control_files='/u01/oradata/kehlcom/control1.ctl','/u01/oradata/kehlcom/control2.ctl','/u01/oradata/kehlcom/control3.ctl'
.core_dump_dest='/u01/oracle/admin/kehlcom/cdump'
.db_block_size=8192
.db_create_file_dest='/u01/oradata'
.db_create_online_log_dest_1='/u01/oradata'
.db_domain='kehlcom'
.db_name='kehlcom'
.db_recovery_file_dest_size=21474836480
.db_recovery_file_dest='/u01/arch/flashbakdb'
.db_unique_name='kehlcom'
.job_queue_processes=10
.log_archive_dest_1='LOCATION=/u01/arch/kehlcom'
.log_archiveformat='log%t%s%r.arc'
.open_cursors=1500
.processes=400
.sga_target=1210056704
.undo_management='AUTO'
.undo_retention=10800
.undo_tablespace='UNDOTBS1'
.user_dump_dest='/u01/oracle/admin/kehlcom/udump'
[oracle@localhost dbs]$ mkdir -p /u01/oracle/admin/kehlcom/adump
mkdir -p /u01/oracle/admin/kehlcom/bdump
[oracle@localhost dbs]$ mkdir -p /u01/oracle/admin/kehlcom/bdump
[oracle@localhost dbs]$ mkdir -p /u01/oradata/kehlcom/
[oracle@localhost dbs]$ mkdir -p /u01/oracle/admin/kehlcom/cdump
[oracle@localhost dbs]$ mkdir -p /u01/arch/flashbakdb
[oracle@localhost dbs]$ mkdir -p /u01/arch/kehlcom
[oracle@localhost dbs]$ mkdir -p /u01/oracle/admin/kehlcom/udump
[oracle@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 25 11:25:48 2019

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

Connected to an idle instance.

SQL> startup nomount pfile=/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH1.ora
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 318770144 bytes
Database Buffers 889192448 bytes
Redo Buffers 14753792 bytes
SQL> create spfile from pfile;

File created.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost dbs]$ strings spfileTSH1.ora
q&E=
kehlcom.db_cache_size=838860800
kehlcom.java_pool_size=16777216
kehlcom.large_pool_size=16777216
kehlcom.shared_pool_size=251658240
kehlcom.__streams_pool_size=0
.audit_file_dest='/u01/oracle/admin/kehlcom/adump'
.audit_sys_operations=TRUE
.audit_trail='db','extended'
.background_dump_dest='/u01/oracle/admin/kehlcom/bdump'
.control_files='/u01/oradata/kehlcom/control1.ctl','/u01/oradata/kehlcom/control2.ctl','/u01/oradata/kehlcom/control3.ctl'
.core_dump_dest='/u01/oracle/admin/kehlcom/cdump'
.db_block_size=8192
.db_create_file_dest='/u01/oradata'
.db_create_online_log_dest_1='/u01/oradata'
.db_domain='kehlcom'
.db_name='kehlcom'
.db_recovery_file_dest_size=21474836480
.db_recovery_file_dest='/u01/arch/flashbakdb'
.db_unique_name='kehlcom'
.job_queue_processes=10
.log_archive_dest_1='LOCATION=/u01/arch/kehlcom'
.log_archiveformat='log%t%s%r.arc'
.open_cursors=1500
.processes=400
.sga_target=1210056704
.undo_management='AUTO'
.undo_retention=10800
.undo_tablespace='UNDOTBS1'
.user_dump_dest='/u01/oracle/admin/kehlcom/udump'

[oracle@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 25 11:27:26 2019

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost dbs]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Dec 25 11:27:58 2019

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

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area 1224736768 bytes

Fixed Size 2020384 bytes
Variable Size 318770144 bytes
Database Buffers 889192448 bytes
Redo Buffers 14753792 bytes

RMAN> restore controlfile from '/u01/app/backup/rman_control_7sujpbe3_1_1.ctl';

Starting restore at 25-DEC-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=431 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/oradata/kehlcom/control1.ctl
output filename=/u01/oradata/kehlcom/control2.ctl
output filename=/u01/oradata/kehlcom/control3.ctl
Finished restore at 25-DEC-19

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> crosscheck backup ;

Starting implicit crosscheck backup at 25-DEC-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=431 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=430 devtype=DISK
Crosschecked 5 objects
Crosschecked 54 objects
Finished implicit crosscheck backup at 25-DEC-19

Starting implicit crosscheck copy at 25-DEC-19
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished implicit crosscheck copy at 25-DEC-19

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

using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset recid=23475 stamp=1027386017
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23802_20191219_1_7qujpb2k_1_1.bkupset recid=23476 stamp=1027386453
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23803_20191219_1_7rujpb2m_1_1.bkupset recid=23477 stamp=1027386455
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset recid=23478 stamp=1027386017
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset recid=23479 stamp=1027386017
Crosschecked 5 objects

crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23740_20191213_1_5suj9gd2_1_1.bkupset recid=23415 stamp=1026867619
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23741_20191213_1_5tuj9gd2_1_1.bkupset recid=23418 stamp=1026867619
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23739_20191213_1_5ruj9gd2_1_1.bkupset recid=23419 stamp=1026867619
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_control_60uj9h7e_1_1.ctl recid=23420 stamp=1026868430
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23747_20191213_1_63uj9h7p_1_1.bkupset recid=23422 stamp=1026868442
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23750_20191214_1_66ujc4p2_1_1.bkupset recid=23425 stamp=1026954019
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23752_20191214_1_68ujc57j_1_1.bkupset recid=23426 stamp=1026954483
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23751_20191214_1_67ujc4p2_1_1.bkupset recid=23428 stamp=1026954019
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23749_20191214_1_65ujc4p2_1_1.bkupset recid=23429 stamp=1026954018
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_control_6aujc5ie_1_1.ctl recid=23430 stamp=1026954830
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/kehl_spfile_6bujc5if_1_1 recid=23431 stamp=1026954832
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23758_20191214_1_6eujc5ip_1_1.bkupset recid=23432 stamp=1026954842
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23756_20191214_1_6cujc5ip_1_1.bkupset recid=23433 stamp=1026954842
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23757_20191214_1_6dujc5ip_1_1.bkupset recid=23434 stamp=1026954842
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23760_20191215_1_6gujep52_1_1.bkupset recid=23435 stamp=1027040418
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23762_20191215_1_6iujepil_1_1.bkupset recid=23436 stamp=1027040853
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23763_20191215_1_6jujepim_1_1.bkupset recid=23437 stamp=1027040854
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23761_20191215_1_6hujep52_1_1.bkupset recid=23438 stamp=1027040419
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23759_20191215_1_6fujep52_1_1.bkupset recid=23439 stamp=1027040420
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_control_6kujepud_1_1.ctl recid=23440 stamp=1027041229
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/kehl_spfile_6lujepue_1_1 recid=23441 stamp=1027041231
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23768_20191215_1_6oujepul_1_1.bkupset recid=23442 stamp=1027041238
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23767_20191215_1_6nujepul_1_1.bkupset recid=23443 stamp=1027041238
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23766_20191215_1_6mujepul_1_1.bkupset recid=23444 stamp=1027041238
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23770_20191216_1_6qujhdgv_1_1.bkupset recid=23445 stamp=1027126816
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23772_20191216_1_6sujhdui_1_1.bkupset recid=23446 stamp=1027127250
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23773_20191216_1_6tujhduj_1_1.bkupset recid=23447 stamp=1027127252
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23771_20191216_1_6rujhdgv_1_1.bkupset recid=23448 stamp=1027126816
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23769_20191216_1_6pujhdgv_1_1.bkupset recid=23449 stamp=1027126817
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_control_6uujheb9_1_1.ctl recid=23450 stamp=1027127657
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/kehl_spfile_6vujheba_1_1 recid=23451 stamp=1027127659
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23778_20191216_1_72ujhebh_1_1.bkupset recid=23452 stamp=1027127666
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23777_20191216_1_71ujhebh_1_1.bkupset recid=23453 stamp=1027127666
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23776_20191216_1_70ujhebh_1_1.bkupset recid=23454 stamp=1027127666
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23780_20191217_1_74ujk1sv_1_1.bkupset recid=23455 stamp=1027213216
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23782_20191217_1_76ujk2as_1_1.bkupset recid=23456 stamp=1027213660
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23783_20191217_1_77ujk2au_1_1.bkupset recid=23457 stamp=1027213663
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23781_20191217_1_75ujk1sv_1_1.bkupset recid=23458 stamp=1027213216
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23779_20191217_1_73ujk1sv_1_1.bkupset recid=23459 stamp=1027213216
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_control_78ujk2nt_1_1.ctl recid=23460 stamp=1027214077
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/kehl_spfile_79ujk2nu_1_1 recid=23461 stamp=1027214079
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23788_20191217_1_7cujk2o5_1_1.bkupset recid=23462 stamp=1027214086
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23786_20191217_1_7aujk2o5_1_1.bkupset recid=23463 stamp=1027214086
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23787_20191217_1_7bujk2o5_1_1.bkupset recid=23464 stamp=1027214086
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23790_20191218_1_7eujmm8u_1_1.bkupset recid=23465 stamp=1027299614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23792_20191218_1_7gujmmms_1_1.bkupset recid=23466 stamp=1027300060
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23793_20191218_1_7hujmmmt_1_1.bkupset recid=23467 stamp=1027300062
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23791_20191218_1_7fujmm8u_1_1.bkupset recid=23468 stamp=1027299614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23789_20191218_1_7dujmm8u_1_1.bkupset recid=23469 stamp=1027299614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_control_7iujmn2a_1_1.ctl recid=23470 stamp=1027300426
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/kehl_spfile_7jujmn2c_1_1 recid=23471 stamp=1027300429
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23798_20191218_1_7mujmn2j_1_1.bkupset recid=23472 stamp=1027300436
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23797_20191218_1_7lujmn2j_1_1.bkupset recid=23473 stamp=1027300436
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23796_20191218_1_7kujmn2j_1_1.bkupset recid=23474 stamp=1027300436
Crosschecked 54 objects

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=431 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=430 devtype=DISK
validation failed for archived log
archive log filename=/u01/arch/kehlcom/log_1_187271_818622878.arc recid=187883 stamp=1027375209
Crosschecked 1 objects

RMAN> delete expired backup;

using channel ORA_DISK_1
using channel ORA_DISK_2

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name

23415 23415 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23740_20191213_1_5suj9gd2_1_1.bkupset
23418 23418 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23741_20191213_1_5tuj9gd2_1_1.bkupset
23419 23419 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23739_20191213_1_5ruj9gd2_1_1.bkupset
23420 23420 1 1 EXPIRED DISK /u01/app/backup/rman_control_60uj9h7e_1_1.ctl
23422 23422 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23747_20191213_1_63uj9h7p_1_1.bkupset
23425 23425 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23750_20191214_1_66ujc4p2_1_1.bkupset
23426 23426 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23752_20191214_1_68ujc57j_1_1.bkupset
23428 23428 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23751_20191214_1_67ujc4p2_1_1.bkupset
23429 23429 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23749_20191214_1_65ujc4p2_1_1.bkupset
23430 23430 1 1 EXPIRED DISK /u01/app/backup/rman_control_6aujc5ie_1_1.ctl
23431 23431 1 1 EXPIRED DISK /u01/app/backup/kehl_spfile_6bujc5if_1_1
23432 23432 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23758_20191214_1_6eujc5ip_1_1.bkupset
23433 23433 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23756_20191214_1_6cujc5ip_1_1.bkupset
23434 23434 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23757_20191214_1_6dujc5ip_1_1.bkupset
23435 23435 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23760_20191215_1_6gujep52_1_1.bkupset
23436 23436 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23762_20191215_1_6iujepil_1_1.bkupset
23437 23437 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23763_20191215_1_6jujepim_1_1.bkupset
23438 23438 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23761_20191215_1_6hujep52_1_1.bkupset
23439 23439 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23759_20191215_1_6fujep52_1_1.bkupset
23440 23440 1 1 EXPIRED DISK /u01/app/backup/rman_control_6kujepud_1_1.ctl
23441 23441 1 1 EXPIRED DISK /u01/app/backup/kehl_spfile_6lujepue_1_1
23442 23442 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23768_20191215_1_6oujepul_1_1.bkupset
23443 23443 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23767_20191215_1_6nujepul_1_1.bkupset
23444 23444 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23766_20191215_1_6mujepul_1_1.bkupset
23445 23445 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23770_20191216_1_6qujhdgv_1_1.bkupset
23446 23446 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23772_20191216_1_6sujhdui_1_1.bkupset
23447 23447 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23773_20191216_1_6tujhduj_1_1.bkupset
23448 23448 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23771_20191216_1_6rujhdgv_1_1.bkupset
23449 23449 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23769_20191216_1_6pujhdgv_1_1.bkupset
23450 23450 1 1 EXPIRED DISK /u01/app/backup/rman_control_6uujheb9_1_1.ctl
23451 23451 1 1 EXPIRED DISK /u01/app/backup/kehl_spfile_6vujheba_1_1
23452 23452 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23778_20191216_1_72ujhebh_1_1.bkupset
23453 23453 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23777_20191216_1_71ujhebh_1_1.bkupset
23454 23454 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23776_20191216_1_70ujhebh_1_1.bkupset
23455 23455 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23780_20191217_1_74ujk1sv_1_1.bkupset
23456 23456 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23782_20191217_1_76ujk2as_1_1.bkupset
23457 23457 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23783_20191217_1_77ujk2au_1_1.bkupset
23458 23458 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23781_20191217_1_75ujk1sv_1_1.bkupset
23459 23459 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23779_20191217_1_73ujk1sv_1_1.bkupset
23460 23460 1 1 EXPIRED DISK /u01/app/backup/rman_control_78ujk2nt_1_1.ctl
23461 23461 1 1 EXPIRED DISK /u01/app/backup/kehl_spfile_79ujk2nu_1_1
23462 23462 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23788_20191217_1_7cujk2o5_1_1.bkupset
23463 23463 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23786_20191217_1_7aujk2o5_1_1.bkupset
23464 23464 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23787_20191217_1_7bujk2o5_1_1.bkupset
23465 23465 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23790_20191218_1_7eujmm8u_1_1.bkupset
23466 23466 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23792_20191218_1_7gujmmms_1_1.bkupset
23467 23467 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23793_20191218_1_7hujmmmt_1_1.bkupset
23468 23468 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23791_20191218_1_7fujmm8u_1_1.bkupset
23469 23469 1 1 EXPIRED DISK /u01/app/backup/rman_db_KEHLCOM_23789_20191218_1_7dujmm8u_1_1.bkupset
23470 23470 1 1 EXPIRED DISK /u01/app/backup/rman_control_7iujmn2a_1_1.ctl
23471 23471 1 1 EXPIRED DISK /u01/app/backup/kehl_spfile_7jujmn2c_1_1
23472 23472 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23798_20191218_1_7mujmn2j_1_1.bkupset
23473 23473 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23797_20191218_1_7lujmn2j_1_1.bkupset
23474 23474 1 1 EXPIRED DISK /u01/app/backup/rman_arch_KEHLCOM_23796_20191218_1_7kujmn2j_1_1.bkupset

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23740_20191213_1_5suj9gd2_1_1.bkupset recid=23415 stamp=1026867619
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23741_20191213_1_5tuj9gd2_1_1.bkupset recid=23418 stamp=1026867619
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23739_20191213_1_5ruj9gd2_1_1.bkupset recid=23419 stamp=1026867619
deleted backup piece
backup piece handle=/u01/app/backup/rman_control_60uj9h7e_1_1.ctl recid=23420 stamp=1026868430
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23747_20191213_1_63uj9h7p_1_1.bkupset recid=23422 stamp=1026868442
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23750_20191214_1_66ujc4p2_1_1.bkupset recid=23425 stamp=1026954019
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23752_20191214_1_68ujc57j_1_1.bkupset recid=23426 stamp=1026954483
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23751_20191214_1_67ujc4p2_1_1.bkupset recid=23428 stamp=1026954019
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23749_20191214_1_65ujc4p2_1_1.bkupset recid=23429 stamp=1026954018
deleted backup piece
backup piece handle=/u01/app/backup/rman_control_6aujc5ie_1_1.ctl recid=23430 stamp=1026954830
deleted backup piece
backup piece handle=/u01/app/backup/kehl_spfile_6bujc5if_1_1 recid=23431 stamp=1026954832
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23758_20191214_1_6eujc5ip_1_1.bkupset recid=23432 stamp=1026954842
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23756_20191214_1_6cujc5ip_1_1.bkupset recid=23433 stamp=1026954842
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23757_20191214_1_6dujc5ip_1_1.bkupset recid=23434 stamp=1026954842
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23760_20191215_1_6gujep52_1_1.bkupset recid=23435 stamp=1027040418
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23762_20191215_1_6iujepil_1_1.bkupset recid=23436 stamp=1027040853
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23763_20191215_1_6jujepim_1_1.bkupset recid=23437 stamp=1027040854
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23761_20191215_1_6hujep52_1_1.bkupset recid=23438 stamp=1027040419
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23759_20191215_1_6fujep52_1_1.bkupset recid=23439 stamp=1027040420
deleted backup piece
backup piece handle=/u01/app/backup/rman_control_6kujepud_1_1.ctl recid=23440 stamp=1027041229
deleted backup piece
backup piece handle=/u01/app/backup/kehl_spfile_6lujepue_1_1 recid=23441 stamp=1027041231
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23768_20191215_1_6oujepul_1_1.bkupset recid=23442 stamp=1027041238
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23767_20191215_1_6nujepul_1_1.bkupset recid=23443 stamp=1027041238
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23766_20191215_1_6mujepul_1_1.bkupset recid=23444 stamp=1027041238
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23770_20191216_1_6qujhdgv_1_1.bkupset recid=23445 stamp=1027126816
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23772_20191216_1_6sujhdui_1_1.bkupset recid=23446 stamp=1027127250
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23773_20191216_1_6tujhduj_1_1.bkupset recid=23447 stamp=1027127252
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23771_20191216_1_6rujhdgv_1_1.bkupset recid=23448 stamp=1027126816
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23769_20191216_1_6pujhdgv_1_1.bkupset recid=23449 stamp=1027126817
deleted backup piece
backup piece handle=/u01/app/backup/rman_control_6uujheb9_1_1.ctl recid=23450 stamp=1027127657
deleted backup piece
backup piece handle=/u01/app/backup/kehl_spfile_6vujheba_1_1 recid=23451 stamp=1027127659
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23778_20191216_1_72ujhebh_1_1.bkupset recid=23452 stamp=1027127666
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23777_20191216_1_71ujhebh_1_1.bkupset recid=23453 stamp=1027127666
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23776_20191216_1_70ujhebh_1_1.bkupset recid=23454 stamp=1027127666
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23780_20191217_1_74ujk1sv_1_1.bkupset recid=23455 stamp=1027213216
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23782_20191217_1_76ujk2as_1_1.bkupset recid=23456 stamp=1027213660
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23783_20191217_1_77ujk2au_1_1.bkupset recid=23457 stamp=1027213663
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23781_20191217_1_75ujk1sv_1_1.bkupset recid=23458 stamp=1027213216
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23779_20191217_1_73ujk1sv_1_1.bkupset recid=23459 stamp=1027213216
deleted backup piece
backup piece handle=/u01/app/backup/rman_control_78ujk2nt_1_1.ctl recid=23460 stamp=1027214077
deleted backup piece
backup piece handle=/u01/app/backup/kehl_spfile_79ujk2nu_1_1 recid=23461 stamp=1027214079
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23788_20191217_1_7cujk2o5_1_1.bkupset recid=23462 stamp=1027214086
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23786_20191217_1_7aujk2o5_1_1.bkupset recid=23463 stamp=1027214086
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23787_20191217_1_7bujk2o5_1_1.bkupset recid=23464 stamp=1027214086
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23790_20191218_1_7eujmm8u_1_1.bkupset recid=23465 stamp=1027299614
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23792_20191218_1_7gujmmms_1_1.bkupset recid=23466 stamp=1027300060
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23793_20191218_1_7hujmmmt_1_1.bkupset recid=23467 stamp=1027300062
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23791_20191218_1_7fujmm8u_1_1.bkupset recid=23468 stamp=1027299614
deleted backup piece
backup piece handle=/u01/app/backup/rman_db_KEHLCOM_23789_20191218_1_7dujmm8u_1_1.bkupset recid=23469 stamp=1027299614
deleted backup piece
backup piece handle=/u01/app/backup/rman_control_7iujmn2a_1_1.ctl recid=23470 stamp=1027300426
deleted backup piece
backup piece handle=/u01/app/backup/kehl_spfile_7jujmn2c_1_1 recid=23471 stamp=1027300429
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23798_20191218_1_7mujmn2j_1_1.bkupset recid=23472 stamp=1027300436
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23797_20191218_1_7lujmn2j_1_1.bkupset recid=23473 stamp=1027300436
deleted backup piece
backup piece handle=/u01/app/backup/rman_arch_KEHLCOM_23796_20191218_1_7kujmn2j_1_1.bkupset recid=23474 stamp=1027300436
Deleted 54 EXPIRED objects

RMAN> list backup;

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

23475 Full 2.38G DISK 00:07:11 19-DEC-19
BP Key: 23475 Status: AVAILABLE Compressed: YES Tag: TAG20191219T010017
Piece Name: /u01/app/backup/rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset
List of Datafiles in backup set 23475
File LV Type Ckp SCN Ckp Time Name

1 Full 11675067553 19-DEC-19 /u01/oradata/kehlcom/system.dbf
5 Full 11675067553 19-DEC-19 /u01/oradata/kehlcom/ebuy_user01.dbf
8 Full 11675067553 19-DEC-19 /u01/oradata/kehlcom/kehlcom_user03.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

23476 Full 1.89M DISK 00:00:01 19-DEC-19
BP Key: 23476 Status: AVAILABLE Compressed: YES Tag: TAG20191219T010017
Piece Name: /u01/app/backup/rman_db_KEHLCOM_23802_20191219_1_7qujpb2k_1_1.bkupset
Control File Included: Ckp SCN: 11675067921 Ckp time: 19-DEC-19

BS Key Type LV Size Device Type Elapsed Time Completion Time

23477 Full 80.00K DISK 00:00:01 19-DEC-19
BP Key: 23477 Status: AVAILABLE Compressed: YES Tag: TAG20191219T010017
Piece Name: /u01/app/backup/rman_db_KEHLCOM_23803_20191219_1_7rujpb2m_1_1.bkupset
SPFILE Included: Modification time: 17-DEC-19

BS Key Type LV Size Device Type Elapsed Time Completion Time

23478 Full 2.74G DISK 00:09:01 19-DEC-19
BP Key: 23478 Status: AVAILABLE Compressed: YES Tag: TAG20191219T010017
Piece Name: /u01/app/backup/rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset
List of Datafiles in backup set 23478
File LV Type Ckp SCN Ckp Time Name

2 Full 11675067554 19-DEC-19 /u01/oradata/kehlcom/undotbs1.dbf
4 Full 11675067554 19-DEC-19 /u01/oradata/kehlcom/kehlcom_user01.dbf
9 Full 11675067554 19-DEC-19 /u01/oradata/kehlcom/kehlcom_user04.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

23479 Full 5.33G DISK 00:13:16 19-DEC-19
BP Key: 23479 Status: AVAILABLE Compressed: YES Tag: TAG20191219T010017
Piece Name: /u01/app/backup/rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset
List of Datafiles in backup set 23479
File LV Type Ckp SCN Ckp Time Name

3 Full 11675067552 19-DEC-19 /u01/oradata/kehlcom/sysaux.dbf
6 Full 11675067552 19-DEC-19 /u01/oradata/kehlcom/kehlcom_user02.dbf
7 Full 11675067552 19-DEC-19 /u01/oradata/kehlcom/peiche_data_file1.dbf

RMAN> list backup of archivelog all;

RMAN> catalog start with '/u01/app/backup/' ;

searching for all files that match the pattern /u01/app/backup/

List of Files Unknown to the Database
=====================================

File Name: /u01/app/backup/rman_arch_KEHLCOM_23806_20191219_1_7uujpbeb_1_1.bkupset
File Name: /u01/app/backup/rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset
File Name: /u01/app/backup/rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset
File Name: /u01/app/backup/rman_control_7sujpbe3_1_1.ctl
File Name: /u01/app/backup/kehl_spfile_7tujpbe4_1_1

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files

File Name: /u01/app/backup/rman_arch_KEHLCOM_23806_20191219_1_7uujpbeb_1_1.bkupset
File Name: /u01/app/backup/rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset
File Name: /u01/app/backup/rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset
File Name: /u01/app/backup/rman_control_7sujpbe3_1_1.ctl
File Name: /u01/app/backup/kehl_spfile_7tujpbe4_1_1

RMAN> list backup of archivelog all;

List of Backup Sets
========= ==========

BS Key Size Device Type Elapsed Time Completion Time

23480 13.52M DISK 00:00:00 19-DEC-19
BP Key: 23480 Status: AVAILABLE Compressed: YES Tag: TAG20191219T011347
Piece Name: /u01/app/backup/rman_arch_KEHLCOM_23806_20191219_1_7uujpbeb_1_1.bkupset

List of Archived Logs in backup set 23480
Thrd Seq Low SCN Low Time Next SCN Next Time

1 187271 11675024959 18-DEC-19 11675057269 18-DEC-19

BS Key Size Device Type Elapsed Time Completion Time

23481 11.18M DISK 00:00:00 19-DEC-19
BP Key: 23481 Status: AVAILABLE Compressed: YES Tag: TAG20191219T011347
Piece Name: /u01/app/backup/rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset

List of Archived Logs in backup set 23481
Thrd Seq Low SCN Low Time Next SCN Next Time

1 187272 11675057269 18-DEC-19 11675068089 19-DEC-19

BS Key Size Device Type Elapsed Time Completion Time

23482 2.00K DISK 00:00:00 19-DEC-19
BP Key: 23482 Status: AVAILABLE Compressed: YES Tag: TAG20191219T011347
Piece Name: /u01/app/backup/rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset

List of Archived Logs in backup set 23482
Thrd Seq Low SCN Low Time Next SCN Next Time

1 18727311675068089 19-DEC-19 11675068109 19-DEC-19

RMAN>

RMAN> run{
2>
3> restore database;
4>
5> recover database;
6>
7> }

Starting restore at 25-DEC-19
using channel ORA_DISK_1
using channel ORA_DISK_2

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oradata/kehlcom/system.dbf
restoring datafile 00005 to /u01/oradata/kehlcom/ebuy_user01.dbf
restoring datafile 00008 to /u01/oradata/kehlcom/kehlcom_user03.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/oradata/kehlcom/undotbs1.dbf
restoring datafile 00004 to /u01/oradata/kehlcom/kehlcom_user01.dbf
restoring datafile 00009 to /u01/oradata/kehlcom/kehlcom_user04.dbf
channel ORA_DISK_2: reading from backup piece /u01/app/backup/rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_db_KEHLCOM_23800_20191219_1_7oujpal1_1_1.bkupset tag=TAG20191219T010017
channel ORA_DISK_1: restore complete, elapsed time: 00:08:55
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u01/oradata/kehlcom/sysaux.dbf
restoring datafile 00006 to /u01/oradata/kehlcom/kehlcom_user02.dbf
restoring datafile 00007 to /u01/oradata/kehlcom/peiche_data_file1.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset
channel ORA_DISK_2: restored backup piece 1
piece handle=/u01/app/backup/rman_db_KEHLCOM_23801_20191219_1_7pujpal1_1_1.bkupset tag=TAG20191219T010017
channel ORA_DISK_2: restore complete, elapsed time: 00:09:02
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_db_KEHLCOM_23799_20191219_1_7nujpal1_1_1.bkupset tag=TAG20191219T010017
channel ORA_DISK_1: restore complete, elapsed time: 00:18:23
Finished restore at 25-DEC-19

Starting recover at 25-DEC-19
using channel ORA_DISK_1
using channel ORA_DISK_2

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_2: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=187272
channel ORA_DISK_1: reading from backup piece /u01/app/backup/rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset
channel ORA_DISK_2: restoring archive log
archive log thread=1 sequence=187273
channel ORA_DISK_2: reading from backup piece /u01/app/backup/rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset
channel ORA_DISK_2: restored backup piece 1
piece handle=/u01/app/backup/rman_arch_KEHLCOM_23808_20191219_1_80ujpbeb_1_1.bkupset tag=TAG20191219T011347
channel ORA_DISK_2: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/backup/rman_arch_KEHLCOM_23807_20191219_1_7vujpbeb_1_1.bkupset tag=TAG20191219T011347
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
archive log filename=/u01/arch/kehlcom/log_1_187272_818622878.arc thread=1 sequence=187272
archive log filename=/u01/arch/kehlcom/log_1_187273_818622878.arc thread=1 sequence=187273
unable to find archive log
archive log thread=1 sequence=187274
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/25/2019 12:00:35
RMAN-06054: media recovery requesting unknown log: thread 1 seq 187274lowscn 11675068109

RMAN> alter database open resetlogs;

database opened

RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> exit

Recovery Manager complete.
[oracle@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 25 12:02:50 2019

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 318770144 bytes
Database Buffers 889192448 bytes
Redo Buffers 14753792 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

特别说明
因为归档只到187273,所以RMAN-06054: media recovery requesting unknown log: thread 1 seq 187274 lowscn 11675068109 报错正常。
可以使用如下方式：run {set until sequence 187273 thread 1; recover database;}

注册备份归档
catalog start with '/u01/app/backup/' ;
要不总是提示old file问题