remote dba support
More
    HomeOracle TroubleshootingTroubleshooting of ORA-01116 ORA-27041 and ORA-01110

    Troubleshooting of ORA-01116 ORA-27041 and ORA-01110

    The article explains Troubleshooting of ORA-01116 ORA-27041 and ORA-01110 with the proper solution using with RMAN

    Troubleshooting of ORA-01116 ORA-27041 and ORA-01110 with solution

    RMAN is basically a system by which we can recover our database up to a point in time. Till now, we have IMP, EXP backup utility by which we were taking our backups. Which
    Have some disadvantages. Let us have taken our data backup at 10 a.m. by using IMP utility and my database gets corrupted at 5 p.m. We can restore it from the 10 a.m. backup but after restoring the data available up to 10 a.m. only, i.e. the transaction between 10 a.m. to 5 p.m. are lost. This is not affordable in the case of financial transactions.

    To overcome this problem, we use RMAN. By using RMAN we can recover our database up to the time.

    - Advertisement -
    dbametrix

    Some technical requirements for RMAN:

    1. Whenever any datafile gets corrupt you will get a message like.

    SQL> select count(*) from emp;
    select count(*) from emp
    *
    ERROR at line 1:
    ORA-01116: error in opening database file 6
    ORA-01110: data file 6: ‘/sa5/bkp/apst/APST/datafile/users1.dbf
    ORA-27041: unable to open file
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3

    This shows our users1.dbf data file is corrupt. Now we need to recover this data file.

    - Advertisement -
    dbametrix

    2. Use commands like.

    C:\Documents and Settings\dbametrix>sqlplus sys as sysdba

    SQL*Plus: Release 11.2.0.1.0 – Production on Wed Sep 11 06:05:26 2019
    Copyright (c) 1982, 2009, Oracle. All rights reserved.
    Enter password:
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
    With the Partitioning, OLAP and Data Mining options

    SQL> shutdown immediate;
    SQL> startup mount;

    3. Now, this step is to restore and recover a database. We have two ways to do it.

    4. Recovery using command prompt.

    Use commands like.

    C:\Documents and Settings\dbametrix>rman target sys
    Recovery Manager: Release 11.2.0.1.0 – Production on Wed Sep 11 07:10:32 2019
    Copyright (c) 1982, 2009, Oracle. All rights reserved.
    target database Password:
    connected to target database: TEST (DBID=1962560248, not open)
    RMAN>
    RMAN> restore database;
    (This command will restore data files from a backup).
    RMAN> recover database;
    (This command will recover your database up to the time.)

    And your errors resolved with database recovery.

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert. This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    - Advertisement -
    dbametrix
    - Advertisment -
    remote dba services

    Most Popular