|
删除表空间时可能会遇到的问题:
- 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_partitions where table_name in
- (select table_name from dba_tab_partitions tp where tp.tablespace_name='USERS');
复制代码
- alter table hr.tpart move partition tpart_b tablespace example;
复制代码- select * from dba_part_indexes where table_name='TPART';
- select * from dba_ind_partitions where index_name='IPART';
- alter index hr.ipart rebuild partition tpart_b tablespace example;
复制代码- [oracle@station79 trace]$ pwd
- /u01/app/oracle/diag/rdbms/orcl/orcl/trace
- [oracle@station79 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 rcattbs datafile '/u01/app/oracle/oradata/rcat/rcattbs.dbf' size 50M autoextend on ;
- Tablespace created.
- SQL> create user u79 identified by oracle_4U default tablespace rcattbs quota unlimited on rcattbs;
- User created.
- SQL> grant recovery_catalog_owner to u79;
- Grant succeeded.
复制代码- [oracle@station79 ~]$ 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.
- [oracle@station79 ~]$ 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.
- [oracle@station79 ~]$ 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 Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 221 Incr 0 10.00M SBT_TAPE 00:00:16 2019-10-23:20:08:53
- BP Key: 254 Status: AVAILABLE Compressed: NO Tag: 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 Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 233 Incr 1 10.00M SBT_TAPE 00:00:23 2019-10-24:06:39:46
- BP Key: 266 Status: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 221 Incr 0 10.00M SBT_TAPE 00:00:16 2019-10-23:20:08:53
- BP Key: 254 Status: AVAILABLE Compressed: NO Tag: 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 Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 233 Incr 1 10.00M SBT_TAPE 00:00:23 2019-10-24:06:39:46
- BP Key: 266 Status: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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 Key Type 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: AVAILABLE Compressed: NO Tag: 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: [krbrpr_no_buffer], [0iuf3l0l_1_1], [2], [0], [], [], [], [], [], [], [], []
- 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>
复制代码
|
|