This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Apr 4, 2013 7:40 AM by SANCHITGUPTA RSS

ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'

SANCHITGUPTA Newbie
Currently Being Moderated
HI Experts

I am trying to convert window (oracle 10g) to linux (oracle 10g) using given tutorial link. My database is in archivelog mode

http://kamranagayev.com/2010/08/20/rman-convert-database-video-tutorial/

when i m trying to alter database open resetlogs then its giving error

sql> ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'

even i have tried
recover database using backup controlfile
and
recover database using backup controlfile until cancel
  • 1. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    Alert log file :


    Wed Apr 03 19:07:05 IST 2013
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 3
    IMODE=BR
    ILAT =18
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.5.0.
    System parameters with non-default values:
    processes = 150
    __shared_pool_size = 159383552
    __large_pool_size = 0
    __java_pool_size = 4194304
    __streams_pool_size = 0
    sga_target = 612368384
    control_files = /opt/oracle/oradata/pd1perf/control01.ctl, /opt/oracle/oradata/pd1perf/control02.ctl, /opt/oracle/oradata/pd1perf/control03.ctl
    db_block_size = 8192
    __db_cache_size = 440401920
    compatible = 10.2.0.1.0
    log_archive_dest_1 = LOCATION=/opt/oracle/flash_recovery_area/PD1PERF
    log_archive_format = pd1perf_%t_%s_%r.ARC
    db_file_multiblock_read_count= 16
    db_recovery_file_dest = /opt/oracle/flash_recovery_area/PD1PERF
    db_recovery_file_dest_size= 2147483648
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    dispatchers = (PROTOCOL=TCP) (SERVICE=pd1perfXDB)
    job_queue_processes = 10
    background_dump_dest = /opt/oracle/admin/pd1perf/bdump
    user_dump_dest = /opt/oracle/admin/pd1perf/udump
    core_dump_dest = /opt/oracle/admin/pd1perf/cdump
    audit_file_dest = /opt/oracle/admin/pd1perf/adump
    db_name = pd1perf
    open_cursors = 300
    pga_aggregate_target = 203423744
    PMON started with pid=2, OS id=5399
    PSP0 started with pid=3, OS id=5401
    MMAN started with pid=4, OS id=5403
    DBW0 started with pid=5, OS id=5405
    LGWR started with pid=6, OS id=5407
    CKPT started with pid=7, OS id=5409
    SMON started with pid=8, OS id=5411
    RECO started with pid=9, OS id=5413
    CJQ0 started with pid=10, OS id=5415
    MMON started with pid=11, OS id=5417
    Wed Apr 03 19:07:06 IST 2013
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    MMNL started with pid=12, OS id=5419
    Wed Apr 03 19:07:06 IST 2013
    starting up 1 shared server(s) ...
    Oracle Data Guard is not available in this edition of Oracle.
    Wed Apr 03 19:07:06 IST 2013
    Shutting down instance (abort)
    License high water mark = 1
    Instance terminated by USER, pid = 5424
    Wed Apr 03 19:07:07 IST 2013
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 3
    IMODE=BR
    ILAT =18
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.5.0.
    System parameters with non-default values:
    processes = 150
    __shared_pool_size = 159383552
    __large_pool_size = 0
    __java_pool_size = 4194304
    __streams_pool_size = 0
    sga_target = 612368384
    control_files = /opt/oracle/oradata/pd1perf/control01.ctl, /opt/oracle/oradata/pd1perf/control02.ctl, /opt/oracle/oradata/pd1perf/control03.ctl
    db_block_size = 8192
    __db_cache_size = 440401920
    compatible = 10.2.0.1.0
    log_archive_dest_1 = LOCATION=/opt/oracle/flash_recovery_area/PD1PERF
    log_archive_format = pd1perf_%t_%s_%r.ARC
    db_file_multiblock_read_count= 16
    db_recovery_file_dest = /opt/oracle/flash_recovery_area/PD1PERF
    db_recovery_file_dest_size= 2147483648
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    dispatchers = (PROTOCOL=TCP) (SERVICE=pd1perfXDB)
    job_queue_processes = 10
    background_dump_dest = /opt/oracle/admin/pd1perf/bdump
    user_dump_dest = /opt/oracle/admin/pd1perf/udump
    core_dump_dest = /opt/oracle/admin/pd1perf/cdump
    audit_file_dest = /opt/oracle/admin/pd1perf/adump
    db_name = pd1perf
    open_cursors = 300
    pga_aggregate_target = 203423744
    PMON started with pid=2, OS id=5427
    PSP0 started with pid=3, OS id=5429
    MMAN started with pid=4, OS id=5431
    DBW0 started with pid=5, OS id=5433
    LGWR started with pid=6, OS id=5435
    CKPT started with pid=7, OS id=5437
    SMON started with pid=8, OS id=5439
    RECO started with pid=9, OS id=5441
    CJQ0 started with pid=10, OS id=5443
    MMON started with pid=11, OS id=5445
    MMNL started with pid=12, OS id=5447
    Wed Apr 03 19:07:07 IST 2013
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    starting up 1 shared server(s) ...
    Oracle Data Guard is not available in this edition of Oracle.
    Wed Apr 03 19:07:07 IST 2013
    CREATE CONTROLFILE REUSE SET DATABASE "PD1PERF" RESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
    LOGFILE
    GROUP 1 '/opt/oracle/oradata/pd1perf/redo01.log' SIZE 50M,
    GROUP 2 '/opt/oracle/oradata/pd1perf/redo02.log' SIZE 50M,
    GROUP 3 '/opt/oracle/oradata/pd1perf/redo03.log' SIZE 50M
    DATAFILE
    '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF',
    '/opt/oracle/oradata/pd1perf/UNDOTBS01.DBF',
    '/opt/oracle/oradata/pd1perf/SYSAUX01.DBF',
    '/opt/oracle/oradata/pd1perf/USERS01.DBF'
    CHARACTER SET WE8MSWIN1252
    Wed Apr 03 19:07:07 IST 2013
    WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
    Default Temporary Tablespace will be necessary for a locally managed database in future release
    kcv_lh_or_upgrade: 10.2 upgrading 1 incarnations
    Setting recovery target incarnation to 1
    Wed Apr 03 19:07:18 IST 2013
    Successful mount of redo thread 1, with mount id 611616987
    Wed Apr 03 19:07:18 IST 2013
    Completed: CREATE CONTROLFILE REUSE SET DATABASE "PD1PERF" RESETLOGS ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
    LOGFILE
    GROUP 1 '/opt/oracle/oradata/pd1perf/redo01.log' SIZE 50M,
    GROUP 2 '/opt/oracle/oradata/pd1perf/redo02.log' SIZE 50M,
    GROUP 3 '/opt/oracle/oradata/pd1perf/redo03.log' SIZE 50M
    DATAFILE
    '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF',
    '/opt/oracle/oradata/pd1perf/UNDOTBS01.DBF',
    '/opt/oracle/oradata/pd1perf/SYSAUX01.DBF',
    '/opt/oracle/oradata/pd1perf/USERS01.DBF'
    CHARACTER SET WE8MSWIN1252
    Wed Apr 03 19:07:18 IST 2013
    ALTER DATABASE OPEN RESETLOGS
    ORA-1194 signalled during: ALTER DATABASE OPEN RESETLOGS...
    Wed Apr 03 19:07:18 IST 2013
    ALTER TABLESPACE TEMP ADD TEMPFILE '/opt/oracle/oradata/pd1perf/temp01.dbf'
    SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M
    ORA-1109 signalled during: ALTER TABLESPACE TEMP ADD TEMPFILE '/opt/oracle/oradata/pd1perf/temp01.dbf'
    SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M...
    Wed Apr 03 19:07:18 IST 2013
    Shutting down instance (immediate)
    Wed Apr 03 19:07:18 IST 2013
    Shutting down instance: further logons disabled
    Wed Apr 03 19:07:18 IST 2013
    Stopping background process MMNL
    Wed Apr 03 19:07:18 IST 2013
    Stopping background process CJQ0
    Wed Apr 03 19:07:19 IST 2013
    Stopping background process MMON
    License high water mark = 1
    Wed Apr 03 19:07:20 IST 2013
    Job queue slave processes stopped
    Waiting for dispatcher 'D000' to shutdown
    All dispatchers and shared servers shutdown
    Wed Apr 03 19:07:22 IST 2013
    ALTER DATABASE CLOSE NORMAL
    ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
    Wed Apr 03 19:07:22 IST 2013
    ALTER DATABASE DISMOUNT
    Completed: ALTER DATABASE DISMOUNT
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active
    ARCH: Archival disabled due to shutdown: 1089
    Shutting down archive processes
    Archiving is disabled
    Archive process shutdown avoided: 0 active
    Wed Apr 03 19:07:25 IST 2013
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    Picked latch-free SCN scheme 3
    IMODE=BR
    ILAT =18
    LICENSE_MAX_USERS = 0
    SYS auditing is disabled
    ksdpec: called for event 13740 prior to event group initialization
    Starting up ORACLE RDBMS Version: 10.2.0.5.0.
    System parameters with non-default values:
    processes = 150
    __shared_pool_size = 159383552
    __large_pool_size = 0
    __java_pool_size = 4194304
    __streams_pool_size = 0
    sga_target = 612368384
    control_files = /opt/oracle/oradata/pd1perf/control01.ctl, /opt/oracle/oradata/pd1perf/control02.ctl, /opt/oracle/oradata/pd1perf/control03.ctl
    db_block_size = 8192
    __db_cache_size = 440401920
    compatible = 10.2.0.1.0
    log_archive_dest_1 = LOCATION=/opt/oracle/flash_recovery_area/PD1PERF
    log_archive_format = pd1perf_%t_%s_%r.ARC
    db_file_multiblock_read_count= 16
    db_recovery_file_dest = /opt/oracle/flash_recovery_area/PD1PERF
    db_recovery_file_dest_size= 2147483648
    undo_management = AUTO
    undo_tablespace = UNDOTBS1
    remote_login_passwordfile= EXCLUSIVE
    db_domain =
    dispatchers = (PROTOCOL=TCP) (SERVICE=pd1perfXDB)
    job_queue_processes = 10
    background_dump_dest = /opt/oracle/admin/pd1perf/bdump
    user_dump_dest = /opt/oracle/admin/pd1perf/udump
    core_dump_dest = /opt/oracle/admin/pd1perf/cdump
    audit_file_dest = /opt/oracle/admin/pd1perf/adump
    db_name = pd1perf
    open_cursors = 300
    pga_aggregate_target = 203423744
    PMON started with pid=2, OS id=5457
    PSP0 started with pid=3, OS id=5459
    MMAN started with pid=4, OS id=5461
    DBW0 started with pid=5, OS id=5463
    LGWR started with pid=6, OS id=5465
    CKPT started with pid=7, OS id=5467
    SMON started with pid=8, OS id=5469
    RECO started with pid=9, OS id=5471
    CJQ0 started with pid=10, OS id=5473
    MMON started with pid=11, OS id=5475
    MMNL started with pid=12, OS id=5477
    Wed Apr 03 19:07:25 IST 2013
    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
    starting up 1 shared server(s) ...
    Oracle Data Guard is not available in this edition of Oracle.
    Wed Apr 03 19:07:25 IST 2013
    ALTER DATABASE MOUNT
    Wed Apr 03 19:07:29 IST 2013
    Setting recovery target incarnation to 1
    Wed Apr 03 19:07:29 IST 2013
    Successful mount of redo thread 1, with mount id 611612909
    Wed Apr 03 19:07:29 IST 2013
    Database mounted in Exclusive Mode
    Completed: ALTER DATABASE MOUNT
    Wed Apr 03 19:07:29 IST 2013
    ALTER DATABASE OPEN MIGRATE
    ORA-1589 signalled during: ALTER DATABASE OPEN MIGRATE...
  • 2. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    user11982706 Newbie
    Currently Being Moderated
    When you are recovering from backup controlfile like

    recover database using backup controlfile

    then if you still have your online redo logfiles, try to give one member from each log group one by one and see if that helps. Here is small part from one of post from my blog.
    SQL> recover database using backup controlfile;
     ORA-00279: change 1296686 generated at 02/20/2013 10:39:07 needed for thread 1
     ORA-00289: suggestion : /u05/oradata/CORE/CORE_DUP/CORE_DUP11807878344.ARC
     ORA-00280: change 1296686 for thread 1 is in sequence #1
     
    Specify log: {=suggested | filename | AUTO | CANCEL}
     /u02/oradata/CORE/CORE_DUP/redo01a.log
     Log applied.
     Media recovery complete.
     SQL> alter database open resetlogs;
     
    Database altered.
     
    SQL> select open_mode from v$database;
     
    OPEN_MODE
     ——————–
     READ WRITE
    Complete discussion can be found at http://orasteps.wordpress.com/2013/02/21/ora-30012-undo-tablespace-undotbs-does-not-exist-or-of-wrong-type/



    Thanks

    Yogesh
    http://orasteps.wordpress.com
  • 3. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    when i m trying its giving below error
    Control file created.

    ORA-00279: change 533272 generated at 04/03/2013 18:57:39 needed for thread 1
    ORA-00289: suggestion :
    /opt/oracle/flash_recovery_area/PD1PERF/PD1PERF/archivelog/2013_04_03/o1_mf_1_1_
    %u_.arc
    ORA-00280: change 533272 for thread 1 is in sequence #1


    ORA-00308: cannot open archived log
    '/opt/oracle/flash_recovery_area/PD1PERF/PD1PERF/archivelog/2013_04_03/o1_mf_1_1
    _%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    ALTER DATABASE OPEN RESETLOGS
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery if it was restored from backup, or END
    BACKUP if it was not
    ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'


    ALTER TABLESPACE TEMP ADD TEMPFILE '/opt/oracle/oradata/pd1perf/temp01.dbf'
    *
    ERROR at line 1:
    ORA-01109: database not open
  • 4. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    Thanks for your time and help

    when i m trying your option then getting below error


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    auto
    ORA-00308: cannot open archived log
    '/opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_7_811767306.ARC'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    ORA-00308: cannot open archived log
    '/opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_7_811767306.ARC'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    SQL> alter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery if it was restored from backup, or END
    BACKUP if it was not
    ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
  • 5. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    user11982706 Newbie
    Currently Being Moderated
    SANCHIT GUPTA  wrote:
    Thanks for your time and help

    when i m trying your option then getting below error


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    auto
    ORA-00308: cannot open archived log
    '/opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_7_811767306.ARC'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    ORA-00308: cannot open archived log
    '/opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_7_811767306.ARC'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3


    SQL> alter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery if it was restored from backup, or END
    BACKUP if it was not
    ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    you should try to apply the online redo logfile (if available) not the archived log file. You are trying to apply the archived log in your commands. '/opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_7_811767306.ARC' is a archive log not the online redo. I hope, you are getting my point....




    Thanks

    Yogesh
    http://orasteps.wordpress.com/
  • 6. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    Thanks for your time and help

    when i tried to apply online redo log then gives the below error:

    SQL> RECOVER DATABASE using backup controlfile ;
    ORA-00279: change 538714 generated at 04/04/2013 10:06:12 needed for thread 1
    ORA-00289: suggestion :
    /opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_1_811850757.ARC
    ORA-00280: change 538714 for thread 1 is in sequence #1


    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    /opt/oracle/oradata/pd1perf/redo01.log
    Log applied.
    Media recovery complete.
    SQL> alter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
  • 7. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    user11982706 Newbie
    Currently Being Moderated
    if you get error for first redo log file then try redo log file from another group. You need to try atleast one redo file from each group. Please update results.


    Thanks

    Yogesh
  • 8. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    Thanksh for your help and time Yogesh

    but i m getting same error after apply another rodo log group
  • 9. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    My problem is still pending, can anybody help


    Thanks in advance
  • 10. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    now its giving below error when i am trying to run transport script.... and after giving the error if i tried again then its give this error [data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF' ]. That means after run first time transport script i should not use again transport script on existing .dbf files.... again copy the .dbf files


    error:

    Thread: ORA-01092: ORACLE instance terminated. Disconnection forced

    Please give the solution of this ORA-01092 error
  • 11. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    saratpvv Journeyer
    Currently Being Moderated
    SQL> RECOVER DATABASE using backup controlfile ;
    ORA-00279: change 538714 generated at 04/04/2013 10:06:12 needed for thread 1
    ORA-00289: suggestion :
    /opt/oracle/flash_recovery_area/PD1PERF/pd1perf_1_1_811850757.ARC
    ORA-00280: change 538714 for thread 1 is in sequence #1
    You need to find the SCN 538714 in which online redo log it reside

    Hope below like will resolve ur issue

    http://damir-vadas.blogspot.in/2010/02/how-to-find-correct-scn.html
  • 12. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    Thanks for your help and time

    which sequence is requiring this is not generated yet on source because backup is uptodate...

    and my error is

    ora-01092 oracle instance terminated. disconnection forced
  • 13. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    saratpvv Journeyer
    Currently Being Moderated
    post last 20 lines from alert log file

    cat alert_log|tail -20

    what is ur version ?
  • 14. Re: ORA-01110: data file 1: '/opt/oracle/oradata/pd1perf/SYSTEM01.DBF'
    SANCHITGUPTA Newbie
    Currently Being Moderated
    Thanks for your quick reply

    database versions :
    window server 2003 : 10.2.0.1.0
    Linux 5 : 10.2.0.5.0


    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 2 of thread 1
    ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/pd1perf/redo02.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    Thu Apr 04 13:40:57 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 2 of thread 1
    ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/pd1perf/redo02.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    Thu Apr 04 13:40:57 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/pd1perf/redo03.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    Thu Apr 04 13:40:57 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/pd1perf/redo03.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    RESETLOGS after incomplete recovery UNTIL CHANGE 539302
    Thu Apr 04 13:40:57 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 1 of thread 1
    ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/pd1perf/redo01.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    Thu Apr 04 13:41:11 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 2 of thread 1
    ORA-00312: online log 2 thread 1: '/opt/oracle/oradata/pd1perf/redo02.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    Thu Apr 04 13:41:26 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00313: open failed for members of log group 3 of thread 1
    ORA-00312: online log 3 thread 1: '/opt/oracle/oradata/pd1perf/redo03.log'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    Thu Apr 04 13:41:40 IST 2013
    Setting recovery target incarnation to 2
    Thu Apr 04 13:41:40 IST 2013
    Assigning activation ID 611658978 (0x24752ce2)
    LGWR: STARTING ARCH PROCESSES
    ARC0 started with pid=16, OS id=30783
    Thu Apr 04 13:41:41 IST 2013
    ARC0: Archival started
    ARC1: Archival started
    LGWR: STARTING ARCH PROCESSES COMPLETE
    ARC1 started with pid=17, OS id=30785
    Thu Apr 04 13:41:41 IST 2013
    Thread 1 opened at log sequence 1
    Current log# 1 seq# 1 mem# 0: /opt/oracle/oradata/pd1perf/redo01.log
    Successful open of redo thread 1
    Thu Apr 04 13:41:41 IST 2013
    ARC0: Becoming the 'no FAL' ARCH
    ARC0: Becoming the 'no SRL' ARCH
    Thu Apr 04 13:41:41 IST 2013
    ARC1: Becoming the heartbeat ARCH
    Thu Apr 04 13:41:41 IST 2013
    SMON: enabling cache recovery
    Thu Apr 04 13:41:41 IST 2013
    Errors in file /opt/oracle/admin/pd1perf/udump/pd1perf_ora_30779.trc:
    ORA-00704: bootstrap process failure
    ORA-39700: database must be opened with UPGRADE option
    Thu Apr 04 13:41:41 IST 2013
    Error 704 happened during db open, shutting down database
    USER: terminating instance due to error 704
    Instance terminated by USER, pid = 30779
    ORA-1092 signalled during: ALTER DATABASE OPEN RESETLOGS...
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points