In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly introduces how to achieve different machine recovery of the same version of the database from oracle11.2.0.4 under linux to oracle under windows through rman, which has a certain reference value. Interested friends can refer to it. I hope you can learn a lot after reading this article.
The following is a recording of a recovery process.
[root@emrdg ~] # su-oracle
[oracle@emrdg ~] $sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 8 16:39:12 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options
SQL > select status from v$instance
STATUS
-
MOUNTED
-- =
The first step is to make a full backup of the database through rman under mount:
[oracle@emrdg ~] $rman target /
Recovery Manager: Release 11.2.0.4.0-Production on Tue Jan 8 16:32:39 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to target database: ZLEMR (DBID=88360475, not open)
RMAN > run {
2 > allocate channel C1 device type disk
3 > allocate channel c2 device type disk
4 > allocate channel c3 device type disk
5 > allocate channel c4 device type disk
6 > backup as compressed backupset database format'\ dbbak\ full_%U'
7 >}
Using target database control file instead of recovery catalog
Allocated channel: c1
Channel c1: SID=762 device type=DISK
Allocated channel: c2
Channel c2: SID=1519 device type=DISK
Allocated channel: c3
Channel c3: SID=2276 device type=DISK
Allocated channel: c4
Channel c4: SID=7 device type=DISK
Starting backup at 2019-01-08 16:32:49
Channel c1: starting compressed full datafile backup set
Channel C1: specifying datafile (s) in backup set
Input datafile file number=00009 name=+DATA/zlemrdg/zldocxml.dbf
Input datafile file number=00008 name=+DATA/zlemrdg/zldocdataindex.dbf
Input datafile file number=00005 name=+DATA/zlemrdg/zldocbase.dbf
Channel C1: starting piece 1 at 2019-01-08 16:32:49
Channel c2: starting compressed full datafile backup set
Channel c2: specifying datafile (s) in backup set
Input datafile file number=00011 name=+DATA/zlemrdg/zldocxml01.dbf
Input datafile file number=00012 name=+DATA/zlemrdg/zldocdataindex01.dbf
Input datafile file number=00006 name=+DATA/zlemrdg/zldocindex.dbf
Channel c2: starting piece 1 at 2019-01-08 16:32:50
Channel c3: starting compressed full datafile backup set
Channel c3: specifying datafile (s) in backup set
Input datafile file number=00002 name=+DATA/zlemrdg/sysaux01.dbf
Input datafile file number=00007 name=+DATA/zlemrdg/zldocdata.dbf
Input datafile file number=00004 name=+DATA/zlemrdg/users01.dbf
Channel c3: starting piece 1 at 2019-01-08 16:32:50
Channel c4: starting compressed full datafile backup set
Channel c4: specifying datafile (s) in backup set
Input datafile file number=00010 name=+DATA/zlemrdg/sysaux02.dbf
Input datafile file number=00001 name=+DATA/zlemrdg/system01.dbf
Input datafile file number=00003 name=+DATA/zlemrdg/undotbs01.dbf
Channel c4: starting piece 1 at 2019-01-08 16:32:50
Channel c4: finished piece 1 at 2019-01-08 16:35:25
Piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 tag=TAG20190108T163249 comment=NONE
Channel c4: backup set complete, elapsed time: 00:02:35
Channel c4: starting compressed full datafile backup set
Channel c4: specifying datafile (s) in backup set
Including current control file in backup set
Channel c4: starting piece 1 at 2019-01-08 16:35:28
Channel c4: finished piece 1 at 2019-01-08 16:35:29
Piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 tag=TAG20190108T163249 comment=NONE
Channel c4: backup set complete, elapsed time: 00:00:01
Channel c4: starting compressed full datafile backup set
Channel c4: specifying datafile (s) in backup set
Including current SPFILE in backup set
Channel c4: starting piece 1 at 2019-01-08 16:35:29
Channel c4: finished piece 1 at 2019-01-08 16:35:30
Piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 tag=TAG20190108T163249 comment=NONE
Channel c4: backup set complete, elapsed time: 00:00:01
Channel c3: finished piece 1 at 2019-01-08 16:37:04
Piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 tag=TAG20190108T163249 comment=NONE
Channel c3: backup set complete, elapsed time: 00:04:14
Channel c2: finished piece 1 at 2019-01-08 16:38:14
Piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 tag=TAG20190108T163249 comment=NONE
Channel c2: backup set complete, elapsed time: 00:05:24
Channel C1: finished piece 1 at 2019-01-08 16:55:44
Piece handle=/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 tag=TAG20190108T163249 comment=NONE
Channel c1: backup set complete, elapsed time: 00:22:55
Finished backup at 2019-01-08 16:55:44
Released channel: c1
Released channel: c2
Released channel: c3
Released channel: c4
RMAN >
RMAN >
RMAN >
RMAN >
RMAN >
RMAN >
RMAN > backup current controlfile format'/ dbbak/control_%U'
Starting backup at 2019-01-08 16:56:43
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID=762 device type=DISK
Channel ORA_DISK_1: starting compressed full datafile backup set
Channel ORA_DISK_1: specifying datafile (s) in backup set
Including current control file in backup set
Channel ORA_DISK_1: starting piece 1 at 2019-01-08 16:56:44
Channel ORA_DISK_1: finished piece 1 at 2019-01-08 16:56:45
Piece handle=/dbbak/control_7atmqumb_1_1 tag=TAG20190108T165643 comment=NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2019-01-08 16:56:45
RMAN >
SQL > col units format A10
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
4423032 8528960 Blocks 486 524
1184638 2435456 Blocks 660 625
1145749 0 Blocks 625
2914993 0 Blocks 398
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
4423032 8528960 Blocks 486 524
1203326 2435456 Blocks 654 639
1164437 0 Blocks 639
2914993 0 Blocks 398
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
4601336 8528960 Blocks 551 645
1228926 2435456 Blocks 643 655
1190037 0 Blocks 655
3093297 0 Blocks 519
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
4601336 8528960 Blocks 551 645
1252350 2435456 Blocks 634 671
1213461 0 Blocks 671
3093297 0 Blocks 519
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
4601336 8528960 Blocks 551 645
1260798 2435456 Blocks 631 677
1221909 0 Blocks 677
3093297 0 Blocks 519
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
4973816 8528960 Blocks 633 885
1714046 2435456 Blocks 407 967
1675120 0 Blocks 967
3465769 0 Blocks 759
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
5338872 8528960 Blocks 672 1125
2066046 2435456 Blocks 213 1190
2026076 0 Blocks 1190
3830226 0 Blocks 999
SQL > host
[oracle@emrdg ~] $pwd
/ home/oracle
[oracle@emrdg ~] $exit
Exit
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
5338872 8528960 Blocks 672 1125
2120190 2435456 Blocks 182 1223
2080220 0 Blocks 1223
3830226 0 Blocks 999
SQL > select group#,status,bytes v$log
Select group#,status,bytes v$log
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL > select group#,status,bytes from v$log
GROUP# STATUS BYTES
1 CURRENT 52428800
3 INACTIVE 52428800
2 INACTIVE 52428800
SQL > select member from v$logfile
MEMBER
+ DATA/zlemrdg/redo03.log
+ DATA/zlemrdg/redo02.log
+ DATA/zlemrdg/redo01.log
+ DATA/zlemrdg/std_redo04.log
+ DATA/zlemrdg/std_redo05.log
+ DATA/zlemrdg/std_redo06.log
+ DATA/zlemrdg/std_redo07.log
7 rows selected.
SQL > desc v$logfile
Name Null? Type
-
GROUP# NUMBER
STATUS VARCHAR2 (7)
TYPE VARCHAR2 (7)
MEMBER VARCHAR2 (513)
IS_RECOVERY_DEST_FILE VARCHAR2 (3)
SQL > col member format A40
SQL > SELECT TYPE,STATUS,MEMBER FROM V$LOGFILE
TYPE STATUS MEMBER
ONLINE + DATA/zlemrdg/redo03.log
ONLINE + DATA/zlemrdg/redo02.log
ONLINE + DATA/zlemrdg/redo01.log
STANDBY + DATA/zlemrdg/std_redo04.log
STANDBY + DATA/zlemrdg/std_redo05.log
STANDBY + DATA/zlemrdg/std_redo06.log
STANDBY + DATA/zlemrdg/std_redo07.log
7 rows selected.
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
SOFAR TOTALWORK UNITS TIME_REMAINING ELAPSED_SECONDS
--
5542264 8528960 Blocks 671 1245
2343806 2435456 Blocks 53 1363
2303228 0 Blocks 1363
4033140 0 Blocks 1119
SQL > Select sofar,totalwork,units,TIME_REMAINING, ELAPSED_SECONDS from v$session_longops where sofartotalwork
No rows selected
SQL > HOST
[oracle@emrdg ~] $ls
Dbbak oradiag_oracle orapwzlemr pfile pfile.ora temp
[oracle@emrdg ~] $cd / dbbak
[oracle@emrdg dbbak] $ls
Control_7atmqumb_1_1
[oracle@emrdg dbbak] $exit
Exit
SQL > alter database open
Database altered.
SQL >
-- = =
C:\ > rman target /
Recovery Manager: Release 11.2.0.4.0-Production on Tuesday January 8 17:04:12 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to target database: EMRTEST1 (not mounted)
RMAN > restore controlfile from
2 > 'dvvl _ stop _ dbbak _ control _ 7atmqumbprints _ 1percent
Launch restore on 08-January-19
Replace the recovery directory with the target database control file
Assigned channel: ORA_DISK_1
Channel ORA_DISK_1: SID=10 device type = DISK
Channel ORA_DISK_1: restoring control files
Channel ORA_DISK_1: restore completed. Time: 00:00:01
Output file name = D:\ ORADATA\ EMRTEST1\ CONTROL01.CTL
Output file name = C:\ APP\ ADMINISTRATOR\ FAST_RECOVERY_AREA\ EMRTEST1\ CONTROL02.CTL
Completion of restore in 08-January-19
RMAN >
RMAN > exit
The recovery Manager is complete.
C:\ > sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tuesday January 8 17:05:47 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL > show parameter control_files
NAME TYPE VALUE
-
Control_files string D:\ ORADATA\ EMRTEST1\ CONTROL01.
CTL, C:\ APP\ ADMINISTRATOR\ FAST
_ RECOVERY_AREA\ EMRTEST1\ CONTRO
L02.CTL
SQL > alter database mount
Alter database mount
*
An error occurred on line 1:
ORA-01103: the database name''ZLEMR'' is not' 'EMRTEST1'' in the control file
SQL > shutdown immediate
ORA-01507: no database mounted
The ORACLE routine has been closed.
SQL >
-- = =
C:\ > sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tuesday January 8 17:23:16 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle routine.
SQL > startup nomount
The ORACLE routine has been started.
Total System Global Area 4175568896 bytes
Fixed Size 2287832 bytes
Variable Size 1140852520 bytes
Database Buffers 3019898880 bytes
Redo Buffers 12529664 bytes
SQL > exit
From Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnect
C:\ > rman target /
Recovery Manager: Release 11.2.0.4.0-Production on Tuesday January 8 17:23:28 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to target database: ZLEMR (not mounted)
RMAN > restore controlfile from'd:\ dbbak\ control_7atmqumb_1_1'
Launch restore on 08-January-19
Replace the recovery directory with the target database control file
Assigned channel: ORA_DISK_1
Channel ORA_DISK_1: SID=772 device type = DISK
Channel ORA_DISK_1: restoring control files
Channel ORA_DISK_1: restore completed. Time: 00:00:01
Output file name = D:\ ORADATA\ ZLEMR\ CONTROL01.CTL
Output file name = C:\ APP\ ADMINISTRATOR\ FAST_RECOVERY_AREA\ ZLEMR\ CONTROL02.CTL
Completion of restore in 08-January-19
RMAN > alter database mount
The database is mounted
Released channel: ORA_DISK_1
RMAN >
RMAN > crosscheck backup
Launch implicit crosscheck backup on 08-January-19
Assigned channel: ORA_DISK_1
Channel ORA_DISK_1: SID=772 device type = DISK
62 cross-checked objects
Completion of implicit crosscheck backup in 08-January-19
Launch implicit crosscheck copy on 08-January-19
Use channel ORA_DISK_1
Completion of implicit crosscheck copy in 08-January-19
Search for all files in the recovery area
A catalogue of documents is being compiled.
No cataloging of files
Use channel ORA_DISK_1
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak RECID=13759 STAMP=996446405
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak RECID=13760 STAMP=996447567
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190101_5htm95mt_1_1.bak RECID=13761 STAMP=996447965
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak RECID=13765 STAMP=996532806
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak RECID=13766 STAMP=996533272
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak RECID=13768 STAMP=996532806
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak RECID=13769 STAMP=996533958
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190102_5otmbq2j_1_1.bak RECID=13770 STAMP=996534355
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak RECID=13771 STAMP=996534355
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora RECID=13772 STAMP=996534363
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak RECID=13773 STAMP=996534365
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak RECID=13774 STAMP=996619205
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak RECID=13775 STAMP=996619671
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak RECID=13776 STAMP=996619672
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak RECID=13777 STAMP=996619205
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak RECID=13778 STAMP=996620358
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190103_61tmeeej_1_1.bak RECID=13779 STAMP=996620755
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190103_60tmeeej_1_1.bak RECID=13780 STAMP=996620755
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora RECID=13781 STAMP=996620762
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak RECID=13782 STAMP=996620764
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_65tmh2a5_1_1.bak RECID=13783 STAMP=996705605
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_66tmh2om_1_1.bak RECID=13784 STAMP=996706071
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_67tmh2oo_1_1.bak RECID=13785 STAMP=996706072
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_1_1.bak RECID=13786 STAMP=996705605
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_2_1.bak RECID=13787 STAMP=996706768
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190104_68tmh3qu_1_1.bak RECID=13788 STAMP=996707166
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190104_69tmh3qu_1_1.bak RECID=13789 STAMP=996707166
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190104_6atmh3r5_1_1.ora RECID=13790 STAMP=996707173
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190104_6btmh3r6_1_1.bak RECID=13791 STAMP=996707175
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak RECID=13792 STAMP=996792006
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak RECID=13793 STAMP=996792472
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak RECID=13794 STAMP=996792473
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak RECID=13795 STAMP=996792005
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak RECID=13796 STAMP=996793168
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190105_6htmjn6s_1_1.bak RECID=13797 STAMP=996793564
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak RECID=13798 STAMP=996793564
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora RECID=13799 STAMP=996793572
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak RECID=13800 STAMP=996793574
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak RECID=13801 STAMP=996878406
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak RECID=13802 STAMP=996878872
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak RECID=13803 STAMP=996878873
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak RECID=13804 STAMP=996878405
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak RECID=13805 STAMP=996879568
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak RECID=13806 STAMP=996879976
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190106_6otmmbj8_1_1.bak RECID=13807 STAMP=996879976
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora RECID=13808 STAMP=996879983
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak RECID=13809 STAMP=996879985
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak RECID=13810 STAMP=996964806
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak RECID=13811 STAMP=996965272
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak RECID=13812 STAMP=996965273
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak RECID=13813 STAMP=996964806
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak RECID=13814 STAMP=996965959
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190107_71tmovuj_1_1.bak RECID=13815 STAMP=996966355
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/arch_20190107_70tmovuj_1_1.bak RECID=13816 STAMP=996966355
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora RECID=13817 STAMP=996966362
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak RECID=13818 STAMP=996966364
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 RECID=13819 STAMP=997029170
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 RECID=13820 STAMP=997029328
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 RECID=13821 STAMP=997029329
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 RECID=13822 STAMP=997029170
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 RECID=13823 STAMP=997029170
Cross-check backup fragments: found as' EXPIRED'
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 RECID=13824 STAMP=997029169
62 cross-checked objects
RMAN >
RMAN > delete expired backup
Use channel ORA_DISK_1
Backup fragment list
BP keyword BS keyword Pc# Cp# status device type segment name
13759 13466 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak
13760 13466 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak
13761 13467 1 1 EXPIRED DISK + ARCH/backup/arch_20190101_5htm95mt_1_1.bak
13765 13471 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak
13766 13472 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak
13768 13474 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak
13769 13474 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak
13770 13475 1 1 EXPIRED DISK + ARCH/backup/arch_20190102_5otmbq2j_1_1.bak
13771 13476 1 1 EXPIRED DISK + ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak
13772 13477 1 1 EXPIRED DISK + ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora
13773 13478 1 1 EXPIRED DISK + ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak
13774 13479 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak
13775 13480 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak
13776 13481 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak
13777 13482 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak
13778 13482 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak
13779 13483 1 1 EXPIRED DISK + ARCH/backup/arch_20190103_61tmeeej_1_1.bak
13780 13484 1 1 EXPIRED DISK + ARCH/backup/arch_20190103_60tmeeej_1_1.bak
13781 13485 1 1 EXPIRED DISK + ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora
13782 13486 1 1 EXPIRED DISK + ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak
13783 13487 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190104_65tmh2a5_1_1.bak
13784 13488 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190104_66tmh2om_1_1.bak
13785 13489 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190104_67tmh2oo_1_1.bak
13786 13490 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_1_1.bak
13787 13490 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_2_1.bak
13788 13491 1 1 EXPIRED DISK + ARCH/backup/arch_20190104_68tmh3qu_1_1.bak
13789 13492 1 1 EXPIRED DISK + ARCH/backup/arch_20190104_69tmh3qu_1_1.bak
13790 13493 1 1 EXPIRED DISK + ARCH/backup/spfile_wyhis_20190104_6atmh3r5_1_1.ora
13791 13494 1 1 EXPIRED DISK + ARCH/backup/ctrl_wyhis_20190104_6btmh3r6_1_1.bak
13792 13495 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak
13793 13496 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak
13794 13497 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak
13795 13498 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak
13796 13498 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak
13797 13499 1 1 EXPIRED DISK + ARCH/backup/arch_20190105_6htmjn6s_1_1.bak
13798 13500 1 1 EXPIRED DISK + ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak
13799 13501 1 1 EXPIRED DISK + ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora
13800 13502 1 1 EXPIRED DISK + ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak
13801 13503 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak
13802 13504 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak
13803 13505 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak
13804 13506 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak
13805 13506 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak
13806 13507 1 1 EXPIRED DISK + ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak
13807 13508 1 1 EXPIRED DISK + ARCH/backup/arch_20190106_6otmmbj8_1_1.bak
13808 13509 1 1 EXPIRED DISK + ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora
13809 13510 1 1 EXPIRED DISK + ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak
13810 13511 11 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak
13811 13512 11 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak
13812 13513 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak
13813 13514 1 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak
13814 13514 2 1 EXPIRED DISK + ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak
13815 13515 1 1 EXPIRED DISK + ARCH/backup/arch_20190107_71tmovuj_1_1.bak
13816 13516 1 1 EXPIRED DISK + ARCH/backup/arch_20190107_70tmovuj_1_1.bak
13817 13517 1 1 EXPIRED DISK + ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora
13818 13518 1 1 EXPIRED DISK + ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak
13819 13519 11 EXPIRED DISK / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1
13820 13520 11 EXPIRED DISK / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1
13821 13521 11 EXPIRED DISK / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1
13822 13522 11 EXPIRED DISK / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1
13823 13523 11 EXPIRED DISK / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1
13824 13524 11 EXPIRED DISK / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1
Are you sure you want to delete the above objects (enter YES or NO)? Yes
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_1_1.bak RECID=13759 STAMP=996446405
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190101_5ctm9465_2_1.bak RECID=13760 STAMP=996447567
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190101_5htm95mt_1_1.bak RECID=13761 STAMP=996447965
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5ltmboi6_1_1.bak RECID=13765 STAMP=996532806
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5mtmbp0n_1_1.bak RECID=13766 STAMP=996533272
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_1_1.bak RECID=13768 STAMP=996532806
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190102_5ktmboi6_2_1.bak RECID=13769 STAMP=996533958
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190102_5otmbq2j_1_1.bak RECID=13770 STAMP=996534355
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190102_5ptmbq2j_1_1.bak RECID=13771 STAMP=996534355
Backup clip deleted
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190102_5qtmbq2r_1_1.ora RECID=13772 STAMP=996534363
Backup clip deleted
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190102_5rtmbq2s_1_1.bak RECID=13773 STAMP=996534365
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5ttmecu5_1_1.bak RECID=13774 STAMP=996619205
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5utmedcm_1_1.bak RECID=13775 STAMP=996619671
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5vtmedco_1_1.bak RECID=13776 STAMP=996619672
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_1_1.bak RECID=13777 STAMP=996619205
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190103_5stmecu5_2_1.bak RECID=13778 STAMP=996620358
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190103_61tmeeej_1_1.bak RECID=13779 STAMP=996620755
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190103_60tmeeej_1_1.bak RECID=13780 STAMP=996620755
Backup clip deleted
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190103_62tmeeeq_1_1.ora RECID=13781 STAMP=996620762
Backup clip deleted
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190103_63tmeeer_1_1.bak RECID=13782 STAMP=996620764
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_65tmh2a5_1_1.bak RECID=13783 STAMP=996705605
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_66tmh2om_1_1.bak RECID=13784 STAMP=996706071
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_67tmh2oo_1_1.bak RECID=13785 STAMP=996706072
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_1_1.bak RECID=13786 STAMP=996705605
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190104_64tmh2a5_2_1.bak RECID=13787 STAMP=996706768
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190104_68tmh3qu_1_1.bak RECID=13788 STAMP=996707166
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190104_69tmh3qu_1_1.bak RECID=13789 STAMP=996707166
Backup clip deleted
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190104_6atmh3r5_1_1.ora RECID=13790 STAMP=996707173
Backup clip deleted
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190104_6btmh3r6_1_1.bak RECID=13791 STAMP=996707175
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6dtmjlm5_1_1.bak RECID=13792 STAMP=996792006
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6etmjm4n_1_1.bak RECID=13793 STAMP=996792472
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6ftmjm4p_1_1.bak RECID=13794 STAMP=996792473
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_1_1.bak RECID=13795 STAMP=996792005
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190105_6ctmjlm5_2_1.bak RECID=13796 STAMP=996793168
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190105_6htmjn6s_1_1.bak RECID=13797 STAMP=996793564
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190105_6gtmjn6s_1_1.bak RECID=13798 STAMP=996793564
Backup clip deleted
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190105_6itmjn74_1_1.ora RECID=13799 STAMP=996793572
Backup clip deleted
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190105_6jtmjn75_1_1.bak RECID=13800 STAMP=996793574
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ltmma25_1_1.bak RECID=13801 STAMP=996878406
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6mtmmagn_1_1.bak RECID=13802 STAMP=996878872
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ntmmagp_1_1.bak RECID=13803 STAMP=996878873
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_1_1.bak RECID=13804 STAMP=996878405
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190106_6ktmma25_2_1.bak RECID=13805 STAMP=996879568
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190106_6ptmmbj8_1_1.bak RECID=13806 STAMP=996879976
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190106_6otmmbj8_1_1.bak RECID=13807 STAMP=996879976
Backup clip deleted
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190106_6qtmmbjf_1_1.ora RECID=13808 STAMP=996879983
Backup clip deleted
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190106_6rtmmbjg_1_1.bak RECID=13809 STAMP=996879985
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6ttmoue6_1_1.bak RECID=13810 STAMP=996964806
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6utmousn_1_1.bak RECID=13811 STAMP=996965272
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6vtmousp_1_1.bak RECID=13812 STAMP=996965273
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_1_1.bak RECID=13813 STAMP=996964806
Backup clip deleted
Backup fragment handle = + ARCH/backup/zlemr_dbwhole_20190107_6stmoue6_2_1.bak RECID=13814 STAMP=996965959
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190107_71tmovuj_1_1.bak RECID=13815 STAMP=996966355
Backup clip deleted
Backup fragment handle = + ARCH/backup/arch_20190107_70tmovuj_1_1.bak RECID=13816 STAMP=996966355
Backup clip deleted
Backup fragment handle = + ARCH/backup/spfile_wyhis_20190107_72tmovuq_1_1.ora RECID=13817 STAMP=996966362
Backup clip deleted
Backup fragment handle = + ARCH/backup/ctrl_wyhis_20190107_73tmovur_1_1.bak RECID=13818 STAMP=996966364
Backup clip deleted
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_77tmqt9i_1_1 RECID=13819 STAMP=997029170
Backup clip deleted
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_78tmqted_1_1 RECID=13820 STAMP=997029328
Backup clip deleted
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_79tmqteh_1_1 RECID=13821 STAMP=997029329
Backup clip deleted
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_76tmqt9i_1_1 RECID=13822 STAMP=997029170
Backup clip deleted
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_75tmqt9h_1_1 RECID=13823 STAMP=997029170
Backup clip deleted
Backup fragment handle = / u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/dbbakfull_74tmqt9h_1_1 RECID=13824 STAMP=997029169
62 EXPIRED object deleted
RMAN >
RMAN > catalog start with'd:\ dbbak\'
Search for all files that match the style d:\ dbbak\
List of unknown files in the database
= =
File name: d:\ DBBAK\ control_7atmqumb_1_1
File name: d:\ DBBAK\ dbbakfull_74tmqt9h_1_1
File name: d:\ DBBAK\ dbbakfull_75tmqt9h_1_1
File name: d:\ DBBAK\ dbbakfull_76tmqt9i_1_1
File name: d:\ DBBAK\ dbbakfull_77tmqt9i_1_1
File name: d:\ DBBAK\ dbbakfull_78tmqted_1_1
File name: d:\ DBBAK\ dbbakfull_79tmqteh_1_1
Are you sure you want to list the above files in the directory (enter YES or NO)? Yes
A catalogue of documents is being compiled.
The catalogue has been compiled
A list of files that have been listed in the directory
=
File name: d:\ DBBAK\ control_7atmqumb_1_1
File name: d:\ DBBAK\ dbbakfull_74tmqt9h_1_1
File name: d:\ DBBAK\ dbbakfull_75tmqt9h_1_1
File name: d:\ DBBAK\ dbbakfull_76tmqt9i_1_1
File name: d:\ DBBAK\ dbbakfull_77tmqt9i_1_1
File name: d:\ DBBAK\ dbbakfull_78tmqted_1_1
File name: d:\ DBBAK\ dbbakfull_79tmqteh_1_1
RMAN >
RMAN > run {
2 > set newname for database to'D:\ oradata\ zlemr\% d'
3 > restore database
4 >}
Executing command: SET NEWNAME
RMAN-00571: =
RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: =
RMAN-03002: the set command (on 01Universe 08 RMAN-03002 at 17:41:49 on 2019) failed
RMAN-06970: the NEWNAME'd:\ oradata\ zlemr\% d' of the database must contain% f or% U format
RMAN > run {
2 > set newname for database to'D:\ oradata\ zlemr\% b'
3 > restore database
4 >}
Executing command: SET NEWNAME
Launch restore on 08-January-19
Use channel ORA_DISK_1
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00005 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocbase.dbf
Channel ORA_DISK_1: restore the data file 00008 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocdataindex.dbf
Channel ORA_DISK_1: restore the data file 00009 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocxml.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_74TMQT9H_1_1
Channel ORA_DISK_1: ORA-19870: error restoring backup fragment D:\ DBBAK\ DBBAKFULL_74TMQT9H_1_1
ORA-19504: unable to create the file "D:\ ORADATA\ ZLEMR\ + DATA\ ZLEMRDG\ ZLDOCXML.DBF"
ORA-27040: file creation error, unable to create file
OSD-04002:? ? ?
O/S-Error: (OS 3)? ? ? ?
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00001 to D:\ oradata\ zlemr\ + DATA/zlemrdg/system01.dbf
Channel ORA_DISK_1: restore the data file 00003 to D:\ oradata\ zlemr\ + DATA/zlemrdg/undotbs01.dbf
Channel ORA_DISK_1: restore the data file 00010 to D:\ oradata\ zlemr\ + DATA/zlemrdg/sysaux02.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_77TMQT9I_1_1
Channel ORA_DISK_1: ORA-19870: error restoring backup fragment D:\ DBBAK\ DBBAKFULL_77TMQT9I_1_1
ORA-19504: unable to create the file "D:\ ORADATA\ ZLEMR\ + DATA\ ZLEMRDG\ SYSAUX02.DBF"
ORA-27040: file creation error, unable to create file
OSD-04002:? ? ?
O/S-Error: (OS 3)? ? ? ?
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00002 to D:\ oradata\ zlemr\ + DATA/zlemrdg/sysaux01.dbf
Channel ORA_DISK_1: restore the data file 00004 to D:\ oradata\ zlemr\ + DATA/zlemrdg/users01.dbf
Channel ORA_DISK_1: restore the data file 00007 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocdata.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_76TMQT9I_1_1
Channel ORA_DISK_1: ORA-19870: error restoring backup fragment D:\ DBBAK\ DBBAKFULL_76TMQT9I_1_1
ORA-19504: unable to create the file "D:\ ORADATA\ ZLEMR\ + DATA\ ZLEMRDG\ SYSAUX01.DBF"
ORA-27040: file creation error, unable to create file
OSD-04002:? ? ?
O/S-Error: (OS 3)? ? ? ?
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00006 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocindex.dbf
Channel ORA_DISK_1: restore the data file 00011 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocxml01.dbf
Channel ORA_DISK_1: restore the data file 00012 to D:\ oradata\ zlemr\ + DATA/zlemrdg/zldocdataindex01.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_75TMQT9H_1_1
Channel ORA_DISK_1: ORA-19870: error restoring backup fragment D:\ DBBAK\ DBBAKFULL_75TMQT9H_1_1
ORA-19504: unable to create the file "D:\ ORADATA\ ZLEMR\ + DATA\ ZLEMRDG\ ZLDOCXML01.DBF"
ORA-27040: file creation error, unable to create file
OSD-04002:? ? ?
O/S-Error: (OS 3)? ? ? ?
Fail over to previous backup
RMAN-00571: =
RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: =
RMAN-03002: the restore command (on 01Universe 08 RMAN-03002 at 17:42:43 on 2019) failed
RMAN-06026: some targets have not been found-abort restore
RMAN-06023: no copy restore of data file 4 was found
RMAN-06023: no copy restore of data file 3 was found
RMAN-06023: no copy restore of data file 2 was found
RMAN-06023: no copy restore of data file 1 was found
RMAN >
RMAN > run {
2 > set newname for datafile'+ DATA/zlemrdg/zldocbase.dbf' to'D:\ oradata\ zlemr\ zldocbase.dbf'
3 > set newname for datafile'+ DATA/zlemrdg/zldocdataindex.dbf' to'D:\ oradata\ zlemr\ zldocdataindex.dbf'
4 > set newname for datafile'+ DATA/zlemrdg/zldocxml.dbf' to'D:\ oradata\ zlemr\ zldocxml.dbf'
5 > set newname for datafile'+ DATA/zlemrdg/system01.dbf' to'D:\ oradata\ zlemr\ system01.dbf'
6 > set newname for datafile'+ DATA/zlemrdg/undotbs01.dbf' to'D:\ oradata\ zlemr\ undotbs01.dbf'
7 > set newname for datafile'+ DATA/zlemrdg/sysaux02.dbf' to'D:\ oradata\ zlemr\ sysaux02.dbf'
8 > set newname for datafile'+ DATA/zlemrdg/zldocindex.dbf' to'D:\ oradata\ zlemr\ zldocindex.dbf'
9 > set newname for datafile'+ DATA/zlemrdg/zldocxml01.dbf' to'D:\ oradata\ zlemr\ zldocxml01.dbf'
10 > set newname for datafile'+ DATA/zlemrdg/zldocdataindex01.dbf' to'D:\ oradata\ zlemr\ zldocdataindex01.dbf'
11 > set newname for datafile'+ DATA/zlemrdg/sysaux01.dbf' to'D:\ oradata\ zlemr\ sysaux01.dbf'
12 > set newname for datafile'+ DATA/zlemrdg/zldocdata.dbf' to'D:\ oradata\ zlemr\ zldocdata.dbf'
13 > set newname for datafile'+ DATA/zlemrdg/users01.dbf' to'D:\ oradata\ zlemr\ users01.dbf'
14 >
15 > restore database
16 >}
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Executing command: SET NEWNAME
Launch restore on 08-January-19
Use channel ORA_DISK_1
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00005 to D:\ oradata\ zlemr\ zldocbase.dbf
Channel ORA_DISK_1: restore the data file 00008 to D:\ oradata\ zlemr\ zldocdataindex.dbf
Channel ORA_DISK_1: restore the data file 00009 to D:\ oradata\ zlemr\ zldocxml.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_74TMQT9H_1_1
Channel ORA_DISK_1: segment handle = D:\ DBBAK\ DBBAKFULL_74TMQT9H_1_1 tag = TAG20190108T163249
Channel ORA_DISK_1: backup fragment 1 restored
Channel ORA_DISK_1: restore completed. Time: 00:24:18
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00001 to D:\ oradata\ zlemr\ system01.dbf
Channel ORA_DISK_1: restore the data file 00003 to D:\ oradata\ zlemr\ undotbs01.dbf
Channel ORA_DISK_1: restore the data file 00010 to D:\ oradata\ zlemr\ sysaux02.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_77TMQT9I_1_1
Channel ORA_DISK_1: segment handle = D:\ DBBAK\ DBBAKFULL_77TMQT9I_1_1 tag = TAG20190108T163249
Channel ORA_DISK_1: backup fragment 1 restored
Channel ORA_DISK_1: restore completed. Time: 00:04:35
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00002 to D:\ oradata\ zlemr\ sysaux01.dbf
Channel ORA_DISK_1: restore the data file 00004 to D:\ oradata\ zlemr\ users01.dbf
Channel ORA_DISK_1: restore the data file 00007 to D:\ oradata\ zlemr\ zldocdata.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_76TMQT9I_1_1
Channel ORA_DISK_1: segment handle = D:\ DBBAK\ DBBAKFULL_76TMQT9I_1_1 tag = TAG20190108T163249
Channel ORA_DISK_1: backup fragment 1 restored
Channel ORA_DISK_1: restore completed. Time: 00:07:46
Channel ORA_DISK_1: starting to restore data file backup set
Channel ORA_DISK_1: specifying data files to restore from the backup set
Channel ORA_DISK_1: restore the data file 00006 to D:\ oradata\ zlemr\ zldocindex.dbf
Channel ORA_DISK_1: restore the data file 00011 to D:\ oradata\ zlemr\ zldocxml01.dbf
Channel ORA_DISK_1: restore the data file 00012 to D:\ oradata\ zlemr\ zldocdataindex01.dbf
Channel ORA_DISK_1: reading backup fragment D:\ DBBAK\ DBBAKFULL_75TMQT9H_1_1
Channel ORA_DISK_1: segment handle = D:\ DBBAK\ DBBAKFULL_75TMQT9H_1_1 tag = TAG20190108T163249
Channel ORA_DISK_1: backup fragment 1 restored
Channel ORA_DISK_1: restore completed. Time: 00:09:06
Completion of restore in 08-January-19
RMAN >
RMAN >
RMAN > switch database to copy
Data file 1 has been switched to a copy of the data file "D:\ ORADATA\ ZLEMR\ SYSTEM01.DBF"
Data file 2 has been switched to a copy of the data file "D:\ ORADATA\ ZLEMR\ SYSAUX01.DBF"
Data file 3 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ UNDOTBS01.DBF"
Data file 4 has been switched to a copy of the data file "D:\ ORADATA\ ZLEMR\ USERS01.DBF"
Data file 5 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ ZLDOCBASE.DBF"
Data file 6 has been switched to a copy of the data file "D:\ ORADATA\ ZLEMR\ ZLDOCINDEX.DBF"
Data file 7 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ ZLDOCDATA.DBF"
Data file 8 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ ZLDOCDATAINDEX.DBF"
Data file 9 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ ZLDOCXML.DBF"
Data file 10 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ SYSAUX02.DBF"
Data file 11 has been switched to a data file copy "D:\ ORADATA\ ZLEMR\ ZLDOCXML01.DBF"
Data file 12 has been switched to a copy of the data file "D:\ ORADATA\ ZLEMR\ ZLDOCDATAINDEX01.DBF"
RMAN >
SQL > select member from v$logfile
MEMBER
-
+ DATA/zlemrdg/redo03.log
+ DATA/zlemrdg/redo02.log
+ DATA/zlemrdg/redo01.log
+ DATA/zlemrdg/std_redo04.log
+ DATA/zlemrdg/std_redo05.log
+ DATA/zlemrdg/std_redo06.log
+ DATA/zlemrdg/std_redo07.log
Seven rows have been selected.
SQL > alter database rename file'+ DATA/zlemrdg/redo03.log' to'D:\ oradata\ zlemr\ redo03.log'
The database has changed.
SQL > alter database rename file'+ DATA/zlemrdg/redo02.log' to'D:\ oradata\ zlemr\ redo03.log'
Alter database rename file'+ DATA/zlemrdg/redo02.log' to'D:\ oradata\ zlemr\ redo03.log'
*
An error occurred on line 1:
ORA-01511: error renaming log / data file
ORA-01523: unable to rename the data file to'D:\ oradata\ zlemr\ redo03.log'-the file is already part of the database
SQL > alter database rename file'+ DATA/zlemrdg/redo02.log' to'D:\ oradata\ zlemr\ redo02.log'
The database has changed.
SQL > alter database rename file'+ DATA/zlemrdg/redo01.log' to'D:\ oradata\ zlemr\ redo01.log'
The database has changed.
SQL > alter database drop standby logfile'+ DATA/zlemrdg/std_redo04.log'
The database has changed.
SQL > alter database drop standby logfile'+ DATA/zlemrdg/std_redo05.log'
The database has changed.
SQL > alter database drop standby logfile'+ DATA/zlemrdg/std_redo06.log'
The database has changed.
SQL > alter database drop standby logfile'+ DATA/zlemrdg/std_redo07.log'
The database has changed.
SQL > select member from v$logfile
MEMBER
-
D:\ ORADATA\ ZLEMR\ REDO03.LOG
D:\ ORADATA\ ZLEMR\ REDO02.LOG
D:\ ORADATA\ ZLEMR\ REDO01.LOG
SQL > alter database open resetlogs
The database has changed.
SQL > select file_name from dba_temp_files
Select file_name from dba_temp_files
*
An error occurred on line 1:
ORA-01157: unable to identify / lock data file 201-see DBWR trace file
ORA-01110: data file 201:'+ DATA/zlemrdg/temp01.dbf'
SQL > create temporary tablespace temp1 tempfile'd:\ oradata\ zlemr\ temp02.dbf' size 1g autoextend on next 100m
The tablespace has been created.
SQL > alter database default temporary tablespace temp1
The database has changed.
SQL > drop tablespace temp
The tablespace was deleted.
SQL > select file_name from dba_temp_files
FILE_NAME
-
D:\ ORADATA\ ZLEMR\ TEMP02.DBF
SQL >
Thank you for reading this article carefully. I hope the article "how to realize the different machine recovery of the same version of database from oracle11.2.0.4 under linux to oracle under windows through rman" shared by the editor is helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.
12
Report
