`

RMAN failed becaue of ORA-19502.

 
阅读更多

RMAN failed because the following errors from rman log.

channel ORA_DISK_2: starting piece 1 at DEC-28-2010 12:15:14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/28/2010 12:23:39
ORA-19502: write error on file "/global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_oom0mi2h_1_1.bak", blockno 4403201 (blocksize=512
)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 597504
Additional information: 1048576

It is because there is no diskspace to hold the backup pieces.

we have set the retention window for two days.

RMAN> show all;

using target database controlfile instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_ctrl_%F.bak';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_%U.bak' MAXPIECESIZE 8000 M;
CONFIGURE MAXSETSIZE TO UNLIMITED;

It means the diskspace should be able hold at least three days backup pieces.

use the df -h to see how much disk usage for the two days backups.

The value is 78% for the backup filesystem.

This is the rootcause of the failure.

Let us see the details:

RMAN> list expired backup;

RMAN> report need backup redundancy =2;

Report of files with less than 2 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN> report need backup redundancy =1;

Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN> report unrecoverable;

Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 2 days
no obsolete backups found
RMAN> Crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=770 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=820 devtype=DISK
。。。。。。。。。。。。。。。。。。。。。
Crosschecked 8 objects?

RMAN> Crosscheck archivelog all;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=770 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=820 devtype=DISK
........................................
Crosschecked 28 objects
RMAN> list expired backup;
List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15090 Full 4G DISK 00:17:48 26-DEC-10
BP Key: 15090 Status: EXPIRED Tag: TAG20101226T001503
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_ntm0fv47_1_1.bak
List of Datafiles in backup set 15090
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/system01.dbf
4 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/tools01.dbf
6 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/xdb01.dbf
7 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/am_data01.dbf
10 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/cp_inventory_data01.dbf
13 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/pm_data01.dbf
18 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/account_data01.dbf
21 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/wiki01.dbf
23 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/cp_inventory_data02.dbf
24 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/tis_data01.dbf
25 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/xdb02.dbf
26 Full 8467276111641 26-DEC-10 /global/oracle2/oradata2/CPPRD/tools02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15091 Full 5G DISK 00:22:33 26-DEC-10
BP Key: 15091 Status: EXPIRED Tag: TAG20101226T001503
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_num0fv48_1_1.bak
List of Datafiles in backup set 15091
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/undotbs01.dbf
3 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/drsys01.dbf
5 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/users01.dbf
8 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/cta_data01.dbf
9 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/heartbeat_data01.dbf
11 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/jira_data01.dbf
12 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/mast_data01.dbf
14 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/services_data01.dbf
15 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/spyglass_data01.dbf
17 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/pwd_data01.dbf
19 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/hr_data01.dbf
22 Full 8467276111644 26-DEC-10 /global/oracle2/oradata2/CPPRD/smc_mv_logs01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15092 Full 2G DISK 00:11:18 26-DEC-10
BP Key: 15092 Status: EXPIRED Tag: TAG20101226T001503
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_nvm0g05s_1_1.bak
List of Datafiles in backup set 15092
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
20 Full 8467277165500 26-DEC-10 /global/oracle2/oradata2/CPPRD/webadmin_data02.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15093 Full 3G DISK 00:12:09 26-DEC-10
BP Key: 15093 Status: EXPIRED Tag: TAG20101226T001503
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_o0m0g0ep_1_1.bak
List of Datafiles in backup set 15093
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
16 Full 8467277516399 26-DEC-10 /global/oracle2/oradata2/CPPRD/webadmin_data01.dbf

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15094 2G DISK 00:11:08 26-DEC-10
BP Key: 15094 Status: EXPIRED Tag: TAG20101226T004957
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_o2m0g15n_1_1.bak

List of Archived Logs in backup set 15094
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 157407 8467254043607 25-DEC-10 8467255012759 25-DEC-10
1 157408 8467255012759 25-DEC-10 8467255926649 25-DEC-10
1 157409 8467255926649 25-DEC-10 8467256945794 25-DEC-10
1 157410 8467256945794 25-DEC-10 8467257864568 25-DEC-10
1 157411 8467257864568 25-DEC-10 8467258803216 25-DEC-10
1 157412 8467258803216 25-DEC-10 8467259738992 25-DEC-10
1 157413 8467259738992 25-DEC-10 8467260647589 25-DEC-10
1 157414 8467260647589 25-DEC-10 8467261607633 25-DEC-10
1 157415 8467261607633 25-DEC-10 8467262589366 25-DEC-10
1 157416 8467262589366 25-DEC-10 8467263550238 25-DEC-10
1 157417 8467263550238 25-DEC-10 8467264461024 25-DEC-10
1 157418 8467264461024 25-DEC-10 8467265400438 25-DEC-10
1 157419 8467265400438 25-DEC-10 8467266175528 25-DEC-10
1 157420 8467266175528 25-DEC-10 8467266249095 25-DEC-10
1 157421 8467266249095 25-DEC-10 8467266418398 25-DEC-10
1 157422 8467266418398 25-DEC-10 8467266634369 25-DEC-10
1 157423 8467266634369 25-DEC-10 8467267638357 25-DEC-10
1 157424 8467267638357 25-DEC-10 8467268556163 25-DEC-10
1 157425 8467268556163 25-DEC-10 8467269487701 25-DEC-10
1 157426 8467269487701 25-DEC-10 8467270430555 25-DEC-10
1 157427 8467270430555 25-DEC-10 8467271367767 25-DEC-10
1 157428 8467271367767 25-DEC-10 8467272699523 25-DEC-10
1 157429 8467272699523 25-DEC-10 8467274168819 25-DEC-10
1 157430 8467274168819 25-DEC-10 8467275028116 25-DEC-10
1 157431 8467275028116 25-DEC-10 8467275974031 26-DEC-10
1 157432 8467275974031 26-DEC-10 8467277062422 26-DEC-10
1 157433 8467277062422 26-DEC-10 8467278130963 26-DEC-10
1 157434 8467278130963 26-DEC-10 8467278257188 26-DEC-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15095 3G DISK 00:13:22 26-DEC-10
BP Key: 15095 Status: EXPIRED Tag: TAG20101226T121506
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_o4m0h9ad_1_1.bak

List of Archived Logs in backup set 15095
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 157446 8467288682614 26-DEC-10 8467289696576 26-DEC-10
1 157447 8467289696576 26-DEC-10 8467290634240 26-DEC-10
1 157448 8467290634240 26-DEC-10 8467291563792 26-DEC-10
1 157449 8467291563792 26-DEC-10 8467292527431 26-DEC-10
1 157450 8467292527431 26-DEC-10 8467293403743 26-DEC-10
1 157451 8467293403743 26-DEC-10 8467294423132 26-DEC-10
1 157452 8467294423132 26-DEC-10 8467295335621 26-DEC-10
1 157453 8467295335621 26-DEC-10 8467296379866 26-DEC-10
1 157454 8467296379866 26-DEC-10 8467297359389 26-DEC-10
1 157455 8467297359389 26-DEC-10 8467298299591 26-DEC-10
1 157456 8467298299591 26-DEC-10 8467299218934 26-DEC-10
1 157457 8467299218934 26-DEC-10 8467300153869 26-DEC-10
1 157458 8467300153869 26-DEC-10 8467301148816 26-DEC-10
1 157459 8467301148816 26-DEC-10 8467302062402 26-DEC-10
1 157460 8467302062402 26-DEC-10 8467303020155 26-DEC-10
1 157461 8467303020155 26-DEC-10 8467303968319 26-DEC-10
1 157462 8467303968319 26-DEC-10 8467304868044 26-DEC-10
1 157463 8467304868044 26-DEC-10 8467305793065 26-DEC-10
1 157464 8467305793065 26-DEC-10 8467306751786 26-DEC-10
1 157465 8467306751786 26-DEC-10 8467307706866 26-DEC-10
1 157466 8467307706866 26-DEC-10 8467308609570 26-DEC-10
1 157467 8467308609570 26-DEC-10 8467309525068 26-DEC-10
1 157468 8467309525068 26-DEC-10 8467310472359 26-DEC-10
1 157469 8467310472359 26-DEC-10 8467311417658 26-DEC-10
1 157470 8467311417658 26-DEC-10 8467312423646 26-DEC-10
1 157471 8467312423646 26-DEC-10 8467313332226 26-DEC-10
1 157472 8467313332226 26-DEC-10 8467314268393 26-DEC-10
1 157473 8467314268393 26-DEC-10 8467315181441 26-DEC-10
1 157474 8467315181441 26-DEC-10 8467316146094 26-DEC-10
1 157475 8467316146094 26-DEC-10 8467317109806 26-DEC-10
1 157476 8467317109806 26-DEC-10 8467318032098 26-DEC-10
1 157477 8467318032098 26-DEC-10 8467319034761 26-DEC-10
1 157478 8467319034761 26-DEC-10 8467319961122 26-DEC-10
1 157479 8467319961122 26-DEC-10 8467320826074 26-DEC-10
1 157480 8467320826074 26-DEC-10 8467321752728 26-DEC-10
1 157481 8467321752728 26-DEC-10 8467322712789 26-DEC-10
1 157482 8467322712789 26-DEC-10 8467323647244 26-DEC-10
1 157483 8467323647244 26-DEC-10 8467324631265 26-DEC-10
1 157484 8467324631265 26-DEC-10 8467324875108 26-DEC-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
15096 3G DISK 00:13:39 26-DEC-10
BP Key: 15096 Status: EXPIRED Tag: TAG20101226T121506
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_o3m0h9ad_1_1.bak

List of Archived Logs in backup set 15096
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 157378 8467226164917 25-DEC-10 8467227143624 25-DEC-10
1 157379 8467227143624 25-DEC-10 8467228142839 25-DEC-10
1 157380 8467228142839 25-DEC-10 8467229106571 25-DEC-10
1 157381 8467229106571 25-DEC-10 8467230041506 25-DEC-10
1 157382 8467230041506 25-DEC-10 8467231042828 25-DEC-10
1 157383 8467231042828 25-DEC-10 8467231985039 25-DEC-10
1 157384 8467231985039 25-DEC-10 8467232954305 25-DEC-10
1 157385 8467232954305 25-DEC-10 8467233913862 25-DEC-10
1 157386 8467233913862 25-DEC-10 8467234866135 25-DEC-10
1 157387 8467234866135 25-DEC-10 8467235811031 25-DEC-10
1 157388 8467235811031 25-DEC-10 8467236720854 25-DEC-10
1 157389 8467236720854 25-DEC-10 8467237680501 25-DEC-10
1 157390 8467237680501 25-DEC-10 8467238649502 25-DEC-10
1 157391 8467238649502 25-DEC-10 8467239555952 25-DEC-10
1 157392 8467239555952 25-DEC-10 8467240548035 25-DEC-10
1 157393 8467240548035 25-DEC-10 8467241457669 25-DEC-10
1 157394 8467241457669 25-DEC-10 8467242451248 25-DEC-10
1 157395 8467242451248 25-DEC-10 8467243407665 25-DEC-10
1 157396 8467243407665 25-DEC-10 8467244349365 25-DEC-10
1 157397 8467244349365 25-DEC-10 8467245248127 25-DEC-10
1 157398 8467245248127 25-DEC-10 8467246246776 25-DEC-10
1 157399 8467246246776 25-DEC-10 8467247347199 25-DEC-10
1 157400 8467247347199 25-DEC-10 8467248252623 25-DEC-10
1 157401 8467248252623 25-DEC-10 8467249257454 25-DEC-10
1 157402 8467249257454 25-DEC-10 8467250187423 25-DEC-10
1 157403 8467250187423 25-DEC-10 8467251166829 25-DEC-10
1 157404 8467251166829 25-DEC-10 8467252147525 25-DEC-10
1 157405 8467252147525 25-DEC-10 8467253093732 25-DEC-10
1 157406 8467253093732 25-DEC-10 8467254043607 25-DEC-10
1 157435 8467278257188 26-DEC-10 8467279175606 26-DEC-10
1 157436 8467279175606 26-DEC-10 8467280093538 26-DEC-10
1 157437 8467280093538 26-DEC-10 8467281078581 26-DEC-10
1 157438 8467281078581 26-DEC-10 8467281995278 26-DEC-10
1 157439 8467281995278 26-DEC-10 8467283023767 26-DEC-10
1 157440 8467283023767 26-DEC-10 8467283929267 26-DEC-10
1 157441 8467283929267 26-DEC-10 8467284919113 26-DEC-10
1 157442 8467284919113 26-DEC-10 8467285935472 26-DEC-10
1 157443 8467285935472 26-DEC-10 8467286842785 26-DEC-10
1 157444 8467286842785 26-DEC-10 8467287756726 26-DEC-10
1 157445 8467287756726 26-DEC-10 8467288682614 26-DEC-10

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15097 Full 2M DISK 00:00:02 26-DEC-10
BP Key: 15097 Status: EXPIRED Tag:
Piece Name: /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_ctrl_c-777430827-20101226-00.bak
SPFILE Included: Modification time: 10-DEC-08

RMAN> report need backup redundancy =1;

Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
RMAN> report unrecoverable;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 2 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 15090 26-DEC-10
Backup Piece 15090 26-DEC-10 /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_ntm0fv47_1_1.bak
Backup Set 15091 26-DEC-10
Backup Piece 15091 26-DEC-10 /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_num0fv48_1_1.bak
Backup Set 15092 26-DEC-10
Backup Piece 15092 26-DEC-10 /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_nvm0g05s_1_1.bak
Backup Set 15093 26-DEC-10
Backup Piece 15093 26-DEC-10 /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_db_o0m0g0ep_1_1.bak
Backup Set 15097 26-DEC-10
Backup Piece 15097 26-DEC-10 /global/oracle4/ORADUMP/CPPRD/backup/CPPRD_rman_ctrl_c-777430827-20101226-00.bak
The 26th backup is expired but is not removed correctly.

It take the diskspace then the new backup can not generate because there is no enough diskspace to hold backup pieces.

It sounds simple?

but what cause the 26th backup stay there after being expired?

分享到：
| 苹果上免费开源文本编辑器 -MacVim
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    instantclient-linux.x64-11.2.0.4.0.rar

    7. **instantclient-tools-linux.x64-11.2.0.4.0.zip**：包含了一些额外的数据库管理工具，如`rman`(恢复管理器)和其他实用程序。 这些组件共同构建了一个全面的Oracle数据库客户端环境，允许用户在Linux平台上进行...

    centos7_rlwrap-0.42.tar.gz

    找到centos7 安装的iso中的 Packages的 ncurses-devel-5.9-13.20130511.el7.x86_64.rpm rpm -ivh ncurses-devel-5.9-13.20130511.el7.x86_64.rpm 找到系统是否安装了 readline ...alias rman="rlwrap rman

    instantclient-basic-windows.x64-12.1.0.2.0.zip

    如果你的应用还需要ODBC、RMAN或其他高级特性，可能需要下载并安装额外的组件包，如"instantclient-sdk"或"instantclient-sqlplus"。 总的来说，Oracle Instant Client是连接Oracle数据库的必备工具，尤其适合开发...

    rlwrap-0.42-1.el7.x86_64.rpm

    在Linux下使用sqlplus或者rman时，经常需要调用上次或之前运行过的命令 下载包地址： http://rpm.pbone.net/index.php3/stat/4/idpl/28195042/dir/redhat_el_7/com/rlwrap-0.42-1.el7.x86_64.rpm.html 地址2： ...

    rlwrap-0.30-1.el5.i386 rpm包

    默认情况下在Linux上安装的Oracle 10g的sqlplus不支持回显，这在使用中造成了一定的不便，为了使其支持回显功能，我们需要rlwrap软件来帮忙。 首先下载rlwrap-0.30-1.el5.i386的rpm包或者...alias rman='rlwrap rman'

    readline-static-6.0-4.el6.x86-64.rpm

    sqlplus 上下键，centos6 安装 yum -y install readline* 提示无readline-static-6.0-4.el6.x86_64.rpm包 下载rlwrap-0.41.tar.gz地址： ... cd rlwrap-0.43/ ./configure && make && make ...alias rman='rlwrap rman'

    LINUX环境下使用RMAN开展数据库备份--ZW.doc

    运维

    ORACLE ORA-00132 ORA-00214

    ### Oracle 错误 ORA-00132 和 ORA-00214 解析及处理 #### 一、错误概述 在Oracle数据库管理过程中，遇到ORA-00132和ORA-00214这类错误时，往往意味着数据库配置或启动过程中出现了问题。下面将对这两个错误进行...

    rlwrap-0.41-1.el6.x86_64.rpm

    rlwrap 可以用来支持Oracle下sqlplus历史命令的回调功能，提高效率。 此RPM 包 可以直接安装，不需要其他依赖包。以在RHEL6.4_X86-64安装成功并使用。 使用方法 rlwrap sqlplus ...alias rman=’rlwrap rman’

    Oracle 10g启动后报ORA-16038错误的解决方法

    ### Oracle 10g启动后报ORA-16038错误的解决方法 #### 错误概述 在启动Oracle 10g数据库时遇到ORA-16038错误，该错误通常与归档日志操作有关。具体错误信息为： ``` ORA-16038: log 1 sequence #230 cannot be ...

    离线误删空间文件导致的ORA-01033及ORA-01145问题的解决办法

    3. **使用RMAN工具**：通过Oracle提供的恢复管理器（RMAN）工具来执行数据文件的离线操作，RMAN支持更安全的离线和恢复操作。 #### 实际案例分析 假设在尝试解决ORA-01033问题时遇到了ORA-01145错误。根据给出的...

    ORA-00257错误.doc

    处理 ORA-00257 错误的思路是：删除物理文件和登录 RMAN 释放 archivelog 空间。下面是详细的处理过程： 1. 删除物理文件 首先，我们需要登录到 Oracle 服务器，使用 su 命令切换到 Oracle 用户，然后使用 sqlplus...

    oracle重启报错ORA-00702解决办法

    如果文件损坏，可能需要使用RMAN进行修复。 4. **重建控制文件**：如果控制文件有问题，可以使用`CREATE CONTROLFILE`命令重建。首先，记录所有必要的表空间和数据文件信息，然后执行重建命令。 5. **重启数据库**：...

    p8922013_10204_Linux-x86-64.zipORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059

    5. **数据恢复**：如果错误导致数据损坏，可能需要使用RMAN（Recovery Manager）或其他备份工具进行数据恢复。 标签 "ORA-00600 Oracle 补丁 Patches Update" 暗示了这个问题的解决方案可能涉及更新数据库的补丁，...

    好用rlwrap-0.40.tar.gz

    由于RMAN的原始命令行并不支持历史浏览和编辑，`rlwrap`的加入可以使RMAN使用更加友好。使用方法如下： ```bash rlwrap rman target / connect sys/password@database ``` 这样，你就能在RMAN会话中享受到`rlwrap`...

    Oracle.RealExamQuestions.1Z0-052.v2011-11-08

    **问题描述**：识别为以下操作分配内存的内存组件：会话内存对于共享服务器、I/O 从属进程缓冲区、Oracle Database Recovery Manager (RMAN) 备份和恢复操作。 - A. Large Pool - B. Redo Log Buffer - C. Database...

    oracle 回闪日志 满了 ORA-03113 通信信道结束 进入 rman 删除日志

    ### Oracle回闪日志满了与ORA-03113错误处理 在Oracle数据库管理过程中，经常遇到的一些问题包括回闪日志空间不足以及ORA-03113错误等。这些问题若不及时解决，可能会导致数据库性能下降甚至停机。下面我们将详细...

    数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复.docx

    【ORA-600 16703 灾难恢复详解】 在数据库管理领域，数据恢复是一项至关重要的任务，尤其是当系统遇到严重错误如 ORA-600 时。ORA-00600 是Oracle数据库内部错误代码，通常表示遇到了未预期的内部错误或数据结构...

    ora 错误全集 全部 ora0000-ora32999

    ORA-14400是索引块损坏，可能需要使用RMAN或DB_REPAIR坏块修复工具。 ORA-20000到ORA-29999主要涵盖PL/SQL（Procedural Language/SQL）和存储过程中的错误，例如ORA-24374表示定义的作业类型与实际的作业类型不匹配...

    oracle_12.2.0.1_green_non-cdb_v5-step9_rman_foreign-restore.zip

    在这个“oracle_12.2.0.1_green_non-cdb_v5-step9_rman_foreign-restore.zip”压缩包中，包含了一系列与Oracle数据库恢复相关的脚本和配置文件，特别关注了RMAN（恢复管理器）的功能，这在数据库故障恢复和备份策略...

Magicbox
Global site tag (gtag.js) - Google Analytics