1 2 Previous Next 18 Replies Latest reply: Apr 4, 2013 9:40 AM by SANCHITGUPTA RSS

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

    SANCHITGUPTA
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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