课程第28次
删除表空间时可能会遇到的问题：drop flashback archive fda1;
select* from dba_flashback_archive;
select* from dba_flashback_archive_tables;
select* from dba_flashback_archive_ts;
select* from dba_tab_partitionswhere table_name in
(selecttable_namefrom dba_tab_partitions tp where tp.tablespace_name='USERS');
alter table hr.tpart movepartition tpart_b tablespace example;
select* from dba_part_indexes where table_name='TPART';
select* from dba_ind_partitionswhere index_name='IPART';
alter index hr.ipart rebuildpartitiontpart_b tablespace example;
$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/trace
$ grep-B 10'drop tablespace'alert_orcl.log
------------------------------Copyright (c) 1982, 2013, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1043886080 bytes
Fixed Size 2259840 bytes
Variable Size 654312576 bytes
Database Buffers 381681664 bytes
Redo Buffers 5632000 bytes
Database mounted.
Database opened.
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string rcat
SQL> create tablespace rcattbsdatafile '/u01/app/oracle/oradata/rcat/rcattbs.dbf' size 50M autoextend on ;
Tablespace created.
SQL> create user u79 identified by oracle_4Udefault tablespace rcattbs quota unlimited on rcattbs;
User created.
SQL> grant recovery_catalog_owner to u79;
Grant succeeded.
$ rman target / catalog u79/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 24 08:00:46 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (DBID=1545528092)
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 24 08:05:53 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (not mounted)
connected to recovery catalog database
RMAN> exit
Recovery Manager complete.
$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 24 08:06:03 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (not mounted)
RMAN> list backup of controlfile;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 10/24/2019 08:06:14
ORA-01507: database not mounted
RMAN> exit
Recovery Manager complete.
$ rman target / catalog u79/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Oct 24 08:07:21 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (not mounted)
connected to recovery catalog database
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
221 Incr 010.00M SBT_TAPE 00:00:16 2019-10-23:20:08:53
BP Key: 254 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 0duf2g65_1_1 Media: station79-000006
Control File Included: Ckp SCN: 4982367 Ckp time: 2019-10-23:20:08:37
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
233 Incr 110.00M SBT_TAPE 00:00:23 2019-10-24:06:39:46
BP Key: 266 Status: AVAILABLECompressed: NOTag: 2T-WHOLE-INCR1
Handle: 0ouf3l4r_1_1 Media: station79-000012
Control File Included: Ckp SCN: 5044301 Ckp time: 2019-10-24:06:39:22
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
236 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:06:47:59
BP Key: 269 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 0suf3lkf_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5050754 Ckp time: 2019-10-24:06:47:43
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
237 Full 10.00M SBT_TAPE 00:00:17 2019-10-24:06:55:33
BP Key: 270 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 0uuf3m2k_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5051673 Ckp time: 2019-10-24:06:55:16
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
238 Full 10.00M SBT_TAPE 00:00:29 2019-10-24:07:11:37
BP Key: 271 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 10uf3n0c_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5054203 Ckp time: 2019-10-24:07:11:08
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
239 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:07:14:36
BP Key: 272 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 13uf3n6c_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5054593 Ckp time: 2019-10-24:07:14:20
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
240 Full 10.00M SBT_TAPE 00:00:17 2019-10-24:07:16:56
BP Key: 273 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 15uf3nan_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5054899 Ckp time: 2019-10-24:07:16:40
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
241 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:07:22:08
BP Key: 274 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-BEFORE-DROP
Handle: 16uf3nkg_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5055387 Ckp time: 2019-10-24:07:21:52
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
242 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:07:24:29
BP Key: 275 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 17uf3not_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5056678 Ckp time: 2019-10-24:07:24:13
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
221 Incr 010.00M SBT_TAPE 00:00:16 2019-10-23:20:08:53
BP Key: 254 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 0duf2g65_1_1 Media: station79-000006
Control File Included: Ckp SCN: 4982367 Ckp time: 2019-10-23:20:08:37
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
233 Incr 110.00M SBT_TAPE 00:00:23 2019-10-24:06:39:46
BP Key: 266 Status: AVAILABLECompressed: NOTag: 2T-WHOLE-INCR1
Handle: 0ouf3l4r_1_1 Media: station79-000012
Control File Included: Ckp SCN: 5044301 Ckp time: 2019-10-24:06:39:22
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
236 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:06:47:59
BP Key: 269 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 0suf3lkf_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5050754 Ckp time: 2019-10-24:06:47:43
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
237 Full 10.00M SBT_TAPE 00:00:17 2019-10-24:06:55:33
BP Key: 270 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 0uuf3m2k_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5051673 Ckp time: 2019-10-24:06:55:16
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
238 Full 10.00M SBT_TAPE 00:00:29 2019-10-24:07:11:37
BP Key: 271 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 10uf3n0c_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5054203 Ckp time: 2019-10-24:07:11:08
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
239 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:07:14:36
BP Key: 272 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 13uf3n6c_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5054593 Ckp time: 2019-10-24:07:14:20
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
240 Full 10.00M SBT_TAPE 00:00:17 2019-10-24:07:16:56
BP Key: 273 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 15uf3nan_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5054899 Ckp time: 2019-10-24:07:16:40
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
241 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:07:22:08
BP Key: 274 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-BEFORE-DROP
Handle: 16uf3nkg_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5055387 Ckp time: 2019-10-24:07:21:52
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
242 Full 10.00M SBT_TAPE 00:00:16 2019-10-24:07:24:29
BP Key: 275 Status: AVAILABLECompressed: NOTag: LABS-14-CONTR-AFTER-DROP
Handle: 17uf3not_1_1 Media: station79-000006
Control File Included: Ckp SCN: 5056678 Ckp time: 2019-10-24:07:24:13
RMAN> restore controlfile from tag 'LABS-14-CONTR-BEFORE-DROP';
Starting restore at 2019-10-24:08:07:57
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=25 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=26 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=28 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=29 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=30 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=31 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=32 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=33 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=34 device type=DISK
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: restoring control file
channel ORA_SBT_TAPE_1: reading from backup piece 16uf3nkg_1_1
channel ORA_SBT_TAPE_1: piece handle=16uf3nkg_1_1 tag=LABS-14-CONTR-BEFORE-DROP
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
output file name=+DATA/orcl/controlfile/current.260.1022408353
output file name=+FRA/orcl/controlfile/current.256.1022408353
Finished restore at 2019-10-24:08:08:29
RMAN> alter database mount;
database mounted
released channel: ORA_SBT_TAPE_1
released channel: ORA_SBT_TAPE_2
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
released channel: ORA_DISK_6
released channel: ORA_DISK_7
released channel: ORA_DISK_8
RMAN> run {
2> sql "alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''";
3> set until time '2019-10-24:07:22:27';
4> restore database;
5> recover database;
6> }
sql statement: alter session set nls_date_format=''YYYY-MM-DD:HH24:MI:SS''
executing command: SET until clause
Starting restore at 2019-10-24:08:12:26
Starting implicit crosscheck backup at 2019-10-24:08:12:26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=33 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=32 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=31 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=30 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=29 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=28 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=27 device type=DISK
Finished implicit crosscheck backup at 2019-10-24:08:12:32
Starting implicit crosscheck copy at 2019-10-24:08:12:32
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
Finished implicit crosscheck copy at 2019-10-24:08:12:32
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_161.260.1022202615
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_162.261.1022209779
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_163.262.1022216953
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_164.263.1022223617
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_165.264.1022230823
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_166.265.1022239153
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_167.266.1022249049
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_168.267.1022252501
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_169.268.1022262307
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_170.269.1022272869
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_171.270.1022274667
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_172.271.1022280315
File Name: +fra/ORCL/ARCHIVELOG/2019_10_21/thread_1_seq_173.272.1022280361
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=25 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=37 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00001 to +DATA/orcl/datafile/system.256.1017747273
channel ORA_SBT_TAPE_1: reading from backup piece 07uf2g1a_1_1
channel ORA_SBT_TAPE_1: piece handle=07uf2g1a_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00002 to +DATA/orcl/datafile/sysaux.257.1017747273
channel ORA_SBT_TAPE_1: reading from backup piece 08uf2g2e_1_1
channel ORA_SBT_TAPE_1: piece handle=08uf2g2e_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.264.1022254567
channel ORA_SBT_TAPE_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.1017747369
channel ORA_SBT_TAPE_1: restoring datafile 00006 to +DATA/orcl/datafile/tbs1.267.1017789135
channel ORA_SBT_TAPE_1: restoring datafile 00007 to +DATA/orcl/datafile/tbs2.268.1022104451
channel ORA_SBT_TAPE_1: restoring datafile 00008 to /u01/app/oracle/oradata/orcl/tbs3_a.dbf
channel ORA_SBT_TAPE_1: restoring datafile 00009 to /u01/app/oracle/oradata/orcl/tbs3_b.dbf
channel ORA_SBT_TAPE_1: restoring datafile 00011 to +DATA/orcl/datafile/tbs5.270.1022108063
channel ORA_SBT_TAPE_1: restoring datafile 00014 to +DATA/orcl/datafile/tbs_nocompression.273.1022129913
channel ORA_SBT_TAPE_1: restoring datafile 00015 to +DATA/orcl/datafile/tbs_basic.274.1022129945
channel ORA_SBT_TAPE_1: restoring datafile 00016 to +DATA/orcl/datafile/tbs_oltp.275.1022129967
channel ORA_SBT_TAPE_1: reading from backup piece 09uf2g38_1_1
channel ORA_SBT_TAPE_1: piece handle=09uf2g38_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00017 to +DATA/orcl/datafile/tbs6.276.1022136411
channel ORA_SBT_TAPE_1: restoring datafile 00018 to +DATA/orcl/datafile/tbsaudit.277.1022182039
channel ORA_SBT_TAPE_1: restoring datafile 00019 to +HIGHDATA/orcl/datafile/tbshighdata1.256.1022396685
channel ORA_SBT_TAPE_1: restoring datafile 00020 to +HIGHDATA/orcl/datadir/tbshighdata2.dbf
channel ORA_SBT_TAPE_1: restoring datafile 00021 to +DATA/orcl/datafile/tbs7.258.1022401035
channel ORA_SBT_TAPE_1: restoring datafile 00022 to +DATA/orcl/datadir/tbs8.dbf
channel ORA_SBT_TAPE_1: reading from backup piece 0auf2g41_1_1
channel ORA_SBT_TAPE_1: piece handle=0auf2g41_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00010 to +DATA/orcl/datafile/tbs4.269.1022107971
channel ORA_SBT_TAPE_1: reading from backup piece 0buf2g4h_1_1
channel ORA_SBT_TAPE_1: piece handle=0buf2g4h_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00012 to +DATA/orcl/datafile/tbs4.271.1022108093
channel ORA_SBT_TAPE_1: reading from backup piece 0cuf2g5c_1_1
channel ORA_SBT_TAPE_1: piece handle=0cuf2g5c_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
channel ORA_SBT_TAPE_1: restoring datafile 00013 to +DATA/orcl/datafile/tbs16k.272.1022119203
channel ORA_SBT_TAPE_1: reading from backup piece 0euf2g6n_1_1
channel ORA_SBT_TAPE_1: piece handle=0euf2g6n_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
Finished restore at 2019-10-24:08:16:14
Starting recover at 2019-10-24:08:16:14
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: +DATA/orcl/datafile/system.256.1017747273
channel ORA_SBT_TAPE_1: reading from backup piece 0iuf3l0l_1_1
channel ORA_SBT_TAPE_2: starting incremental datafile backup set restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00017: +DATA/orcl/datafile/tbs6.276.1022136411
destination for restore of datafile 00018: +DATA/orcl/datafile/tbsaudit.277.1022182039
destination for restore of datafile 00019: +HIGHDATA/orcl/datafile/tbshighdata1.256.1022396685
destination for restore of datafile 00020: +HIGHDATA/orcl/datadir/tbshighdata2.dbf
destination for restore of datafile 00021: +DATA/orcl/datafile/tbs7.258.1022401035
destination for restore of datafile 00022: +DATA/orcl/datadir/tbs8.dbf
channel ORA_SBT_TAPE_2: reading from backup piece 0luf3l40_1_1
PSDRPC returns significant error 1013.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/24/2019 08:16:57
ORA-19870: error while restoring backup piece 0iuf3l0l_1_1
ORA-00600: internal error code, arguments: , , , , [], [], [], [], [], [], [], []
RMAN> crosscheck backup;
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=02uf2fv7_1_1 RECID=1 STAMP=1022443495
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=01uf2fv6_1_1 RECID=2 STAMP=1022443495
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=03uf2g0a_1_1 RECID=3 STAMP=1022443530
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=04uf2g0a_1_1 RECID=4 STAMP=1022443530
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=05uf2g0q_1_1 RECID=5 STAMP=1022443546
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=07uf2g1a_1_1 RECID=6 STAMP=1022443563
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=08uf2g2e_1_1 RECID=7 STAMP=1022443598
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=09uf2g38_1_1 RECID=8 STAMP=1022443626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0auf2g41_1_1 RECID=9 STAMP=1022443649
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0buf2g4h_1_1 RECID=10 STAMP=1022443668
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0cuf2g5c_1_1 RECID=11 STAMP=1022443692
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0duf2g65_1_1 RECID=12 STAMP=1022443718
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=06uf2g1a_1_1 RECID=13 STAMP=1022443562
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0euf2g6n_1_1 RECID=14 STAMP=1022443737
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0fuf2g77_1_1 RECID=15 STAMP=1022443751
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0guf2g81_1_1 RECID=16 STAMP=1022443777
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0iuf3l0l_1_1 RECID=17 STAMP=1022481429
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0juf3l1q_1_1 RECID=18 STAMP=1022481469
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0huf3l0l_1_1 RECID=19 STAMP=1022481429
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0kuf3l32_1_1 RECID=20 STAMP=1022481511
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0luf3l40_1_1 RECID=21 STAMP=1022481536
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0muf3l41_1_1 RECID=22 STAMP=1022481537
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0nuf3l4q_1_1 RECID=23 STAMP=1022481562
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0ouf3l4r_1_1 RECID=24 STAMP=1022481564
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0puf3l5l_1_1 RECID=25 STAMP=1022481590
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0quf3l5m_1_1 RECID=26 STAMP=1022481590
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0suf3lkf_1_1 RECID=28 STAMP=1022482064
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0uuf3m2k_1_1 RECID=30 STAMP=1022482517
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=10uf3n0c_1_1 RECID=32 STAMP=1022483470
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=13uf3n6c_1_1 RECID=35 STAMP=1022483661
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=15uf3nan_1_1 RECID=37 STAMP=1022483801
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=16uf3nkg_1_1 RECID=38 STAMP=1022484113
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=17uf3not_1_1 RECID=39 STAMP=1022484254
Crosschecked 33 objects
RMAN> list expired backupset;
specification does not match any backup in the repository
RMAN> list expired copy;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
RMAN>
页:
[1]