当前位置： 首页 > article >正文

Oracle 数据文件被删除后使用rman备份恢复过程

article 2025/9/13 6:54:01

有个环境，因空间使用率100%，现场直接误删了数据文件，log记录恢复过程下

SQL >  select file#,name,checkpoint_change# from v$datafile;

     FILE# NAME                                                        CHECKPOINT_CHANGE#
---------- --------------------------------------------------------- ------------------
     1 /data/ORCL/datafile/o1_mf_system_g55prcdk_.dbf                   2369605234
     2 /data/ORCL/datafile/o1_mf_sysaux_g55prclq_.dbf                   2369605234
     3 /data/ORCL/datafile/o1_mf_undotbs1_g55prclz_.dbf                   2369605234
     7 /data/ORCL/datafile/TS_EXEC_D.dbf                                  2369605234
     8 /data/ORCL/datafile/TS_ESOP_D.dbf                               2369605234


SQL >  select file#,name,checkpoint_change# from v$datafile_header;

     FILE# NAME                                                            CHECKPOINT_CHANGE#
---------- ------------------------------------------------------------ ------------------
     1 /data/ORCL/datafile/o1_mf_system_g55prcdk_.dbf                       2369605234
     2 /data/ORCL/datafile/o1_mf_sysaux_g55prclq_.dbf                       2369605234
     3 /data/ORCL/datafile/o1_mf_undotbs1_g55prclz_.dbf                          2369605234
     7                                                                        0
     8                                                                        0

RMAN> sql'alter database datafile 7,8 offline';

sql statement: alter database datafile 7,8 offline

RMAN> restore datafile 7,8;

Starting restore at 2025/05/22 13:43:16
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00007 to /data/ORCL/datafile/TS_EXEC_D.dbf
channel ORA_DISK_1: restoring datafile 00008 to /data/ORCL/datafile/TS_ESOP_D.dbf
channel ORA_DISK_1: reading from backup piece /backup/orcl/ORCL_20250517_9742_1
channel ORA_DISK_1: piece handle=/backup/orcl/ORCL_20250517_9742_1 tag=DB_FULL_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:25
Finished restore at 2025/05/22 13:47:41

RMAN> recover datafile 7,8 ;

Starting recover at 2025/05/22 13:47:53
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 33462 is already on disk as file /fra/orcl/1_33462_999026804.dbf
archived log for thread 1 with sequence 33463 is already on disk as file /fra/orcl/1_33463_999026804.dbf
archived log for thread 1 with sequence 33464 is already on disk as file /fra/orcl/1_33464_999026804.dbf
archived log for thread 1 with sequence 33465 is already on disk as file /fra/orcl/1_33465_999026804.dbf
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33315
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33316
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33317
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250517_9752_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250517_9752_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
archived log file name=/fra/orcl/1_33315_999026804.dbf thread=1 sequence=33315
archived log file name=/fra/orcl/1_33316_999026804.dbf thread=1 sequence=33316
archived log file name=/fra/orcl/1_33317_999026804.dbf thread=1 sequence=33317
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33318
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33319
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33320
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33321
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33322
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33323
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33324
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33325
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33326
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250517_9753_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250517_9753_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
archived log file name=/fra/orcl/1_33318_999026804.dbf thread=1 sequence=33318
archived log file name=/fra/orcl/1_33319_999026804.dbf thread=1 sequence=33319
archived log file name=/fra/orcl/1_33320_999026804.dbf thread=1 sequence=33320
archived log file name=/fra/orcl/1_33321_999026804.dbf thread=1 sequence=33321
archived log file name=/fra/orcl/1_33322_999026804.dbf thread=1 sequence=33322
archived log file name=/fra/orcl/1_33323_999026804.dbf thread=1 sequence=33323
archived log file name=/fra/orcl/1_33324_999026804.dbf thread=1 sequence=33324
archived log file name=/fra/orcl/1_33325_999026804.dbf thread=1 sequence=33325
archived log file name=/fra/orcl/1_33326_999026804.dbf thread=1 sequence=33326
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33327
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33328
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33329
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33330
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33331
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33332
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33333
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33334
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250518_9757_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250518_9757_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
archived log file name=/fra/orcl/1_33327_999026804.dbf thread=1 sequence=33327
archived log file name=/fra/orcl/1_33328_999026804.dbf thread=1 sequence=33328
archived log file name=/fra/orcl/1_33329_999026804.dbf thread=1 sequence=33329
archived log file name=/fra/orcl/1_33330_999026804.dbf thread=1 sequence=33330
archived log file name=/fra/orcl/1_33331_999026804.dbf thread=1 sequence=33331
archived log file name=/fra/orcl/1_33332_999026804.dbf thread=1 sequence=33332
archived log file name=/fra/orcl/1_33333_999026804.dbf thread=1 sequence=33333
archived log file name=/fra/orcl/1_33334_999026804.dbf thread=1 sequence=33334
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33335
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33336
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33337
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33338
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33339
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33340
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33341
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33342
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33343
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250518_9758_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250518_9758_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
archived log file name=/fra/orcl/1_33335_999026804.dbf thread=1 sequence=33335
archived log file name=/fra/orcl/1_33336_999026804.dbf thread=1 sequence=33336
archived log file name=/fra/orcl/1_33337_999026804.dbf thread=1 sequence=33337
archived log file name=/fra/orcl/1_33338_999026804.dbf thread=1 sequence=33338
archived log file name=/fra/orcl/1_33339_999026804.dbf thread=1 sequence=33339
archived log file name=/fra/orcl/1_33340_999026804.dbf thread=1 sequence=33340
archived log file name=/fra/orcl/1_33341_999026804.dbf thread=1 sequence=33341
archived log file name=/fra/orcl/1_33342_999026804.dbf thread=1 sequence=33342
archived log file name=/fra/orcl/1_33343_999026804.dbf thread=1 sequence=33343
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33344
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33345
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33346
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33347
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33348
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33349
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33350
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33351
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250518_9759_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250518_9759_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
archived log file name=/fra/orcl/1_33344_999026804.dbf thread=1 sequence=33344
archived log file name=/fra/orcl/1_33345_999026804.dbf thread=1 sequence=33345
archived log file name=/fra/orcl/1_33346_999026804.dbf thread=1 sequence=33346
archived log file name=/fra/orcl/1_33347_999026804.dbf thread=1 sequence=33347
archived log file name=/fra/orcl/1_33348_999026804.dbf thread=1 sequence=33348
archived log file name=/fra/orcl/1_33349_999026804.dbf thread=1 sequence=33349
archived log file name=/fra/orcl/1_33350_999026804.dbf thread=1 sequence=33350
archived log file name=/fra/orcl/1_33351_999026804.dbf thread=1 sequence=33351
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33352
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33353
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33354
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33355
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33356
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33357
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33358
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33359
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33360
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33361
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250519_9763_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250519_9763_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
archived log file name=/fra/orcl/1_33352_999026804.dbf thread=1 sequence=33352
archived log file name=/fra/orcl/1_33353_999026804.dbf thread=1 sequence=33353
archived log file name=/fra/orcl/1_33354_999026804.dbf thread=1 sequence=33354
archived log file name=/fra/orcl/1_33355_999026804.dbf thread=1 sequence=33355
archived log file name=/fra/orcl/1_33356_999026804.dbf thread=1 sequence=33356
archived log file name=/fra/orcl/1_33357_999026804.dbf thread=1 sequence=33357
archived log file name=/fra/orcl/1_33358_999026804.dbf thread=1 sequence=33358
archived log file name=/fra/orcl/1_33359_999026804.dbf thread=1 sequence=33359
archived log file name=/fra/orcl/1_33360_999026804.dbf thread=1 sequence=33360
archived log file name=/fra/orcl/1_33361_999026804.dbf thread=1 sequence=33361
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33362
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33363
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33364
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33365
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33366
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33367
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33368
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33369
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33370
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33371
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250519_9764_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250519_9764_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:45
archived log file name=/fra/orcl/1_33362_999026804.dbf thread=1 sequence=33362
archived log file name=/fra/orcl/1_33363_999026804.dbf thread=1 sequence=33363
archived log file name=/fra/orcl/1_33364_999026804.dbf thread=1 sequence=33364
archived log file name=/fra/orcl/1_33365_999026804.dbf thread=1 sequence=33365
archived log file name=/fra/orcl/1_33366_999026804.dbf thread=1 sequence=33366
archived log file name=/fra/orcl/1_33367_999026804.dbf thread=1 sequence=33367
archived log file name=/fra/orcl/1_33368_999026804.dbf thread=1 sequence=33368
archived log file name=/fra/orcl/1_33369_999026804.dbf thread=1 sequence=33369
archived log file name=/fra/orcl/1_33370_999026804.dbf thread=1 sequence=33370
archived log file name=/fra/orcl/1_33371_999026804.dbf thread=1 sequence=33371
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33372
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33373
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33374
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33375
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33376
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33377
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33378
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33379
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33380
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250519_9765_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250519_9765_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
archived log file name=/fra/orcl/1_33372_999026804.dbf thread=1 sequence=33372
archived log file name=/fra/orcl/1_33373_999026804.dbf thread=1 sequence=33373
archived log file name=/fra/orcl/1_33374_999026804.dbf thread=1 sequence=33374
archived log file name=/fra/orcl/1_33375_999026804.dbf thread=1 sequence=33375
archived log file name=/fra/orcl/1_33376_999026804.dbf thread=1 sequence=33376
archived log file name=/fra/orcl/1_33377_999026804.dbf thread=1 sequence=33377
archived log file name=/fra/orcl/1_33378_999026804.dbf thread=1 sequence=33378
archived log file name=/fra/orcl/1_33379_999026804.dbf thread=1 sequence=33379
archived log file name=/fra/orcl/1_33380_999026804.dbf thread=1 sequence=33380
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33381
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33382
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33383
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33384
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33385
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33386
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33387
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33388
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33389
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250520_9769_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250520_9769_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
archived log file name=/fra/orcl/1_33381_999026804.dbf thread=1 sequence=33381
archived log file name=/fra/orcl/1_33382_999026804.dbf thread=1 sequence=33382
archived log file name=/fra/orcl/1_33383_999026804.dbf thread=1 sequence=33383
archived log file name=/fra/orcl/1_33384_999026804.dbf thread=1 sequence=33384
archived log file name=/fra/orcl/1_33385_999026804.dbf thread=1 sequence=33385
archived log file name=/fra/orcl/1_33386_999026804.dbf thread=1 sequence=33386
archived log file name=/fra/orcl/1_33387_999026804.dbf thread=1 sequence=33387
archived log file name=/fra/orcl/1_33388_999026804.dbf thread=1 sequence=33388
archived log file name=/fra/orcl/1_33389_999026804.dbf thread=1 sequence=33389
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33390
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33391
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33392
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33393
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33394
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33395
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33396
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33397
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33398
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250520_9770_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250520_9770_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:35
archived log file name=/fra/orcl/1_33390_999026804.dbf thread=1 sequence=33390
archived log file name=/fra/orcl/1_33391_999026804.dbf thread=1 sequence=33391
archived log file name=/fra/orcl/1_33392_999026804.dbf thread=1 sequence=33392
archived log file name=/fra/orcl/1_33393_999026804.dbf thread=1 sequence=33393
archived log file name=/fra/orcl/1_33394_999026804.dbf thread=1 sequence=33394
archived log file name=/fra/orcl/1_33395_999026804.dbf thread=1 sequence=33395
archived log file name=/fra/orcl/1_33396_999026804.dbf thread=1 sequence=33396
archived log file name=/fra/orcl/1_33397_999026804.dbf thread=1 sequence=33397
archived log file name=/fra/orcl/1_33398_999026804.dbf thread=1 sequence=33398
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33399
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33400
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33401
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33402
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33403
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33404
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33405
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33406
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33407
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33408
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250520_9771_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250520_9771_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
archived log file name=/fra/orcl/1_33399_999026804.dbf thread=1 sequence=33399
archived log file name=/fra/orcl/1_33400_999026804.dbf thread=1 sequence=33400
archived log file name=/fra/orcl/1_33401_999026804.dbf thread=1 sequence=33401
archived log file name=/fra/orcl/1_33402_999026804.dbf thread=1 sequence=33402
archived log file name=/fra/orcl/1_33403_999026804.dbf thread=1 sequence=33403
archived log file name=/fra/orcl/1_33404_999026804.dbf thread=1 sequence=33404
archived log file name=/fra/orcl/1_33405_999026804.dbf thread=1 sequence=33405
archived log file name=/fra/orcl/1_33406_999026804.dbf thread=1 sequence=33406
archived log file name=/fra/orcl/1_33407_999026804.dbf thread=1 sequence=33407
archived log file name=/fra/orcl/1_33408_999026804.dbf thread=1 sequence=33408
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33409
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250520_9772_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250520_9772_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/fra/orcl/1_33409_999026804.dbf thread=1 sequence=33409
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33410
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33411
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33412
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33413
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33414
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33415
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33416
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33417
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33418
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250521_9776_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250521_9776_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
archived log file name=/fra/orcl/1_33410_999026804.dbf thread=1 sequence=33410
archived log file name=/fra/orcl/1_33411_999026804.dbf thread=1 sequence=33411
archived log file name=/fra/orcl/1_33412_999026804.dbf thread=1 sequence=33412
archived log file name=/fra/orcl/1_33413_999026804.dbf thread=1 sequence=33413
archived log file name=/fra/orcl/1_33414_999026804.dbf thread=1 sequence=33414
archived log file name=/fra/orcl/1_33415_999026804.dbf thread=1 sequence=33415
archived log file name=/fra/orcl/1_33416_999026804.dbf thread=1 sequence=33416
archived log file name=/fra/orcl/1_33417_999026804.dbf thread=1 sequence=33417
archived log file name=/fra/orcl/1_33418_999026804.dbf thread=1 sequence=33418
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33419
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33420
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33421
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33422
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33423
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33424
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33425
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33426
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33427
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33428
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250521_9777_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250521_9777_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
archived log file name=/fra/orcl/1_33419_999026804.dbf thread=1 sequence=33419
archived log file name=/fra/orcl/1_33420_999026804.dbf thread=1 sequence=33420
archived log file name=/fra/orcl/1_33421_999026804.dbf thread=1 sequence=33421
archived log file name=/fra/orcl/1_33422_999026804.dbf thread=1 sequence=33422
archived log file name=/fra/orcl/1_33423_999026804.dbf thread=1 sequence=33423
archived log file name=/fra/orcl/1_33424_999026804.dbf thread=1 sequence=33424
archived log file name=/fra/orcl/1_33425_999026804.dbf thread=1 sequence=33425
archived log file name=/fra/orcl/1_33426_999026804.dbf thread=1 sequence=33426
archived log file name=/fra/orcl/1_33427_999026804.dbf thread=1 sequence=33427
archived log file name=/fra/orcl/1_33428_999026804.dbf thread=1 sequence=33428
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33429
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33430
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33431
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33432
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33433
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33434
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33435
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33436
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33437
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250521_9778_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250521_9778_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
archived log file name=/fra/orcl/1_33429_999026804.dbf thread=1 sequence=33429
archived log file name=/fra/orcl/1_33430_999026804.dbf thread=1 sequence=33430
archived log file name=/fra/orcl/1_33431_999026804.dbf thread=1 sequence=33431
archived log file name=/fra/orcl/1_33432_999026804.dbf thread=1 sequence=33432
archived log file name=/fra/orcl/1_33433_999026804.dbf thread=1 sequence=33433
archived log file name=/fra/orcl/1_33434_999026804.dbf thread=1 sequence=33434
archived log file name=/fra/orcl/1_33435_999026804.dbf thread=1 sequence=33435
archived log file name=/fra/orcl/1_33436_999026804.dbf thread=1 sequence=33436
archived log file name=/fra/orcl/1_33437_999026804.dbf thread=1 sequence=33437
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33438
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33439
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33440
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33441
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33442
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33443
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33444
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33445
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250522_9782_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250522_9782_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
archived log file name=/fra/orcl/1_33438_999026804.dbf thread=1 sequence=33438
archived log file name=/fra/orcl/1_33439_999026804.dbf thread=1 sequence=33439
archived log file name=/fra/orcl/1_33440_999026804.dbf thread=1 sequence=33440
archived log file name=/fra/orcl/1_33441_999026804.dbf thread=1 sequence=33441
archived log file name=/fra/orcl/1_33442_999026804.dbf thread=1 sequence=33442
archived log file name=/fra/orcl/1_33443_999026804.dbf thread=1 sequence=33443
archived log file name=/fra/orcl/1_33444_999026804.dbf thread=1 sequence=33444
archived log file name=/fra/orcl/1_33445_999026804.dbf thread=1 sequence=33445
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33446
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33447
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33448
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33449
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33450
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33451
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33452
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33453
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250522_9783_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250522_9783_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
archived log file name=/fra/orcl/1_33446_999026804.dbf thread=1 sequence=33446
archived log file name=/fra/orcl/1_33447_999026804.dbf thread=1 sequence=33447
archived log file name=/fra/orcl/1_33448_999026804.dbf thread=1 sequence=33448
archived log file name=/fra/orcl/1_33449_999026804.dbf thread=1 sequence=33449
archived log file name=/fra/orcl/1_33450_999026804.dbf thread=1 sequence=33450
archived log file name=/fra/orcl/1_33451_999026804.dbf thread=1 sequence=33451
archived log file name=/fra/orcl/1_33452_999026804.dbf thread=1 sequence=33452
archived log file name=/fra/orcl/1_33453_999026804.dbf thread=1 sequence=33453
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33454
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33455
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33456
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33457
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33458
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33459
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33460
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=33461
channel ORA_DISK_1: reading from backup piece /backup/orcl/ARCH_ORCL_20250522_9784_1
channel ORA_DISK_1: piece handle=/backup/orcl/ARCH_ORCL_20250522_9784_1 tag=ARCH_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
archived log file name=/fra/orcl/1_33454_999026804.dbf thread=1 sequence=33454
archived log file name=/fra/orcl/1_33455_999026804.dbf thread=1 sequence=33455
archived log file name=/fra/orcl/1_33456_999026804.dbf thread=1 sequence=33456
archived log file name=/fra/orcl/1_33457_999026804.dbf thread=1 sequence=33457
archived log file name=/fra/orcl/1_33458_999026804.dbf thread=1 sequence=33458
archived log file name=/fra/orcl/1_33459_999026804.dbf thread=1 sequence=33459
archived log file name=/fra/orcl/1_33460_999026804.dbf thread=1 sequence=33460
archived log file name=/fra/orcl/1_33461_999026804.dbf thread=1 sequence=33461
archived log file name=/fra/orcl/1_33462_999026804.dbf thread=1 sequence=33462
archived log file name=/fra/orcl/1_33463_999026804.dbf thread=1 sequence=33463
media recovery complete, elapsed time: 00:00:31
Finished recover at 2025/05/22 14:09:44

RMAN> sql'alter database datafile 7,8 online';

sql statement: alter database datafile 7,8 online

相关文章：

Oracle 数据文件被删除后使用rman备份恢复过程

有个环境，因空间使用率100%，现场直接误删了数据文件，log记录恢复过程下 SQL > select file#,name,checkpoint_change# from v$datafile; FILE# NAME CHECKPOINT_CHANGE# ------…...

编程日记 2025/9/13 6:54:01

KS107BG型超声体模的结构及性能

KS107BG型超声体模适用于工作频率在5~10MHz之间的Ｂ超设备的性能检测。 一、外部结构 体模外壳和底座由有机玻璃加工组装而成，底面板上开有两个直径36mm的圆孔，其上封有2mm厚的真空橡皮，作为抽气及注射保养液的入口。体模外壳外表…...

编程日记 2025/9/11 12:01:59

visual studio重新安装如何修改共享组件、工具和SDK路径方案

安装了VsStudio后,如果自己修改了Shared路径，当卸载旧版本，需要安装新版本时发现，之前的Shared路径无法进行修改，这就很坑了 但是却遇到了路径无法修改的问题…真让人头大，当然不修改也可以，有时候&#x…...

编程日记 2025/9/4 5:17:12

目标检测评估指标mAP详解：原理与代码

目标检测评估指标mAP详解：原理与代码 目标检测评估指标mAP详解：原理与代码一、前言：为什么需要mAP？二、核心概念解析2.1 PR曲线（Precision-Recall Curve）2.2 AP计算原理 三、代码实现详解3.1 核心函数ap_pe…...

编程日记 2025/9/8 18:40:56

【风控】模型算法区分度指标KS

一、KS指标的定义原理 背景 KS（Kolmogorov–Smirnov）原本用于检验样本分布与理论分布或两个样本分布是否一致。风控建模中，将“好样本”（Good）与“坏样本”（Bad）的模型输出概率看作两组经验分布…...

编程日记 2025/9/10 12:00:33

道可云人工智能每日资讯｜浙江省人民政府印发《关于支持人工智能创新发展的若干措施》

道可云元宇宙每日简报（2025年5月21日）讯，今日元宇宙新鲜事有： 浙江省人民政府印发《关于支持人工智能创新发展的若干措施》 为抢占人工智能发展制高点，打造全球人工智能创新发展高地，浙江省人民政府于近日…...

编程日记 2025/9/2 16:40:10

win11下jenkins+docker+maven自动部署springboot项目

win11下jenkinsdockermaven自动部署springboot项目 一、前置软件安装二、jenkins配置三、springboot项目准备四、jenkins打包部署项目到本地docker中五、jenkins打包部署项目到远程服务器docker中 一、前置软件安装 docker安装 需要开启wsl，以管理员身份运行docke…...

编程日记 2025/9/8 18:40:48

密码学标准（Cryptography Standards）介绍

密码学标准（Cryptography Standards）是为确保信息安全传输、存储和处理而制定的一系列技术规范和协议，广泛应用于通信、金融、互联网等领域。以下从分类、主流标准、应用场景和发展趋势四个方面进行详细介绍： 一、密码学标准的分类 密码学标准可根据技术原理和应用场景分…...

编程日记 2025/8/6 0:06:24

2 卡尔曼滤波

卡尔曼滤波是啥？ 卡尔曼滤波就像是一个“智能猜谜大师”，专门用来在不确定的情况下，算出最接近真实值的答案。 核心思想： 预测（猜）：根据之前的经验，猜现在大概是什么状态&#xff…...

编程日记 2025/8/15 19:25:45

《决策科学与艺术》No1: 决策树：概念、原理、发展历史、特点及应用

决策树：概念、原理、发展历史、特点及应用 摘要 决策树是一种广泛使用的机器学习和决策分析方法，以其可解释性、简洁性和多功能性著称。本文全面介绍了决策树的概念基础、基本原理、发展历程、显著特征及其在商业、医疗、金融和工程等多个领域的典型应用…...

编程日记 2025/9/8 18:40:44

手机合集（不定期更新）

一、华为手机： 1.华为手机自助维修的方法： https://blog.csdn.net/humors221/article/details/145946128 2.华为手机实用功能介绍： https://blog.csdn.net/humors221/article/details/132514011 3.华为手机清理大数据的方法：…...

编程日记 2025/8/31 23:04:52

掌握正则表达式：从基础语法到工程实践

引言：正则表达式的力量与边界​​ 在信息爆炸的数字时代，​​正则表达式（Regular Expression）​​ 作为文本处理的“瑞士军刀”，已成为开发者、数据分析师、运维工程师等群体的核心技能。它能用简洁的符号逻辑描述复杂…...

编程日记 2025/7/3 15:53:51

Prometheus 基础入门文档

目录 概述 核心组件详解 Prometheus Server Exporters Alertmanager 存储解决方案 安装与配置 安装方法 基本配置 示例配置文件 数据模型与查询语言 数据模型 PromQL 查询语言 示例查询 告警系统 告警规则 示例告警规则 Alertmanager 配置 示例 Alertmanager…...

编程日记 2025/9/1 23:38:25

【数据分析】什么是特征蒸馏？

引言 —— “ 在数据洪流中提炼真金——解密特征蒸馏的艺术。” 在数据爆炸的时代，我们每天产生的信息量已远超人类处理能力的极限。当企业拥有百万维的用户行为数据，医疗研究者面对TB级的基因测序记录，工程师试图从千万张图像中识别关键模式…...

编程日记 2025/9/4 22:33:24

【苍穹外卖】Day01—Mac前端环境搭建

目录 一、安装Nginx （一）安装Homebrew （二）Homebrew安装Nginx 1. 执行安装命令： 2. 验证安装： （三）启动与停止Nginx 二、配置Nginx 1. 替换nginx.conf 2. 替换html文件夹 三…...

编程日记 2025/9/8 18:40:39

Apollo10.0学习——planning模块（9）之参数详解一

planning.conf --flagfilemodules/common/data/global_flagfile.txt # 加载全局通用配置，包含基础运行参数 --traffic_rule_config_filenamemodules/planning/planning_component/conf/traffic_rule_config.pb.txt # 交通规则配置文件，定义信号灯、停车…...

编程日记 2025/8/31 13:49:10

Python-多进程编程 (multiprocessing 模块)

目录 一、创建进程1. Process 的语法结构2. 进程不共享全局变量 二、进程间通信1. 队列通信2. 管道通信 三、进程池1. 常用函数2. 进程池中的 Queue 四、应用：复制文件夹（多进程版）五、守护进程和进程同步六、注意事项 通过使用 multiprocess…...

编程日记 2025/6/29 23:32:49

GraphQL在.NET 8中的全面实践指南

一、GraphQL与.NET 8概述 GraphQL是一种由Facebook开发的API查询语言，它提供了一种更高效、更灵活的替代REST的方案。与REST不同，GraphQL允许客户端精确指定需要的数据结构和字段，避免了"过度获取"或"不足获取"的问题。…...

编程日记 2025/7/20 17:10:29

在mobaxterm下面执行shell脚本报错

关键步骤：在 MobaXterm 的 SSH 会话中强制指定 Bash 解释器 若你曾通过 高级 SSH 设置中的「执行命令」 填写 /bin/bash 解决脚本问题，以下是具体操作和原理说明： 1. 设置位置 打开 MobaXterm，选择需要配置的 SSH 会话&#xff0…...

编程日记 2025/6/17 13:03:06

系统集成项目管理工程师学习笔记之启动过程组

第十章 启动过程组 制定项目章程 定义 制定项目章程是编写一份正式批准项目并授权项目经理在项目活动中使用组织资源的文件的过程。 正式批准的项目文件 作用 1、明确项目与组织战略目标之间的直接联系 2、确立项目的正式地位 3、展示组织对项目的承诺 本过程仅开展一…...

编程日记 2025/8/31 13:51:36

OceanBase数据库全面指南（数据操作篇DML）

文章目录 一、OceanBase插入数据全指南1.1 INSERT语句基础用法1.2 高级INSERT用法1.2.1 插入查询结果1.2.2 多表插入1.2.3 条件插入1.3 INSERT性能优化技巧1.3.1 批量插入优化1.3.2 使用APPEND提示1.3.3 并行插入二、OceanBase批量插入优化2.1 多行插入语法详解2.2 批量绑定技术…...

编程日记 2025/7/5 14:38:02

深入解析AI中的Prompt工程：从理论到实践

目录 引言：Prompt在AI中的核心地位 第一部分：Prompt基础理论 1.1 什么是Prompt 1.2 ICIO框架：Prompt设计的结构化方法 1.3 为什么需要Prompt 1.4 Prompt的终极价值 第二部分：Prompt工程实践 2.1 Prompt工程概述 2.2 Prompt工程的具体内容 2.3 Prompt Engineer的工…...

编程日记 2025/9/9 20:22:03

软考中级软件设计师——设计模式篇

一、设计模式核心分类 设计模式分为 3 大类，共 23 种模式（考试常考约 10-15 种）： 分类核心模式考试重点创建型模式工厂方法、抽象工厂、单例、生成器、原型单例模式的实现（懒汉、饿汉）、工厂模式的应用场…...

编程日记 2025/9/9 19:43:29

matlab二维随机海面模拟

二维随机海面模拟是一种重要的技术，广泛应用于海洋工程、船舶设计、雷达系统和光学通信等领域。利用蒙特卡罗方法结合二维海浪功率谱模型，可以生成符合实际海面特性的随机表面。 步骤 1: 定义海浪功率谱模型 海浪功率谱模型描述了海浪能量在不同频率和…...

编程日记 2025/9/13 10:31:14

Axure系统原型设计列表版方案

列表页面是众多系统的核心组成部分，承担着数据呈现与基础交互的重要任务。一个优秀的列表版设计，能够极大提升用户获取信息的效率，优化操作体验。下面，我们将结合一系列精心设计的列表版方案图片，深入探讨如何打造出实…...

编程日记 2025/9/8 18:40:27

微软全新开源命令行文本编辑器：Edit — 致敬经典，拥抱现代

名人说：博观而约取，厚积而薄发。——苏轼《稼说送张琥》 创作者：Code_流苏(CSDN)（一个喜欢古诗词和编程的Coder😊） 目录 一、引言：命令行的新利器二、Edit：致敬经典，拥抱现代1. 命令行的“新升级”2. 为什么要有 Edit？三、核心功能与特性一览1. 完全开源、MIT 许可证…...

编程日记 2025/9/8 18:40:23

年会招标抽奖活动软件———仙盟创梦IDE

年会是企业一年的总结与欢庆时刻，而抽奖环节更是点燃全场气氛的关键。如何让抽奖环节既大气又充满仪式感？选对抽奖软件至关重要！本文精心挑选了 3 款兼具实用性与氛围感的年会抽奖软件，从界面设计到功能特色，全方位为你…...

编程日记 2025/9/12 11:02:51

智防火灾，慧控能耗：物联网赋能金融行业电气安全革新

摘要 随着金融行业对电气安全需求的不断提升，传统用电管理模式已难以满足现代金融机构对火灾防控、能耗管理和智能运维的要求。本文基于物联网、云计算及大数据分析技术，提出一套针对金融行业的安全用电解决方案。该方案通过智能化硬件部署与平台化管理…...

编程日记 2025/9/8 18:40:11

Any类（C++17类型擦除，也称上帝类）

Any类（C17类型擦除，也称上帝类） 在C中，std::any 是C17标准引入的一个灵活的类型安全容器，用于存储任意类型的单个值。 1. std::any 的核心特性 类型安全：存储的值必须通过明确的类型转换（any_…...

编程日记 2025/8/11 23:29:55

jquery.table2excel方法导出

jquery提供了一个table2excel方法可以用来导出页面到xls等 $("#grid_595607").table2excel({exclude: ".noExport", // 排除类名为 noExport 的元素filename: "导出数据.xls",exclude_img: true, // 不导出图片exclude_links: true, // 不导…...

编程日记 2025/7/18 17:36:01