Posts

Repair Corrupt Blocks using RMAN Data Recovery Advisor Scenario - Oracle 11gR2

SQL> show parameter db_n NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_name                              string      DB11G1 SQL> select * from v$database_block_corruption;      FILE#     BLOCK#     BLOCKS CORRUPTION_CHANGE# CORRUPTIO ---------- ---------- ---------- ------------------ ---------          6        131          1                  0 CORRUPT Sample corrupted block I created manually SQL> select * from MAC.MAC_SAMPLE; select * from MAC.MAC_SAMPLE                   * ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 6, block # 131) ORA-01110: data file 6: '+DATA/db11g1/datafile/mac.270.1001447963' SQL> exit Disconnected from 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 [oracle@db11g ~]$ rman target / Reco
2 comments
Read more

How to corrupt a datafile manually ASM scenario - oracle 11gR2

RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name DB11G1 List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    750      SYSTEM               ***     +DATA/db11g1/datafile/system.256.997039649 2    550      SYSAUX               ***     +DATA/db11g1/datafile/sysaux.257.997039651 3    65       UNDOTBS1             ***     +DATA/db11g1/datafile/undotbs1.258.997039651 4    5        USERS                ***     +DATA/db11g1/datafile/users.259.997039651 5    345      EXAMPLE              ***     +DATA/db11g1/datafile/example.265.997039919 6    5        MAC                  ***     +DATA/db11g1/datafile/mac.270.1001447963 List of Temporary Files ======================= File Size(MB) Tablespace           Maxsize(MB) Tempfile Name ---- -------- --------------------
Post a Comment
Read more

Resolve Startup Error after Dropping a Datafile manually locally in ASM Scenario - Oracle 11gR2

Log to the database and shut it [oracle@db11g ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 27 18:10:16 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 open_mode from v$database; OPEN_MODE -------------------- READ WRITE SQL> shut immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from 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 Delete the datafile manually [oracle@db11g ~]$ exit logout [root@db11g ~]# su - grid [grid@db11g ~]$ . oraenv ORACLE_SID = [+ASM] ? The Oracle base remains unchanged with value /u01/app/grid [grid@db
Post a Comment
Read more

Recover Manually Dropped Datafile in ASM Scenario - Oracle 11gR2

Create a test tablespace and user eg:-MAC SQL> show parameter db_n NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_name                              string      DB11G1 SQL> show parameter create NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ create_bitmap_area_size              integer     8388608 create_stored_outlines               string db_create_file_dest                  string      +DATA db_create_online_log_dest_1          string db_create_online_log_dest_2          string db_create_online_log_dest_3          string db_create_online_log_dest_4          string db_create_online_log_dest_5          string SQL> create tablespace MAC datafile '+DATA' size 5M; Tablespace created. SQL> create user MAC identified by oracle default tablespace MAC quota unlimited on MAC; User
Post a Comment
Read more