DB BLOCK ERROR
========================================================
SYSTEM '/u01/oracle/PROD/db/apps_st/data/system09.dbf' 1501
Alter database datafile '/u01/oracle/PROD/db/apps_st/data/system09.dbf' resize 1501m;
[proddb@erpdb ~]$ rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Sat May 14 14:06:34 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PROD (DBID=198759758)
RMAN> backup datafile 352 format '/u01/sys09_%U.bkp';
Starting backup at 14-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=621 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00352 name=/u01/oracle/PROD/db/apps_st/data/system09.dbf
channel ORA_DISK_1: starting piece 1 at 14-MAY-16
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/14/2016 14:07:23
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/oracle/PROD/db/apps_st/data/system09.dbf
RMAN>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[proddb@erpdb ~]$
[proddb@erpdb ~]$
[proddb@erpdb ~]$
[proddb@erpdb ~]$ rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Sat May 14 14:06:34 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PROD (DBID=198759758)
RMAN> backup datafile 352 format '/u01/sys09_%U.bkp';
Starting backup at 14-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=621 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00352 name=/u01/oracle/PROD/db/apps_st/data/system09.dbf
channel ORA_DISK_1: starting piece 1 at 14-MAY-16
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/14/2016 14:07:23
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/oracle/PROD/db/apps_st/data/system09.dbf
RMAN>
user interrupt received
\
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "\"
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> exit
Recovery Manager complete.
=======================================================================
Solution
=======================================================================[proddb@erpdb ~]$ qlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 14 14:08:35 2016
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database datafile '/u01/oracle/PROD/db/apps_st/data/system09.dbf' resize 1100m;
Database altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[proddb@erpdb ~]$ rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Sat May 14 14:09:07 2016
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PROD (DBID=198759758)
RMAN> backup datafile 352 format '/u01/sys09_%U.bkp';
Starting backup at 14-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=637 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00352 name=/u01/oracle/PROD/db/apps_st/data/system09.dbf
channel ORA_DISK_1: starting piece 1 at 14-MAY-16
channel ORA_DISK_1: finished piece 1 at 14-MAY-16
piece handle=/oradata/sys09_07r5ir49_1_1.bkp tag=TAG20160514T140913 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 14-MAY-16
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 829.12M DISK 00:00:05 14-MAY-16
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20160514T140913
Piece Name: /u01/sys09_07r5ir49_1_1.bkp
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
352 Full 5967074971654 14-MAY-16 /u01/oracle/PROD/db/apps_st/data/system09.dbf
RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 AVAILABLE DISK /u01/sys09_07r5ir49_1_1.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/sys09_07r5ir49_1_1.bkp RECID=1 STAMP=911830153
Deleted 1 objects
RMAN> exit
Recovery Manager complete.
[proddb@erpdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 14 14:09:45 2016
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database datafile '/u01/oracle/PROD/db/apps_st/data/system09.dbf' resize 1501m;
Database altered.
SQL>
No comments:
Post a Comment