Oracle Restore Corrupt - Veritas Net Backup

This is a discussion on Oracle Restore Corrupt - Veritas Net Backup ; I am backing up Oracle cold. Did a restore and got the following Oracle Error. Is there something that I am missing when I do a cold oracle backup/restore? alert_TEST.log Thu Jan 11 09:53:25 2001 Starting ORACLE instance (normal) LICENSE_MAX_SESSION ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Oracle Restore Corrupt

  1. Oracle Restore Corrupt


    I am backing up Oracle cold. Did a restore and got the following Oracle Error.
    Is there something that I am missing when I do a cold oracle backup/restore?

    alert_TEST.log
    Thu Jan 11 09:53:25 2001
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 8.0.5.1.0.
    System parameters with non-default values:
    _trace_files_public = TRUE
    processes = 400
    timed_statistics = FALSE
    shared_pool_size = 40000000
    shared_pool_reserved_size= 4000000
    enqueue_resources = 400
    nls_language = american
    nls_territory = america
    nls_sort = binary
    nls_date_format = DD-MON-RR
    nls_numeric_characters = .,
    disk_asynch_io = TRUE
    control_files = /ora_apps/d01/oradata/ORAUPI/cntrl01.ctl, /ora_apps/d02/oradata/ORAUPI/cntrl02.ctl,
    /ora_apps/d03/orada
    ta/ORAUPI/cntrl03.ctl
    db_block_buffers = 20000
    db_block_size = 8192
    db_block_lru_latches = 2
    log_buffer = 1024000
    log_checkpoint_interval = 99000000
    db_files = 200
    db_file_multiblock_read_count= 32
    dml_locks = 1000
    row_locking = always
    "alert_TEST.log" 23129 lines, 820586 characters
    Tue Dec 4 13:47:31 2001
    Database mounted in Exclusive Mode.
    Completed: ALTER DATABASE MOUNT
    Tue Dec 4 13:47:31 2001
    ALTER DATABASE OPEN
    Tue Dec 4 13:47:40 2001
    Thread 1 opened at log sequence 3
    Current log# 2 seq# 3 mem# 0: /ora_apps/oradata/ORAUPI/redo/log2a.dbf
    Successful open of redo thread 1.
    Tue Dec 4 13:47:40 2001
    SMON: enabling cache recovery
    SMON: enabling tx recovery
    Tue Dec 4 13:47:40 2001
    Updating 8.1.7.1.0 NLS parameters in sys.props$
    -- adding 8.1.7.1.0 NLS parameters.
    ***
    Corrupt block relative dba: 0x0041089e (file 1, block 67742)
    Bad check value found during buffer read
    Data in bad block -
    type: 6 format: 2 rdba: 0x0041089e
    last change scn: 0x0000.05c5dd91 seq: 0x1 flg: 0x06
    consistency value in tail: 0xdd910601
    check value in block header: 0xbe4, computed block checksum: 0x8
    spare1: 0x0, spare2: 0x0, spare3: 0x0
    ***
    Reread of rdba: 0x0041089e (file 1, block 67742) found same corrupted data
    ***
    Corrupt block relative dba: 0x0040147f (file 1, block 5247)
    Bad check value found during buffer read
    Data in bad block -
    type: 6 format: 2 rdba: 0x0040147f
    last change scn: 0x0000.0612dd7f seq: 0x1 flg: 0x06
    consistency value in tail: 0xdd7f0601
    check value in block header: 0xbf8f, computed block checksum: 0x8
    spare1: 0x0, spare2: 0x0, spare3: 0x0
    ***
    Reread of rdba: 0x0040147f (file 1, block 5247) found same corrupted data
    Tue Dec 4 13:47:44 2001
    Errors in file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 5247)
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    SMON: disabling cache recovery
    Tue Dec 4 13:47:44 2001
    Errors in file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    Tue Dec 4 13:47:44 2001
    Errors in file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    Tue Dec 4 13:47:44 2001
    ORA-604 signalled during: ALTER DATABASE OPEN...
    Tue Dec 4 13:47:44 2001
    Errors in file /upid01/app/oraupi/admin/ORAUPI/udump/ora_23096_test.trc:
    ORA-00376: file 86 cannot be read at this time
    ORA-01110: data file 86: '/ora_apps/oradata/ORAUPI/rbs02.dbf'
    ORA-00376: file 86 cannot be read at this time
    ORA-01110: data file 86: '/ora_apps/oradata/ORAUPI/rbs02.dbf'
    ORA-00604: error occurred at recursive SQL level 1

    Dump file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc
    Oracle8i Enterprise Edition Release 8.1.7.1.0 - 64bit Production
    JServer Release 8.1.7.1.0 - 64bit Production
    ORACLE_HOME = /upid01/app/oraupi/product/817
    System name: HP-UX
    Node name: upi_demo
    Release: B.11.00
    Version: A
    Machine: 9000/800
    Instance name: TEST
    Redo thread mounted by this instance: 1
    Oracle process number: 6
    Unix process pid: 23091, image: oracle@upi_demo (SMON)

    *** SESSION ID5.1) 2001-12-04 13:47:44.488
    ***
    Corrupt block relative dba: 0x0040147f (file 1, block 5247)
    Bad check value found during buffer read
    Data in bad block -
    type: 6 format: 2 rdba: 0x0040147f
    last change scn: 0x0000.0612dd7f seq: 0x1 flg: 0x06
    consistency value in tail: 0xdd7f0601
    check value in block header: 0xbf8f, computed block checksum: 0x8
    spare1: 0x0, spare2: 0x0, spare3: 0x0
    ***
    Reread of rdba: 0x0040147f (file 1, block 5247) found same corrupted data
    *** 2001-12-04 13:47:44.501
    SMON: following errors trapped and ignored:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01578: ORACLE data block corrupted (file # 1, block # 5247)
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:47:44.512
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:47:44.512
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:47:45.550
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:47:46.580
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    ================================================== =
    PROCESS STATE
    -------------
    Process global information:
    process: c00000000fe421b0, call: c00000000ffb8a90, xact: 0, curses:
    c00000000feb1440, usrses: c00000000feb1440
    ----------------------------------------
    SO: c00000000fe421b0, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
    (process) Oracle pid=6, calls cur/top: c00000000ffb8a90/c00000000ffb8a90,
    flag: (a) SYSTEM
    int error: 0, call error: 0, sess error: 0, txn error 0
    (post info) last post received: 0 0 50
    last post received-location: ktmchg
    last process to post me: c00000000fe42e40 1 0
    last post sent: 129 0 4
    last post sent-location: kslpsr
    last process posted by me: c00000000fe42e40 1 0
    (latch info) wait_event=0 bits=0
    Process Group: DEFAULT, pseudo proc: c00000000fea9558
    O/S info: user: oraupi, term: UNKNOWN, ospid: 23091
    OSD pid info: 23091
    ----------------------------------------
    SO: c0000000101565b0, type: 9, owner: c00000000fe421b0, pt: 0, flag:
    INIT/-/-/0x00
    (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: c00000000fe421b0,
    event: 5, last message event: 8, messages read: 1
    channel: (c0000000101570f0) scumnt mount lock
    scope: 101, event: 8, last mesage event:
    8,
    publishers/subscribers: 1/6,
    messages published: 1
    ----------------------------------------
    SO: c00000000feb1440, type: 3, owner: c00000000fe421b0, pt: 0, flag:
    INIT/-/-/0x00
    (session) trans: 0, creator: c00000000fe421b0, flag: (51) USR/- BSY/-/-/-/-/-
    DID: 0001-0006-00000002, short-term DID: 0000-0000-00000000
    txn branch: 0
    oct: 0, prv: 0, user: 0/SYS
    last wait for 'control file sequential read' blocking sess=0x0 seq=297
    wait_time=-1
    file#=0, block#=32, blocks=1
    ----------------------------------------
    SO: c000000010156680, type: 9, owner: c00000000fe421b0, pt: 0, flag:
    INIT/-/-/0x00
    (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: c00000000fe421b0,
    event: 6, last message event: 6, messages read: 0
    channel: (c000000010156fb0) system events broadcast
    channel
    scope: 101, event: 9, last mesage event:
    0,
    publishers/subscribers: 0/8,
    messages published: 0
    ----------------------------------------
    SO: c00000000ffb8a90, type: 2, owner: c00000000fe421b0, pt: 0, flag:
    INIT/-/-/0x00
    (call) sess: cur c00000000feb1440, rec 0, usr c00000000feb1440; depth:
    0
    ================================================== =
    CURRENT SESSION'S INSTANTIATION STATE
    -------------------------------------
    current session=c00000000feb1440
    ******************** Cursor Dump ************************
    Current cursor: 0, pgadep: 0
    Cursor Dump:
    End of cursor dump
    END OF PROCESS STATE
    *** 2001-12-04 13:47:56.870
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:48:07.120
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:48:17.370
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:48:27.620
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:48:37.870
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:48:48.160
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:48:58.410
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:49:08.660
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:49:18.910
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:49:29.160
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:49:39.410
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:49:49.660
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:49:59.910
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:50:10.160
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    *** 2001-12-04 13:50:20.410
    SMON: following errors trapped and ignored:
    ORA-00376: file 1 cannot be read at this time
    ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'



  2. Re: Oracle Restore Corrupt

    Have you daone a database recover ?
    Mount the database manually (startup mount)
    then type recover database in the svrmgrl prompt. Make sure that all erdo
    and archive logs are in place.

    When the operation finishes open the database (alter database open).

    Good luck.

    "Marcellus Barrus" wrote in message
    news:3c1fccdc$1@hronntp01....
    >
    > I am backing up Oracle cold. Did a restore and got the following Oracle

    Error.
    > Is there something that I am missing when I do a cold oracle

    backup/restore?
    >
    > alert_TEST.log
    > Thu Jan 11 09:53:25 2001
    > Starting ORACLE instance (normal)
    > LICENSE_MAX_SESSION = 0
    > LICENSE_SESSIONS_WARNING = 0
    > LICENSE_MAX_USERS = 0
    > Starting up ORACLE RDBMS Version: 8.0.5.1.0.
    > System parameters with non-default values:
    > _trace_files_public = TRUE
    > processes = 400
    > timed_statistics = FALSE
    > shared_pool_size = 40000000
    > shared_pool_reserved_size= 4000000
    > enqueue_resources = 400
    > nls_language = american
    > nls_territory = america
    > nls_sort = binary
    > nls_date_format = DD-MON-RR
    > nls_numeric_characters = .,
    > disk_asynch_io = TRUE
    > control_files = /ora_apps/d01/oradata/ORAUPI/cntrl01.ctl,

    /ora_apps/d02/oradata/ORAUPI/cntrl02.ctl,
    > /ora_apps/d03/orada
    > ta/ORAUPI/cntrl03.ctl
    > db_block_buffers = 20000
    > db_block_size = 8192
    > db_block_lru_latches = 2
    > log_buffer = 1024000
    > log_checkpoint_interval = 99000000
    > db_files = 200
    > db_file_multiblock_read_count= 32
    > dml_locks = 1000
    > row_locking = always
    > "alert_TEST.log" 23129 lines, 820586 characters
    > Tue Dec 4 13:47:31 2001
    > Database mounted in Exclusive Mode.
    > Completed: ALTER DATABASE MOUNT
    > Tue Dec 4 13:47:31 2001
    > ALTER DATABASE OPEN
    > Tue Dec 4 13:47:40 2001
    > Thread 1 opened at log sequence 3
    > Current log# 2 seq# 3 mem# 0: /ora_apps/oradata/ORAUPI/redo/log2a.dbf
    > Successful open of redo thread 1.
    > Tue Dec 4 13:47:40 2001
    > SMON: enabling cache recovery
    > SMON: enabling tx recovery
    > Tue Dec 4 13:47:40 2001
    > Updating 8.1.7.1.0 NLS parameters in sys.props$
    > -- adding 8.1.7.1.0 NLS parameters.
    > ***
    > Corrupt block relative dba: 0x0041089e (file 1, block 67742)
    > Bad check value found during buffer read
    > Data in bad block -
    > type: 6 format: 2 rdba: 0x0041089e
    > last change scn: 0x0000.05c5dd91 seq: 0x1 flg: 0x06
    > consistency value in tail: 0xdd910601
    > check value in block header: 0xbe4, computed block checksum: 0x8
    > spare1: 0x0, spare2: 0x0, spare3: 0x0
    > ***
    > Reread of rdba: 0x0041089e (file 1, block 67742) found same corrupted data
    > ***
    > Corrupt block relative dba: 0x0040147f (file 1, block 5247)
    > Bad check value found during buffer read
    > Data in bad block -
    > type: 6 format: 2 rdba: 0x0040147f
    > last change scn: 0x0000.0612dd7f seq: 0x1 flg: 0x06
    > consistency value in tail: 0xdd7f0601
    > check value in block header: 0xbf8f, computed block checksum: 0x8
    > spare1: 0x0, spare2: 0x0, spare3: 0x0
    > ***
    > Reread of rdba: 0x0040147f (file 1, block 5247) found same corrupted data
    > Tue Dec 4 13:47:44 2001
    > Errors in file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc:
    > ORA-00604: error occurred at recursive SQL level 1
    > ORA-01578: ORACLE data block corrupted (file # 1, block # 5247)
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > SMON: disabling cache recovery
    > Tue Dec 4 13:47:44 2001
    > Errors in file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > Tue Dec 4 13:47:44 2001
    > Errors in file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > Tue Dec 4 13:47:44 2001
    > ORA-604 signalled during: ALTER DATABASE OPEN...
    > Tue Dec 4 13:47:44 2001
    > Errors in file /upid01/app/oraupi/admin/ORAUPI/udump/ora_23096_test.trc:
    > ORA-00376: file 86 cannot be read at this time
    > ORA-01110: data file 86: '/ora_apps/oradata/ORAUPI/rbs02.dbf'
    > ORA-00376: file 86 cannot be read at this time
    > ORA-01110: data file 86: '/ora_apps/oradata/ORAUPI/rbs02.dbf'
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > Dump file /upid01/app/oraupi/admin/ORAUPI/bdump/smon_23091_test.trc
    > Oracle8i Enterprise Edition Release 8.1.7.1.0 - 64bit Production
    > JServer Release 8.1.7.1.0 - 64bit Production
    > ORACLE_HOME = /upid01/app/oraupi/product/817
    > System name: HP-UX
    > Node name: upi_demo
    > Release: B.11.00
    > Version: A
    > Machine: 9000/800
    > Instance name: TEST
    > Redo thread mounted by this instance: 1
    > Oracle process number: 6
    > Unix process pid: 23091, image: oracle@upi_demo (SMON)
    >
    > *** SESSION ID5.1) 2001-12-04 13:47:44.488
    > ***
    > Corrupt block relative dba: 0x0040147f (file 1, block 5247)
    > Bad check value found during buffer read
    > Data in bad block -
    > type: 6 format: 2 rdba: 0x0040147f
    > last change scn: 0x0000.0612dd7f seq: 0x1 flg: 0x06
    > consistency value in tail: 0xdd7f0601
    > check value in block header: 0xbf8f, computed block checksum: 0x8
    > spare1: 0x0, spare2: 0x0, spare3: 0x0
    > ***
    > Reread of rdba: 0x0040147f (file 1, block 5247) found same corrupted data
    > *** 2001-12-04 13:47:44.501
    > SMON: following errors trapped and ignored:
    > ORA-00604: error occurred at recursive SQL level 1
    > ORA-01578: ORACLE data block corrupted (file # 1, block # 5247)
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:47:44.512
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:47:44.512
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:47:45.550
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:47:46.580
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > ================================================== =
    > PROCESS STATE
    > -------------
    > Process global information:
    > process: c00000000fe421b0, call: c00000000ffb8a90, xact: 0, curses:
    > c00000000feb1440, usrses: c00000000feb1440
    > ----------------------------------------
    > SO: c00000000fe421b0, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
    > (process) Oracle pid=6, calls cur/top:

    c00000000ffb8a90/c00000000ffb8a90,
    > flag: (a) SYSTEM
    > int error: 0, call error: 0, sess error: 0, txn error 0
    > (post info) last post received: 0 0 50
    > last post received-location: ktmchg
    > last process to post me: c00000000fe42e40 1 0
    > last post sent: 129 0 4
    > last post sent-location: kslpsr
    > last process posted by me: c00000000fe42e40 1 0
    > (latch info) wait_event=0 bits=0
    > Process Group: DEFAULT, pseudo proc: c00000000fea9558
    > O/S info: user: oraupi, term: UNKNOWN, ospid: 23091
    > OSD pid info: 23091
    > ----------------------------------------
    > SO: c0000000101565b0, type: 9, owner: c00000000fe421b0, pt: 0, flag:
    > INIT/-/-/0x00
    > (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner:

    c00000000fe421b0,
    > event: 5, last message event: 8, messages read: 1
    > channel: (c0000000101570f0) scumnt mount lock
    > scope: 101, event: 8, last mesage event:
    > 8,
    > publishers/subscribers: 1/6,
    > messages published: 1
    > ----------------------------------------
    > SO: c00000000feb1440, type: 3, owner: c00000000fe421b0, pt: 0, flag:
    > INIT/-/-/0x00
    > (session) trans: 0, creator: c00000000fe421b0, flag: (51) USR/-

    BSY/-/-/-/-/-
    > DID: 0001-0006-00000002, short-term DID: 0000-0000-00000000
    > txn branch: 0
    > oct: 0, prv: 0, user: 0/SYS
    > last wait for 'control file sequential read' blocking sess=0x0 seq=297
    > wait_time=-1
    > file#=0, block#=32, blocks=1
    > ----------------------------------------
    > SO: c000000010156680, type: 9, owner: c00000000fe421b0, pt: 0, flag:
    > INIT/-/-/0x00
    > (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner:

    c00000000fe421b0,
    > event: 6, last message event: 6, messages read: 0
    > channel: (c000000010156fb0) system events broadcast
    > channel
    > scope: 101, event: 9, last mesage event:
    > 0,
    > publishers/subscribers: 0/8,
    > messages published: 0
    > ----------------------------------------
    > SO: c00000000ffb8a90, type: 2, owner: c00000000fe421b0, pt: 0, flag:
    > INIT/-/-/0x00
    > (call) sess: cur c00000000feb1440, rec 0, usr c00000000feb1440; depth:
    > 0
    > ================================================== =
    > CURRENT SESSION'S INSTANTIATION STATE
    > -------------------------------------
    > current session=c00000000feb1440
    > ******************** Cursor Dump ************************
    > Current cursor: 0, pgadep: 0
    > Cursor Dump:
    > End of cursor dump
    > END OF PROCESS STATE
    > *** 2001-12-04 13:47:56.870
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:48:07.120
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:48:17.370
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:48:27.620
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:48:37.870
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:48:48.160
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:48:58.410
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:49:08.660
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:49:18.910
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:49:29.160
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:49:39.410
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:49:49.660
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:49:59.910
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:50:10.160
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    > *** 2001-12-04 13:50:20.410
    > SMON: following errors trapped and ignored:
    > ORA-00376: file 1 cannot be read at this time
    > ORA-01110: data file 1: '/ora_apps/oradata/ORAUPI/system01.dbf'
    >
    >




+ Reply to Thread