11 Replies Latest reply on Jun 28, 2006 11:38 AM by 520180

    Error  backing up Oracle Express Edition

    520180
      Hi,

      When I try and back up Oracle XE I get the following message:

      Backup of the database failed.
      Unknown log mode: SP2 - 0640
      Log file is at SP2-0640

      I have turned on the ARCHIVELOG, can't see anything else wrong.

      /John
        • 1. Re: Error  backing up Oracle Express Edition
          ennisb
          What process did you follow to turn on archivelog mode?

          Is there any additional info in the alertlog?
          • 2. Re: Error  backing up Oracle Express Edition
            520180
            Hi Bill,

            This is how I turned on the Archive log mode (from the DBA guide):

            To turn on ARCHIVELOG mode:
            1.Using SQL Command Line, log in to the database and connect as SYSDBA
            2.At the SQL Command Line prompt, enter the following command:
            SHUTDOWN IMMEDIATE
            If the command is successful, it displays the following output.
            Database closed.
            Database dismounted.
            ORACLE instance shut down.
            3.At the SQL Command Line prompt, enter the following command:
            STARTUP MOUNT
            If the command is successful, it displays the following output.
            (System global area sizes will vary depending on the amount of physical memory in
            your Oracle Database XE host computer.)
            ORACLE instance started.
            Total System Global Area 599785472 bytes
            Fixed Size 1220804 bytes
            Variable Size 180358972 bytes
            Database Buffers 415236096 bytes
            Redo Buffers 2969600 bytes
            Database mounted.
            Enter the following command:
            ALTER DATABASE ARCHIVELOG;
            If the command is successful, it displays the following output:
            Database altered.
            Enter the following command:
            ALTER DATABASE OPEN;
            If the command is successful, it displays the following output:
            Database altered.
            The database is now running with the new ARCHIVELOG mode setting.

            I don't know where to find the alert log.

            /John
            • 3. Re: Error  backing up Oracle Express Edition
              AlokKumar
              In order to configure your database to run in archivelog mode , you need to set few parameters in pfile as well , these are ...

              archive_log_start = true
              log_archive_dest = 'd:\oracle\bckup'
              log_archive_format = %s.arc"

              you can find alertlog file in oracle_home\admin\bdump directory.

              hare krishna
              Alok
              • 4. Re: Error  backing up Oracle Express Edition
                520180
                Hi,

                Sorry, I am totally new to this... where is the pfile? I found a folder on Oracle root called pfile but it had nothing in it.

                /John
                • 5. Re: Error  backing up Oracle Express Edition
                  ennisb
                  Alok is correct in that you need to confiure some additional parameters for archiving to work properly. Make sure that whatever you set log_archive_dest to exists.

                  The alertlog is set to write to whatever the background_dump_dest is set to. Connect to sqlplus as you posted and issue the folling command:

                  SQL> show parameter background_dump_dest
                  • 6. Re: Error  backing up Oracle Express Edition
                    520180
                    I put in the command and the output exists, this is the contents of the alert log:

                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Tue Jun 06 10:40:28 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:422M/887M, Ph+PgF:797M/1018M, VA:1945M/2047M
                    Tue Jun 06 10:40:28 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Shared memory segment for instance monitoring created
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PSP0 started with pid=3, OS id=2812
                    PMON started with pid=2, OS id=2800
                    MMAN started with pid=4, OS id=2792
                    DBW0 started with pid=5, OS id=2752
                    LGWR started with pid=6, OS id=2748
                    CKPT started with pid=7, OS id=2996
                    SMON started with pid=8, OS id=2684
                    RECO started with pid=9, OS id=2688
                    CJQ0 started with pid=10, OS id=2692
                    MMON started with pid=11, OS id=2696
                    MMNL started with pid=12, OS id=2712
                    Tue Jun 06 10:40:32 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Tue Jun 06 10:40:36 2006
                    The input backup piece D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\CONFIG\SEEDDB\EXPRESS.DFB is in compressed format.
                    Tue Jun 06 10:41:06 2006
                    Full restore complete of datafile 4 to datafile copy D:\ORACLEXE\ORADATA\XE\USERS.DBF. Elapsed time: 0:00:29
                    checkpoint is 193065
                    Full restore complete of datafile 2 to datafile copy D:\ORACLEXE\ORADATA\XE\UNDO.DBF. Elapsed time: 0:00:31
                    checkpoint is 193065
                    Tue Jun 06 10:41:22 2006
                    Full restore complete of datafile 3 to datafile copy D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF. Elapsed time: 0:00:46
                    checkpoint is 193065
                    Full restore complete of datafile 1 to datafile copy D:\ORACLEXE\ORADATA\XE\SYSTEM.DBF. Elapsed time: 0:00:53
                    checkpoint is 193065
                    Tue Jun 06 10:41:29 2006
                    Create controlfile reuse set database "XE"
                    MAXINSTANCES 8
                    MAXLOGHISTORY 1
                    MAXLOGFILES 16
                    MAXLOGMEMBERS 3
                    MAXDATAFILES 100
                    Datafile
                    'D:\oraclexe\oradata\XE\system.dbf',
                    'D:\oraclexe\oradata\XE\undo.dbf',
                    'D:\oraclexe\oradata\XE\sysaux.dbf',
                    'D:\oraclexe\oradata\XE\users.dbf'
                    LOGFILE
                    GROUP 1 SIZE 51200K,
                    GROUP 2 SIZE 51200K,
                    RESETLOGS
                    WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
                    Default Temporary Tablespace will be necessary for a locally managed database in future release
                    Setting recovery target incarnation to 1
                    Tue Jun 06 10:41:30 2006
                    Successful mount of redo thread 1, with mount id 2473529113
                    Tue Jun 06 10:41:30 2006
                    Completed: Create controlfile reuse set database "XE"
                    MAXINSTANCES 8
                    MAXLOGHISTORY 1
                    MAXLOGFILES 16
                    MAXLOGMEMBERS 3
                    MAXDATAFILES 100
                    Datafile
                    'D:\oraclexe\oradata\XE\system.dbf',
                    'D:\oraclexe\oradata\XE\undo.dbf',
                    'D:\oraclexe\oradata\XE\sysaux.dbf',
                    'D:\oraclexe\oradata\XE\users.dbf'
                    LOGFILE
                    GROUP 1 SIZE 51200K,
                    GROUP 2 SIZE 51200K,
                    RESETLOGS
                    Shutting down instance: further logons disabled
                    Tue Jun 06 10:41:30 2006
                    Stopping background process CJQ0
                    Tue Jun 06 10:41:30 2006
                    Stopping background process MMNL
                    Tue Jun 06 10:41:31 2006
                    Stopping background process MMON
                    Tue Jun 06 10:41:31 2006
                    Shutting down instance (immediate)
                    License high water mark = 1
                    Tue Jun 06 10:41:31 2006
                    Stopping Job queue slave processes
                    Tue Jun 06 10:41:31 2006
                    Job queue slave processes stopped
                    Waiting for dispatcher 'D000' to shutdown
                    All dispatchers and shared servers shutdown
                    Tue Jun 06 10:41:32 2006
                    ALTER DATABASE CLOSE NORMAL
                    ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
                    Tue Jun 06 10:41:32 2006
                    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
                    Tue Jun 06 10:41:35 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=3232
                    PSP0 started with pid=3, OS id=3216
                    MMAN started with pid=4, OS id=3240
                    DBW0 started with pid=5, OS id=3236
                    LGWR started with pid=6, OS id=3252
                    CKPT started with pid=7, OS id=3264
                    SMON started with pid=8, OS id=3260
                    RECO started with pid=9, OS id=2412
                    MMON started with pid=10, OS id=3380
                    MMNL started with pid=11, OS id=3376
                    Tue Jun 06 10:41:35 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Tue Jun 06 10:41:36 2006
                    Create controlfile reuse set database "XE"
                    MAXINSTANCES 8
                    MAXLOGHISTORY 1
                    MAXLOGFILES 16
                    MAXLOGMEMBERS 3
                    MAXDATAFILES 100
                    Datafile
                    'D:\oraclexe\oradata\XE\system.dbf',
                    'D:\oraclexe\oradata\XE\undo.dbf',
                    'D:\oraclexe\oradata\XE\sysaux.dbf',
                    'D:\oraclexe\oradata\XE\users.dbf'
                    LOGFILE
                    GROUP 1 SIZE 51200K,
                    GROUP 2 SIZE 51200K,
                    RESETLOGS
                    Tue Jun 06 10:41:36 2006
                    WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
                    Default Temporary Tablespace will be necessary for a locally managed database in future release
                    Setting recovery target incarnation to 1
                    Tue Jun 06 10:41:36 2006
                    Successful mount of redo thread 1, with mount id 2473564704
                    Tue Jun 06 10:41:36 2006
                    Completed: Create controlfile reuse set database "XE"
                    MAXINSTANCES 8
                    MAXLOGHISTORY 1
                    MAXLOGFILES 16
                    MAXLOGMEMBERS 3
                    MAXDATAFILES 100
                    Datafile
                    'D:\oraclexe\oradata\XE\system.dbf',
                    'D:\oraclexe\oradata\XE\undo.dbf',
                    'D:\oraclexe\oradata\XE\sysaux.dbf',
                    'D:\oraclexe\oradata\XE\users.dbf'
                    LOGFILE
                    GROUP 1 SIZE 51200K,
                    GROUP 2 SIZE 51200K,
                    RESETLOGS
                    Tue Jun 06 10:41:36 2006
                    Stopping background process MMNL
                    Tue Jun 06 10:41:36 2006
                    Stopping background process MMON
                    Starting background process MMON
                    Starting background process MMNL
                    MMON started with pid=10, OS id=3412
                    MMNL started with pid=11, OS id=3372
                    Tue Jun 06 10:41:36 2006
                    ALTER SYSTEM enable restricted session;
                    Tue Jun 06 10:41:36 2006
                    alter database "XE" open resetlogs
                    Tue Jun 06 10:41:36 2006
                    RESETLOGS after incomplete recovery UNTIL CHANGE 193065
                    Tue Jun 06 10:41:37 2006
                    Errors in file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_2784.trc:
                    ORA-00313: open failed for members of log group 1 of thread 1

                    db_recovery_file_dest_size of 10240 MB is 0.49% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Tue Jun 06 10:41:38 2006
                    Errors in file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_2784.trc:
                    ORA-00313: open failed for members of log group 2 of thread 1

                    Tue Jun 06 10:41:39 2006
                    Errors in file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_2784.trc:
                    ORA-00313: open failed for members of log group 3 of thread 1

                    Tue Jun 06 10:41:43 2006
                    Setting recovery target incarnation to 2
                    Tue Jun 06 10:41:43 2006
                    Assigning activation ID 2473564704 (0x936f9a20)
                    Thread 1 opened at log sequence 1
                    Current log# 3 seq# 1 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_28BMGMQR_.LOG
                    Successful open of redo thread 1
                    Tue Jun 06 10:41:43 2006
                    SMON: enabling cache recovery
                    Tue Jun 06 10:41:46 2006
                    Successfully onlined Undo Tablespace 1.
                    Dictionary check beginning
                    Tablespace 'TEMP' #3 found in data dictionary,
                    but not in the controlfile. Adding to controlfile.
                    Dictionary check complete
                    Tue Jun 06 10:41:46 2006
                    SMON: enabling tx recovery
                    Tue Jun 06 10:41:46 2006
                    *********************************************************************
                    WARNING: The following temporary tablespaces contain no files.
                    This condition can occur when a backup controlfile has
                    been restored. It may be necessary to add files to these
                    tablespaces. That can be done using the SQL statement:

                    ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

                    Alternatively, if these temporary tablespaces are no longer
                    needed, then they can be dropped.
                    Empty temporary tablespace: TEMP
                    *********************************************************************
                    Updating character set in controlfile to WE8MSWIN1252
                    **********************************************************
                    WARNING: Files may exists in db_recovery_file_dest
                    that are not known to the database. Use the RMAN command
                    CATALOG RECOVERY AREA to re-catalog any such files.
                    One of the following events caused this:
                    1. A backup controlfile was restored.
                    2. A standby controlfile was restored.
                    3. The controlfile was re-created.
                    4. db_recovery_file_dest had previously been enabled and
                    then disabled.
                    **********************************************************
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=18, OS id=3424
                    Tue Jun 06 10:41:50 2006
                    LOGSTDBY: Validating controlfile with logical metadata
                    Tue Jun 06 10:41:50 2006
                    LOGSTDBY: Validation complete
                    Global Name changed to XE
                    Completed: alter database "XE" open resetlogs
                    Tue Jun 06 10:41:53 2006
                    alter database rename global_name to "XE"
                    Completed: alter database rename global_name to "XE"
                    Tue Jun 06 10:41:53 2006
                    Thread 1 advanced to log sequence 2
                    Current log# 1 seq# 2 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Tue Jun 06 10:41:53 2006
                    alter database drop logfile group 3
                    Tue Jun 06 10:41:54 2006
                    Deleted Oracle managed file D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_3_28BMGMQR_.LOG
                    Completed: alter database drop logfile group 3
                    Tue Jun 06 10:41:54 2006
                    ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oraclexe\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
                    Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oraclexe\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
                    Tue Jun 06 10:41:58 2006
                    ALTER SYSTEM disable restricted session;
                    Tue Jun 06 10:42:02 2006
                    Starting background process CJQ0
                    CJQ0 started with pid=17, OS id=3488
                    Tue Jun 06 10:42:12 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2289K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Tue Jun 06 10:42:13 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2254K exceeds notification threshold (2048K)
                    Details in trace file d:\oraclexe\app\oracle\admin\xe\udump\xe_ora_3400.trc
                    KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

                    Tue Jun 06 10:42:16 2006
                    Shutting down instance: further logons disabled
                    Tue Jun 06 10:42:17 2006
                    Stopping background process CJQ0
                    Tue Jun 06 10:42:17 2006
                    Stopping background process QMNC
                    Tue Jun 06 10:42:18 2006
                    Stopping background process MMNL
                    Tue Jun 06 10:42:19 2006
                    Stopping background process MMON
                    Tue Jun 06 10:42:20 2006
                    Shutting down instance (immediate)
                    License high water mark = 2
                    Waiting for dispatcher 'D000' to shutdown
                    All dispatchers and shared servers shutdown
                    Tue Jun 06 10:42:21 2006
                    ALTER DATABASE CLOSE NORMAL
                    Tue Jun 06 10:42:22 2006
                    SMON: disabling tx recovery
                    SMON: disabling cache recovery
                    Tue Jun 06 10:42:22 2006
                    Shutting down archive processes
                    Archiving is disabled
                    Archive process shutdown avoided: 0 active
                    Thread 1 closed at log sequence 2
                    Successful close of redo thread 1
                    Tue Jun 06 10:42:23 2006
                    Completed: ALTER DATABASE CLOSE NORMAL
                    Tue Jun 06 10:42:23 2006
                    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
                    Tue Jun 06 10:42:25 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=3616
                    PSP0 started with pid=3, OS id=3720
                    MMAN started with pid=4, OS id=3624
                    DBW0 started with pid=5, OS id=3584
                    LGWR started with pid=6, OS id=3724
                    CKPT started with pid=7, OS id=3728
                    SMON started with pid=8, OS id=3732
                    RECO started with pid=9, OS id=3716
                    CJQ0 started with pid=10, OS id=3712
                    MMON started with pid=11, OS id=3744
                    MMNL started with pid=12, OS id=3740
                    Tue Jun 06 10:42:25 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Tue Jun 06 10:42:26 2006
                    ALTER DATABASE MOUNT
                    Tue Jun 06 10:42:30 2006
                    Setting recovery target incarnation to 2
                    Tue Jun 06 10:42:30 2006
                    Successful mount of redo thread 1, with mount id 2473504594
                    Tue Jun 06 10:42:30 2006
                    Database mounted in Exclusive Mode
                    Completed: ALTER DATABASE MOUNT
                    Tue Jun 06 10:42:30 2006
                    ALTER DATABASE OPEN
                    Tue Jun 06 10:42:30 2006
                    Thread 1 opened at log sequence 2
                    Current log# 1 seq# 2 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Successful open of redo thread 1
                    Tue Jun 06 10:42:31 2006
                    SMON: enabling cache recovery
                    Tue Jun 06 10:42:33 2006
                    Successfully onlined Undo Tablespace 1.
                    Tue Jun 06 10:42:33 2006
                    SMON: enabling tx recovery
                    Tue Jun 06 10:42:33 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=18, OS id=4036
                    Tue Jun 06 10:42:37 2006
                    Completed: ALTER DATABASE OPEN
                    Tue Jun 06 10:42:39 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Tue Jun 06 10:43:22 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2196K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Tue Jun 06 10:43:23 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2145K exceeds notification threshold (2048K)
                    Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_3588.trc
                    KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

                    Tue Jun 06 10:43:46 2006
                    Starting ORACLE instance (normal)
                    Wed Jun 07 11:00:23 2006
                    Thread 1 advanced to log sequence 3
                    Current log# 2 seq# 3 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Thu Jun 08 22:17:01 2006
                    Thread 1 advanced to log sequence 4
                    Current log# 1 seq# 4 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Sat Jun 10 20:30:14 2006
                    Thread 1 advanced to log sequence 5
                    Current log# 2 seq# 5 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Mon Jun 12 22:01:31 2006
                    Thread 1 advanced to log sequence 6
                    Current log# 1 seq# 6 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Tue Jun 13 17:22:53 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:662M/887M, Ph+PgF:878M/1018M, VA:1944M/2047M
                    Tue Jun 13 17:22:53 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=288
                    PSP0 started with pid=3, OS id=2044
                    MMAN started with pid=4, OS id=252
                    DBW0 started with pid=5, OS id=312
                    LGWR started with pid=6, OS id=316
                    CKPT started with pid=7, OS id=320
                    SMON started with pid=8, OS id=324
                    RECO started with pid=9, OS id=336
                    CJQ0 started with pid=10, OS id=340
                    MMON started with pid=11, OS id=344
                    Tue Jun 13 17:23:00 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    MMNL started with pid=12, OS id=348
                    Tue Jun 13 17:23:00 2006
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Tue Jun 13 17:23:04 2006
                    alter database mount exclusive
                    Tue Jun 13 17:23:09 2006
                    Setting recovery target incarnation to 2
                    Tue Jun 13 17:23:10 2006
                    Successful mount of redo thread 1, with mount id 2474154680
                    Tue Jun 13 17:23:10 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Tue Jun 13 17:23:10 2006
                    alter database open
                    Tue Jun 13 17:23:10 2006
                    Beginning crash recovery of 1 threads
                    Tue Jun 13 17:23:10 2006
                    Started redo scan
                    Tue Jun 13 17:23:11 2006
                    Completed redo scan
                    1122 redo blocks read, 241 data blocks need recovery
                    Tue Jun 13 17:23:11 2006
                    Started redo application at
                    Thread 1: logseq 6, block 24005
                    Tue Jun 13 17:23:12 2006
                    Recovery of Online Redo Log: Thread 1 Group 1 Seq 6 Reading mem 0
                    Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Tue Jun 13 17:23:13 2006
                    Completed redo application
                    Tue Jun 13 17:23:13 2006
                    Completed crash recovery at
                    Thread 1: logseq 6, block 25127, scn 474543
                    241 data blocks read, 241 data blocks written, 1122 redo blocks read
                    Tue Jun 13 17:23:15 2006
                    Thread 1 advanced to log sequence 7
                    Thread 1 opened at log sequence 7
                    Current log# 2 seq# 7 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Successful open of redo thread 1
                    Tue Jun 13 17:23:15 2006
                    SMON: enabling cache recovery
                    Tue Jun 13 17:23:19 2006
                    Successfully onlined Undo Tablespace 1.
                    Tue Jun 13 17:23:19 2006
                    SMON: enabling tx recovery
                    Tue Jun 13 17:23:19 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=19, OS id=2268
                    Tue Jun 13 17:23:30 2006
                    Completed: alter database open
                    Tue Jun 13 17:23:32 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Wed Jun 14 11:58:19 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2201K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Wed Jun 14 11:58:20 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2224K exceeds notification threshold (2048K)
                    Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_356.trc
                    KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

                    Wed Jun 14 22:00:18 2006
                    Thread 1 advanced to log sequence 8
                    Current log# 1 seq# 8 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Thu Jun 15 22:22:59 2006
                    Thread 1 advanced to log sequence 9
                    Current log# 2 seq# 9 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Fri Jun 16 22:52:58 2006
                    Thread 1 advanced to log sequence 10
                    Current log# 1 seq# 10 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Sun Jun 18 12:00:12 2006
                    Thread 1 advanced to log sequence 11
                    Current log# 2 seq# 11 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Mon Jun 19 14:34:29 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:661M/887M, Ph+PgF:884M/1018M, VA:1944M/2047M
                    Mon Jun 19 14:34:29 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 4194304
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 138412032
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    MMAN started with pid=4, OS id=1216
                    PSP0 started with pid=3, OS id=1272
                    PMON started with pid=2, OS id=1264
                    DBW0 started with pid=5, OS id=1352
                    LGWR started with pid=6, OS id=1108
                    CKPT started with pid=7, OS id=1384
                    SMON started with pid=8, OS id=1388
                    RECO started with pid=9, OS id=1392
                    CJQ0 started with pid=10, OS id=1396
                    MMON started with pid=11, OS id=1400
                    Mon Jun 19 14:34:36 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    MMNL started with pid=12, OS id=1368
                    Mon Jun 19 14:34:37 2006
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 19 14:34:39 2006
                    alter database mount exclusive
                    Mon Jun 19 14:34:43 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 19 14:34:43 2006
                    Successful mount of redo thread 1, with mount id 2474628927
                    Mon Jun 19 14:34:43 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Mon Jun 19 14:34:43 2006
                    alter database open
                    Mon Jun 19 14:34:44 2006
                    Beginning crash recovery of 1 threads
                    Mon Jun 19 14:34:44 2006
                    Started redo scan
                    Mon Jun 19 14:34:45 2006
                    Completed redo scan
                    1160 redo blocks read, 76 data blocks need recovery
                    Mon Jun 19 14:34:45 2006
                    Started redo application at
                    Thread 1: logseq 11, block 53569
                    Mon Jun 19 14:34:46 2006
                    Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
                    Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Mon Jun 19 14:34:46 2006
                    Completed redo application
                    Mon Jun 19 14:34:46 2006
                    Completed crash recovery at
                    Thread 1: logseq 11, block 54729, scn 713699
                    76 data blocks read, 76 data blocks written, 1160 redo blocks read
                    Mon Jun 19 14:34:49 2006
                    Thread 1 advanced to log sequence 12
                    Thread 1 opened at log sequence 12
                    Current log# 1 seq# 12 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Successful open of redo thread 1
                    Mon Jun 19 14:34:50 2006
                    SMON: enabling cache recovery
                    Mon Jun 19 14:34:57 2006
                    Successfully onlined Undo Tablespace 1.
                    Mon Jun 19 14:34:57 2006
                    SMON: enabling tx recovery
                    Mon Jun 19 14:34:58 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=19, OS id=1724
                    Mon Jun 19 14:35:12 2006
                    Completed: alter database open
                    Mon Jun 19 14:35:15 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Mon Jun 19 16:06:19 2006
                    WARNING: inbound connection timed out (ORA-3136)
                    Tue Jun 20 13:06:42 2006
                    Thread 1 advanced to log sequence 13
                    Current log# 2 seq# 13 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Wed Jun 21 15:26:06 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2198K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Wed Jun 21 22:00:13 2006
                    Thread 1 advanced to log sequence 14
                    Current log# 1 seq# 14 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Thu Jun 22 10:16:40 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:672M/887M, Ph+PgF:890M/1018M, VA:1944M/2047M
                    Thu Jun 22 10:16:40 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    MMAN started with pid=4, OS id=1164
                    PSP0 started with pid=3, OS id=752
                    PMON started with pid=2, OS id=1144
                    DBW0 started with pid=5, OS id=1188
                    LGWR started with pid=6, OS id=1184
                    CKPT started with pid=7, OS id=1168
                    SMON started with pid=8, OS id=1200
                    RECO started with pid=9, OS id=1216
                    CJQ0 started with pid=10, OS id=1220
                    MMON started with pid=11, OS id=1212
                    MMNL started with pid=12, OS id=1252
                    Thu Jun 22 10:16:43 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Thu Jun 22 10:16:44 2006
                    alter database mount exclusive
                    Thu Jun 22 10:16:49 2006
                    Setting recovery target incarnation to 2
                    Thu Jun 22 10:16:49 2006
                    Successful mount of redo thread 1, with mount id 2474905164
                    Thu Jun 22 10:16:49 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Thu Jun 22 10:16:49 2006
                    alter database open
                    Thu Jun 22 10:16:50 2006
                    Beginning crash recovery of 1 threads
                    Thu Jun 22 10:16:50 2006
                    Started redo scan
                    Thu Jun 22 10:16:51 2006
                    Completed redo scan
                    1121 redo blocks read, 214 data blocks need recovery
                    Thu Jun 22 10:16:51 2006
                    Started redo application at
                    Thread 1: logseq 14, block 54967
                    Thu Jun 22 10:16:52 2006
                    Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0
                    Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Thu Jun 22 10:16:53 2006
                    Completed redo application
                    Thu Jun 22 10:16:53 2006
                    Completed crash recovery at
                    Thread 1: logseq 14, block 56088, scn 842291
                    214 data blocks read, 214 data blocks written, 1121 redo blocks read
                    Thu Jun 22 10:16:54 2006
                    Thread 1 advanced to log sequence 15
                    Thread 1 opened at log sequence 15
                    Current log# 2 seq# 15 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Successful open of redo thread 1
                    Thu Jun 22 10:16:54 2006
                    SMON: enabling cache recovery
                    Thu Jun 22 10:16:57 2006
                    Successfully onlined Undo Tablespace 1.
                    Thu Jun 22 10:16:57 2006
                    SMON: enabling tx recovery
                    Thu Jun 22 10:16:57 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=19, OS id=1432
                    Thu Jun 22 10:17:05 2006
                    Completed: alter database open
                    Thu Jun 22 10:17:07 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Thu Jun 22 18:47:31 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:672M/887M, Ph+PgF:890M/1018M, VA:1944M/2047M
                    Thu Jun 22 18:47:31 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=1144
                    PSP0 started with pid=3, OS id=1148
                    MMAN started with pid=4, OS id=1152
                    DBW0 started with pid=5, OS id=1160
                    LGWR started with pid=6, OS id=1188
                    CKPT started with pid=7, OS id=1184
                    SMON started with pid=8, OS id=1164
                    RECO started with pid=9, OS id=1208
                    CJQ0 started with pid=10, OS id=1212
                    MMON started with pid=11, OS id=1204
                    MMNL started with pid=12, OS id=1244
                    Thu Jun 22 18:47:34 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Thu Jun 22 18:47:35 2006
                    alter database mount exclusive
                    Thu Jun 22 18:47:39 2006
                    Setting recovery target incarnation to 2
                    Thu Jun 22 18:47:39 2006
                    Successful mount of redo thread 1, with mount id 2474919943
                    Thu Jun 22 18:47:39 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Thu Jun 22 18:47:39 2006
                    alter database open
                    Thu Jun 22 18:47:40 2006
                    Beginning crash recovery of 1 threads
                    Thu Jun 22 18:47:41 2006
                    Started redo scan
                    Thu Jun 22 18:47:41 2006
                    Completed redo scan
                    595 redo blocks read, 77 data blocks need recovery
                    Thu Jun 22 18:47:42 2006
                    Started redo application at
                    Thread 1: logseq 15, block 18616
                    Thu Jun 22 18:47:42 2006
                    Recovery of Online Redo Log: Thread 1 Group 2 Seq 15 Reading mem 0
                    Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Thu Jun 22 18:47:43 2006
                    Completed redo application
                    Thu Jun 22 18:47:43 2006
                    Completed crash recovery at
                    Thread 1: logseq 15, block 19211, scn 874977
                    77 data blocks read, 77 data blocks written, 595 redo blocks read
                    Thu Jun 22 18:47:43 2006
                    Thread 1 advanced to log sequence 16
                    Thread 1 opened at log sequence 16
                    Current log# 1 seq# 16 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Successful open of redo thread 1
                    Thu Jun 22 18:47:43 2006
                    SMON: enabling cache recovery
                    Thu Jun 22 18:47:47 2006
                    Successfully onlined Undo Tablespace 1.
                    Thu Jun 22 18:47:47 2006
                    SMON: enabling tx recovery
                    Thu Jun 22 18:47:47 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=19, OS id=1480
                    Thu Jun 22 18:47:55 2006
                    Completed: alter database open
                    Thu Jun 22 18:47:57 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Thu Jun 22 18:58:33 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:672M/887M, Ph+PgF:890M/1018M, VA:1944M/2047M
                    Thu Jun 22 18:58:33 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PSP0 started with pid=3, OS id=1192
                    MMAN started with pid=4, OS id=1188
                    PMON started with pid=2, OS id=1168
                    DBW0 started with pid=5, OS id=1172
                    LGWR started with pid=6, OS id=1216
                    CKPT started with pid=7, OS id=1220
                    SMON started with pid=8, OS id=1212
                    RECO started with pid=9, OS id=1252
                    CJQ0 started with pid=10, OS id=1256
                    MMON started with pid=11, OS id=1272
                    MMNL started with pid=12, OS id=1280
                    Thu Jun 22 18:58:36 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Thu Jun 22 18:58:37 2006
                    alter database mount exclusive
                    Thu Jun 22 18:58:41 2006
                    Setting recovery target incarnation to 2
                    Thu Jun 22 18:58:42 2006
                    Successful mount of redo thread 1, with mount id 2474915741
                    Thu Jun 22 18:58:42 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Thu Jun 22 18:58:42 2006
                    alter database open
                    Thu Jun 22 18:58:42 2006
                    Beginning crash recovery of 1 threads
                    Thu Jun 22 18:58:42 2006
                    Started redo scan
                    Thu Jun 22 18:58:43 2006
                    Completed redo scan
                    131 redo blocks read, 80 data blocks need recovery
                    Thu Jun 22 18:58:44 2006
                    Started redo application at
                    Thread 1: logseq 16, block 3
                    Thu Jun 22 18:58:44 2006
                    Recovery of Online Redo Log: Thread 1 Group 1 Seq 16 Reading mem 0
                    Mem# 0 errs 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Thu Jun 22 18:58:45 2006
                    Completed redo application
                    Thu Jun 22 18:58:45 2006
                    Completed crash recovery at
                    Thread 1: logseq 16, block 134, scn 895274
                    80 data blocks read, 80 data blocks written, 131 redo blocks read
                    Thu Jun 22 18:58:46 2006
                    Thread 1 advanced to log sequence 17
                    Thread 1 opened at log sequence 17
                    Current log# 2 seq# 17 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Successful open of redo thread 1
                    Thu Jun 22 18:58:46 2006
                    SMON: enabling cache recovery
                    Thu Jun 22 18:58:49 2006
                    Successfully onlined Undo Tablespace 1.
                    Thu Jun 22 18:58:49 2006
                    SMON: enabling tx recovery
                    Thu Jun 22 18:58:50 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=19, OS id=1428
                    Thu Jun 22 18:58:58 2006
                    Completed: alter database open
                    Thu Jun 22 18:58:59 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Thu Jun 22 19:23:50 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2208K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Thu Jun 22 19:23:51 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2137K exceeds notification threshold (2048K)
                    Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1288.trc
                    KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

                    Fri Jun 23 13:19:40 2006
                    WARNING: inbound connection timed out (ORA-3136)
                    Fri Jun 23 22:00:12 2006
                    Thread 1 advanced to log sequence 18
                    Current log# 1 seq# 18 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Sat Jun 24 19:37:38 2006
                    Thread 1 advanced to log sequence 19
                    Current log# 2 seq# 19 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Mon Jun 26 12:49:26 2006
                    Shutting down instance: further logons disabled
                    Mon Jun 26 12:49:26 2006
                    Stopping background process CJQ0
                    Mon Jun 26 12:49:26 2006
                    Stopping background process QMNC
                    Mon Jun 26 12:49:28 2006
                    Stopping background process MMNL
                    Mon Jun 26 12:49:29 2006
                    Stopping background process MMON
                    Mon Jun 26 12:49:30 2006
                    Shutting down instance (immediate)
                    License high water mark = 6
                    Mon Jun 26 12:49:30 2006
                    Stopping Job queue slave processes
                    Mon Jun 26 12:49:30 2006
                    Job queue slave processes stopped
                    Waiting for dispatcher 'D000' to shutdown
                    All dispatchers and shared servers shutdown
                    Mon Jun 26 12:49:32 2006
                    ALTER DATABASE CLOSE NORMAL
                    Mon Jun 26 12:49:32 2006
                    SMON: disabling tx recovery
                    SMON: disabling cache recovery
                    Mon Jun 26 12:49:33 2006
                    Shutting down archive processes
                    Archiving is disabled
                    Archive process shutdown avoided: 0 active
                    Thread 1 closed at log sequence 19
                    Successful close of redo thread 1
                    Mon Jun 26 12:49:33 2006
                    Completed: ALTER DATABASE CLOSE NORMAL
                    Mon Jun 26 12:49:33 2006
                    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
                    Mon Jun 26 12:49:52 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = D:\oraclexe\app\oracle\flash_recovery_area
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=3996
                    PSP0 started with pid=3, OS id=312
                    MMAN started with pid=4, OS id=3504
                    DBW0 started with pid=5, OS id=3312
                    LGWR started with pid=6, OS id=2372
                    CKPT started with pid=7, OS id=3660
                    SMON started with pid=8, OS id=2248
                    RECO started with pid=9, OS id=3236
                    CJQ0 started with pid=10, OS id=3392
                    MMON started with pid=11, OS id=2776
                    MMNL started with pid=12, OS id=3548
                    Mon Jun 26 12:49:53 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 26 12:49:54 2006
                    ALTER DATABASE MOUNT
                    Mon Jun 26 12:49:58 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 26 12:49:58 2006
                    Successful mount of redo thread 1, with mount id 2475232050
                    Mon Jun 26 12:49:58 2006
                    Database mounted in Exclusive Mode
                    Completed: ALTER DATABASE MOUNT
                    Mon Jun 26 12:50:25 2006
                    alter database archivelog
                    Mon Jun 26 12:50:25 2006
                    Completed: alter database archivelog
                    Mon Jun 26 12:50:35 2006
                    alter database open
                    Mon Jun 26 12:50:36 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=18, OS id=3900
                    Mon Jun 26 12:50:36 2006
                    ARC0: Archival started
                    ARC1 started with pid=20, OS id=3024
                    Mon Jun 26 12:50:36 2006
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 opened at log sequence 19
                    Current log# 2 seq# 19 mem# 0: D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Successful open of redo thread 1
                    Mon Jun 26 12:50:36 2006
                    ARC0: STARTING ARCH PROCESSES
                    Mon Jun 26 12:50:36 2006
                    ARC1: Becoming the 'no FAL' ARCH
                    ARC1: Becoming the 'no SRL' ARCH
                    Mon Jun 26 12:50:36 2006
                    SMON: enabling cache recovery
                    Mon Jun 26 12:50:36 2006
                    ARC2: Archival started
                    ARC2 started with pid=21, OS id=3840
                    Mon Jun 26 12:50:36 2006
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    ARC0: Becoming the heartbeat ARCH
                    Mon Jun 26 12:50:38 2006
                    Successfully onlined Undo Tablespace 1.
                    Mon Jun 26 12:50:38 2006
                    SMON: enabling tx recovery
                    Mon Jun 26 12:50:38 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=4072
                    Mon Jun 26 12:50:45 2006
                    Completed: alter database open
                    Mon Jun 26 12:50:46 2006
                    db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Mon Jun 26 12:56:36 2006
                    Shutting down archive processes
                    Mon Jun 26 12:56:41 2006
                    ARCH shutting down
                    ARC2: Archival stopped
                    Mon Jun 26 13:46:15 2006
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Mon Jun 26 13:46:15 2006
                    ALTER SYSTEM SET db_recovery_file_dest='d:\db' SCOPE=BOTH;
                    Mon Jun 26 14:27:38 2006
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Mon Jun 26 14:27:38 2006
                    ALTER SYSTEM SET db_recovery_file_dest='d:\DB_Backup' SCOPE=BOTH;
                    Mon Jun 26 14:28:02 2006
                    alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:04 2006
                    Completed: alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:04 2006
                    alter database drop logfile group 1
                    Deleted Oracle managed file D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_28BMGK1R_.LOG
                    Completed: alter database drop logfile group 1
                    Mon Jun 26 14:28:04 2006
                    alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:05 2006
                    Thread 1 advanced to log sequence 20
                    Current log# 3 seq# 20 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
                    Mon Jun 26 14:28:09 2006
                    Completed: alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:09 2006
                    alter database drop logfile group 2
                    ORA-1624 signalled during: alter database drop logfile group 2...
                    Mon Jun 26 14:28:09 2006
                    Thread 1 advanced to log sequence 21
                    Current log# 1 seq# 21 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR74NO_.LOG
                    Mon Jun 26 14:28:13 2006
                    alter database drop logfile group 2
                    Mon Jun 26 14:28:13 2006
                    Deleted Oracle managed file D:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_28BMGLD1_.LOG
                    Completed: alter database drop logfile group 2
                    Mon Jun 26 14:28:13 2006
                    Thread 1 advanced to log sequence 22
                    Current log# 3 seq# 22 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
                    Mon Jun 26 14:28:33 2006
                    alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:34 2006
                    Completed: alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:34 2006
                    alter database drop logfile group 1
                    ORA-1624 signalled during: alter database drop logfile group 1...
                    Mon Jun 26 14:28:34 2006
                    Thread 1 advanced to log sequence 23
                    Current log# 2 seq# 23 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Mon Jun 26 14:28:40 2006
                    alter database drop logfile group 1
                    Mon Jun 26 14:28:40 2006
                    Deleted Oracle managed file D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR74NO_.LOG
                    Completed: alter database drop logfile group 1
                    Mon Jun 26 14:28:40 2006
                    alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:41 2006
                    Thread 1 advanced to log sequence 24
                    Current log# 3 seq# 24 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
                    Mon Jun 26 14:28:42 2006
                    Completed: alter database add logfile thread 1 size 51200K
                    Mon Jun 26 14:28:42 2006
                    alter database drop logfile group 3
                    ORA-1623 signalled during: alter database drop logfile group 3...
                    Mon Jun 26 14:28:42 2006
                    Thread 1 advanced to log sequence 25
                    Current log# 1 seq# 25 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
                    Mon Jun 26 14:28:46 2006
                    alter database drop logfile group 3
                    Mon Jun 26 14:28:46 2006
                    Deleted Oracle managed file D:\DB_BACKUP\XE\ONLINELOG\O1_MF_3_29ZR72NO_.LOG
                    Completed: alter database drop logfile group 3
                    Mon Jun 26 14:28:46 2006
                    Thread 1 advanced to log sequence 26
                    Current log# 2 seq# 26 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Mon Jun 26 14:31:42 2006
                    Shutting down instance: further logons disabled
                    Mon Jun 26 14:31:43 2006
                    Stopping background process CJQ0
                    Mon Jun 26 14:31:43 2006
                    Stopping background process QMNC
                    Mon Jun 26 14:31:44 2006
                    Stopping background process MMNL
                    Mon Jun 26 14:31:45 2006
                    Stopping background process MMON
                    Mon Jun 26 14:31:46 2006
                    Shutting down instance (immediate)
                    License high water mark = 3
                    Mon Jun 26 14:31:46 2006
                    Stopping Job queue slave processes
                    Mon Jun 26 14:31:46 2006
                    Job queue slave processes stopped
                    Waiting for dispatcher 'D000' to shutdown
                    All dispatchers and shared servers shutdown
                    Mon Jun 26 14:31:47 2006
                    ALTER DATABASE CLOSE NORMAL
                    Mon Jun 26 14:31:47 2006
                    SMON: disabling tx recovery
                    SMON: disabling cache recovery
                    Mon Jun 26 14:31:47 2006
                    Shutting down archive processes
                    Archiving is disabled
                    Mon Jun 26 14:31:52 2006
                    ARCH shutting down
                    ARC1: Archival stopped
                    Mon Jun 26 14:31:57 2006
                    ARCH shutting down
                    ARC0: Archival stopped
                    Mon Jun 26 14:31:58 2006
                    Thread 1 closed at log sequence 26
                    Successful close of redo thread 1
                    Mon Jun 26 14:31:58 2006
                    Completed: ALTER DATABASE CLOSE NORMAL
                    Mon Jun 26 14:31:58 2006
                    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
                    Mon Jun 26 14:32:09 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=3176
                    PSP0 started with pid=3, OS id=2928
                    MMAN started with pid=4, OS id=532
                    DBW0 started with pid=5, OS id=2068
                    LGWR started with pid=6, OS id=276
                    CKPT started with pid=7, OS id=2196
                    SMON started with pid=8, OS id=3528
                    RECO started with pid=9, OS id=3700
                    CJQ0 started with pid=10, OS id=4088
                    MMON started with pid=11, OS id=3444
                    MMNL started with pid=12, OS id=2628
                    Mon Jun 26 14:32:10 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 26 14:32:10 2006
                    ALTER DATABASE MOUNT
                    Mon Jun 26 14:32:14 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 26 14:32:14 2006
                    Successful mount of redo thread 1, with mount id 2475225642
                    Mon Jun 26 14:32:14 2006
                    Database mounted in Exclusive Mode
                    Completed: ALTER DATABASE MOUNT
                    Mon Jun 26 14:32:28 2006
                    alter database archivelog
                    Mon Jun 26 14:32:29 2006
                    Completed: alter database archivelog
                    Mon Jun 26 14:32:36 2006
                    alter database open
                    Mon Jun 26 14:32:37 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=18, OS id=2236
                    Mon Jun 26 14:32:37 2006
                    ARC0: Archival started
                    ARC1 started with pid=20, OS id=3156
                    Mon Jun 26 14:32:37 2006
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 opened at log sequence 26
                    Current log# 2 seq# 26 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Successful open of redo thread 1
                    Mon Jun 26 14:32:37 2006
                    ARC0: STARTING ARCH PROCESSES
                    Mon Jun 26 14:32:37 2006
                    ARC1: Becoming the 'no FAL' ARCH
                    ARC1: Becoming the 'no SRL' ARCH
                    Mon Jun 26 14:32:37 2006
                    SMON: enabling cache recovery
                    Mon Jun 26 14:32:37 2006
                    ARC2: Archival started
                    ARC2 started with pid=21, OS id=3804
                    Mon Jun 26 14:32:37 2006
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    ARC0: Becoming the heartbeat ARCH
                    Mon Jun 26 14:32:39 2006
                    Successfully onlined Undo Tablespace 1.
                    Mon Jun 26 14:32:39 2006
                    SMON: enabling tx recovery
                    Mon Jun 26 14:32:39 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=3648
                    Mon Jun 26 14:32:45 2006
                    Completed: alter database open
                    Mon Jun 26 14:32:47 2006
                    db_recovery_file_dest_size of 10240 MB is 1.37% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Mon Jun 26 14:35:45 2006
                    Shutting down instance: further logons disabled
                    Mon Jun 26 14:35:46 2006
                    Stopping background process CJQ0
                    Mon Jun 26 14:35:46 2006
                    Stopping background process QMNC
                    Mon Jun 26 14:35:47 2006
                    Stopping background process MMNL
                    Mon Jun 26 14:35:47 2006
                    Stopping background process MMON
                    Mon Jun 26 14:35:48 2006
                    Shutting down instance (immediate)
                    License high water mark = 2
                    Mon Jun 26 14:35:48 2006
                    Stopping Job queue slave processes
                    Mon Jun 26 14:35:48 2006
                    Job queue slave processes stopped
                    Waiting for dispatcher 'D000' to shutdown
                    All dispatchers and shared servers shutdown
                    Mon Jun 26 14:35:51 2006
                    ALTER DATABASE CLOSE NORMAL
                    Mon Jun 26 14:35:51 2006
                    SMON: disabling tx recovery
                    SMON: disabling cache recovery
                    Mon Jun 26 14:35:51 2006
                    Shutting down archive processes
                    Archiving is disabled
                    Mon Jun 26 14:35:56 2006
                    ARCH shutting down
                    ARC2: Archival stopped
                    Mon Jun 26 14:36:01 2006
                    ARCH shutting down
                    ARC1: Archival stopped
                    Mon Jun 26 14:36:06 2006
                    ARCH shutting down
                    ARC0: Archival stopped
                    Mon Jun 26 14:36:07 2006
                    Thread 1 closed at log sequence 26
                    Successful close of redo thread 1
                    Mon Jun 26 14:36:08 2006
                    Completed: ALTER DATABASE CLOSE NORMAL
                    Mon Jun 26 14:36:08 2006
                    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
                    Mon Jun 26 14:37:13 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=1092
                    PSP0 started with pid=3, OS id=2640
                    MMAN started with pid=4, OS id=3288
                    DBW0 started with pid=5, OS id=2544
                    LGWR started with pid=6, OS id=2148
                    CKPT started with pid=7, OS id=3576
                    SMON started with pid=8, OS id=1864
                    RECO started with pid=9, OS id=2392
                    CJQ0 started with pid=10, OS id=2772
                    MMON started with pid=11, OS id=3316
                    MMNL started with pid=12, OS id=1564
                    Mon Jun 26 14:37:14 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 26 14:37:14 2006
                    ALTER DATABASE MOUNT
                    Mon Jun 26 14:37:18 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 26 14:37:19 2006
                    Successful mount of redo thread 1, with mount id 2475239770
                    Mon Jun 26 14:37:19 2006
                    Database mounted in Exclusive Mode
                    Completed: ALTER DATABASE MOUNT
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Mon Jun 26 14:39:25 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:664M/887M, Ph+PgF:882M/1018M, VA:1944M/2047M
                    Mon Jun 26 14:39:25 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 10737418240
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PSP0 started with pid=3, OS id=1252
                    PMON started with pid=2, OS id=1248
                    MMAN started with pid=4, OS id=1256
                    DBW0 started with pid=5, OS id=1260
                    LGWR started with pid=6, OS id=1268
                    CKPT started with pid=7, OS id=1212
                    SMON started with pid=8, OS id=1348
                    RECO started with pid=9, OS id=1380
                    CJQ0 started with pid=10, OS id=1116
                    MMON started with pid=11, OS id=1384
                    MMNL started with pid=12, OS id=1388
                    Mon Jun 26 14:39:31 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 26 14:39:33 2006
                    alter database mount exclusive
                    Mon Jun 26 14:39:38 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 26 14:39:38 2006
                    Successful mount of redo thread 1, with mount id 2475240165
                    Mon Jun 26 14:39:38 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Mon Jun 26 14:39:38 2006
                    alter database open
                    Mon Jun 26 14:39:39 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=19, OS id=1620
                    Mon Jun 26 14:39:39 2006
                    ARC0: Archival started
                    Mon Jun 26 14:39:39 2006
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    ARC1 started with pid=20, OS id=1636
                    Thread 1 opened at log sequence 26
                    Current log# 2 seq# 26 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Successful open of redo thread 1
                    Mon Jun 26 14:39:41 2006
                    ARC0: STARTING ARCH PROCESSES
                    Mon Jun 26 14:39:41 2006
                    ARC1: Becoming the 'no FAL' ARCH
                    ARC1: Becoming the 'no SRL' ARCH
                    Mon Jun 26 14:39:41 2006
                    ARC2: Archival started
                    ARC2 started with pid=21, OS id=1640
                    Mon Jun 26 14:39:41 2006
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    ARC0: Becoming the heartbeat ARCH
                    Mon Jun 26 14:39:41 2006
                    SMON: enabling cache recovery
                    Mon Jun 26 14:39:48 2006
                    Successfully onlined Undo Tablespace 1.
                    Mon Jun 26 14:39:48 2006
                    SMON: enabling tx recovery
                    Mon Jun 26 14:39:48 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=1660
                    Mon Jun 26 14:39:59 2006
                    Completed: alter database open
                    Mon Jun 26 14:40:01 2006
                    db_recovery_file_dest_size of 10240 MB is 1.37% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Mon Jun 26 14:45:32 2006
                    Shutting down archive processes
                    Mon Jun 26 14:45:37 2006
                    ARCH shutting down
                    ARC2: Archival stopped
                    Mon Jun 26 15:04:53 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2210K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Mon Jun 26 15:04:54 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2095K exceeds notification threshold (2048K)
                    Details in trace file d:\oraclexe\app\oracle\admin\xe\bdump\xe_s000_1488.trc
                    KGL object name :XDB.XD8Vf3vgTDR1aSQOGkEtR2uQ==

                    Mon Jun 26 15:13:16 2006
                    ALTER SYSTEM SET db_recovery_file_dest_size='5G' SCOPE=BOTH;
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Mon Jun 26 16:34:07 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:649M/887M, Ph+PgF:864M/1018M, VA:1944M/2047M
                    Mon Jun 26 16:34:07 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 4194304
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 138412032
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 5368709120
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PSP0 started with pid=3, OS id=2180
                    PMON started with pid=2, OS id=2176
                    MMAN started with pid=4, OS id=2184
                    DBW0 started with pid=5, OS id=2188
                    LGWR started with pid=6, OS id=2196
                    CKPT started with pid=7, OS id=2200
                    SMON started with pid=8, OS id=2204
                    RECO started with pid=9, OS id=2208
                    CJQ0 started with pid=10, OS id=2216
                    MMON started with pid=11, OS id=2220
                    Mon Jun 26 16:34:18 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    MMNL started with pid=12, OS id=2224
                    Mon Jun 26 16:34:18 2006
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 26 16:34:20 2006
                    alter database mount exclusive
                    Mon Jun 26 16:34:24 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 26 16:34:25 2006
                    Successful mount of redo thread 1, with mount id 2475238604
                    Mon Jun 26 16:34:25 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Mon Jun 26 16:34:26 2006
                    alter database open
                    Mon Jun 26 16:34:26 2006
                    Beginning crash recovery of 1 threads
                    Mon Jun 26 16:34:26 2006
                    Started redo scan
                    Mon Jun 26 16:34:27 2006
                    Completed redo scan
                    620 redo blocks read, 16 data blocks need recovery
                    Mon Jun 26 16:34:27 2006
                    Started redo application at
                    Thread 1: logseq 26, block 2226
                    Mon Jun 26 16:34:28 2006
                    Recovery of Online Redo Log: Thread 1 Group 2 Seq 26 Reading mem 0
                    Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Mon Jun 26 16:34:28 2006
                    Completed redo application
                    Mon Jun 26 16:34:28 2006
                    Completed crash recovery at
                    Thread 1: logseq 26, block 2846, scn 1059449
                    16 data blocks read, 16 data blocks written, 620 redo blocks read
                    Mon Jun 26 16:34:29 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=19, OS id=2372
                    Mon Jun 26 16:34:29 2006
                    ARC0: Archival started
                    ARC1 started with pid=20, OS id=2376
                    Mon Jun 26 16:34:29 2006
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 advanced to log sequence 27
                    Thread 1 opened at log sequence 27
                    Current log# 1 seq# 27 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
                    Successful open of redo thread 1
                    Mon Jun 26 16:34:32 2006
                    SMON: enabling cache recovery
                    Mon Jun 26 16:34:32 2006
                    ARC0: STARTING ARCH PROCESSES
                    ARC2 started with pid=21, OS id=2392
                    Mon Jun 26 16:34:32 2006
                    ARC2: Archival started
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    ARC0: Becoming the 'no FAL' ARCH
                    ARC0: Becoming the 'no SRL' ARCH
                    Mon Jun 26 16:34:32 2006
                    ARC1: Becoming the heartbeat ARCH
                    Mon Jun 26 16:34:34 2006
                    db_recovery_file_dest_size of 5120 MB is 2.76% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Mon Jun 26 16:34:37 2006
                    Successfully onlined Undo Tablespace 1.
                    Mon Jun 26 16:34:37 2006
                    SMON: enabling tx recovery
                    Mon Jun 26 16:34:37 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=2428
                    Mon Jun 26 16:34:47 2006
                    Completed: alter database open
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Mon Jun 26 16:35:54 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:671M/887M, Ph+PgF:889M/1018M, VA:1944M/2047M
                    Mon Jun 26 16:35:54 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 4194304
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 138412032
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 5368709120
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PSP0 started with pid=3, OS id=1196
                    PMON started with pid=2, OS id=1168
                    MMAN started with pid=4, OS id=1192
                    DBW0 started with pid=5, OS id=1172
                    LGWR started with pid=6, OS id=1212
                    CKPT started with pid=7, OS id=1216
                    SMON started with pid=8, OS id=1208
                    RECO started with pid=9, OS id=1248
                    CJQ0 started with pid=10, OS id=1252
                    MMON started with pid=11, OS id=1268
                    MMNL started with pid=12, OS id=1276
                    Mon Jun 26 16:35:57 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Mon Jun 26 16:35:58 2006
                    alter database mount exclusive
                    Mon Jun 26 16:36:02 2006
                    Setting recovery target incarnation to 2
                    Mon Jun 26 16:36:03 2006
                    Successful mount of redo thread 1, with mount id 2475246638
                    Mon Jun 26 16:36:03 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Mon Jun 26 16:36:03 2006
                    alter database open
                    Mon Jun 26 16:36:03 2006
                    Beginning crash recovery of 1 threads
                    Mon Jun 26 16:36:04 2006
                    Started redo scan
                    Mon Jun 26 16:36:04 2006
                    Completed redo scan
                    102 redo blocks read, 49 data blocks need recovery
                    Mon Jun 26 16:36:04 2006
                    Started redo application at
                    Thread 1: logseq 27, block 3
                    Mon Jun 26 16:36:05 2006
                    Recovery of Online Redo Log: Thread 1 Group 1 Seq 27 Reading mem 0
                    Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
                    Mon Jun 26 16:36:05 2006
                    Completed redo application
                    Mon Jun 26 16:36:05 2006
                    Completed crash recovery at
                    Thread 1: logseq 27, block 105, scn 1079609
                    49 data blocks read, 49 data blocks written, 102 redo blocks read
                    Mon Jun 26 16:36:06 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=19, OS id=1424
                    ARC1 started with pid=20, OS id=1428
                    Mon Jun 26 16:36:07 2006
                    ARC0: Archival started
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 advanced to log sequence 28
                    Thread 1 opened at log sequence 28
                    Current log# 2 seq# 28 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Successful open of redo thread 1
                    Mon Jun 26 16:36:08 2006
                    ARC1: STARTING ARCH PROCESSES
                    Mon Jun 26 16:36:08 2006
                    ARC0: Becoming the 'no FAL' ARCH
                    ARC0: Becoming the 'no SRL' ARCH
                    Mon Jun 26 16:36:08 2006
                    SMON: enabling cache recovery
                    Mon Jun 26 16:36:08 2006
                    ARC2: Archival started
                    ARC2 started with pid=21, OS id=1396
                    Mon Jun 26 16:36:08 2006
                    ARC1: STARTING ARCH PROCESSES COMPLETE
                    ARC1: Becoming the heartbeat ARCH
                    db_recovery_file_dest_size of 5120 MB is 2.76% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Mon Jun 26 16:36:12 2006
                    Successfully onlined Undo Tablespace 1.
                    Mon Jun 26 16:36:12 2006
                    SMON: enabling tx recovery
                    Mon Jun 26 16:36:12 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=1452
                    Mon Jun 26 16:36:21 2006
                    Completed: alter database open
                    Mon Jun 26 16:39:02 2006
                    Memory Notification: Library Cache Object loaded into SGA
                    Heap size 2208K exceeds notification threshold (2048K)
                    KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

                    Mon Jun 26 16:41:59 2006
                    Shutting down archive processes
                    Mon Jun 26 16:42:04 2006
                    ARCH shutting down
                    ARC2: Archival stopped
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Tue Jun 27 11:20:20 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:670M/887M, Ph+PgF:1689M/1818M, VA:1944M/2047M
                    Tue Jun 27 11:20:20 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 5368709120
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    PMON started with pid=2, OS id=1116
                    PSP0 started with pid=3, OS id=748
                    MMAN started with pid=4, OS id=1160
                    DBW0 started with pid=5, OS id=1188
                    LGWR started with pid=6, OS id=1184
                    CKPT started with pid=7, OS id=1164
                    SMON started with pid=8, OS id=1208
                    RECO started with pid=9, OS id=1212
                    CJQ0 started with pid=10, OS id=1204
                    MMON started with pid=11, OS id=1244
                    MMNL started with pid=12, OS id=1248
                    Tue Jun 27 11:20:23 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Tue Jun 27 11:20:24 2006
                    alter database mount exclusive
                    Tue Jun 27 11:20:29 2006
                    Setting recovery target incarnation to 2
                    Tue Jun 27 11:20:29 2006
                    Successful mount of redo thread 1, with mount id 2475293112
                    Tue Jun 27 11:20:29 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Tue Jun 27 11:20:29 2006
                    alter database open
                    Tue Jun 27 11:20:29 2006
                    Beginning crash recovery of 1 threads
                    Tue Jun 27 11:20:30 2006
                    Started redo scan
                    Tue Jun 27 11:20:31 2006
                    Completed redo scan
                    1061 redo blocks read, 229 data blocks need recovery
                    Tue Jun 27 11:20:31 2006
                    Started redo application at
                    Thread 1: logseq 28, block 77692
                    Tue Jun 27 11:20:32 2006
                    Recovery of Online Redo Log: Thread 1 Group 2 Seq 28 Reading mem 0
                    Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Tue Jun 27 11:20:33 2006
                    Completed redo application
                    Tue Jun 27 11:20:33 2006
                    Completed crash recovery at
                    Thread 1: logseq 28, block 78753, scn 1130857
                    229 data blocks read, 229 data blocks written, 1061 redo blocks read
                    Tue Jun 27 11:20:33 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=19, OS id=1424
                    Tue Jun 27 11:20:33 2006
                    ARC0: Archival started
                    ARC1 started with pid=20, OS id=1388
                    Tue Jun 27 11:20:34 2006
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 advanced to log sequence 29
                    Thread 1 opened at log sequence 29
                    Current log# 1 seq# 29 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
                    Successful open of redo thread 1
                    Tue Jun 27 11:20:34 2006
                    ARC0: STARTING ARCH PROCESSES
                    Tue Jun 27 11:20:34 2006
                    ARC1: Becoming the 'no FAL' ARCH
                    Tue Jun 27 11:20:34 2006
                    ARC1: Becoming the 'no SRL' ARCH
                    Tue Jun 27 11:20:34 2006
                    ARC2: Archival started
                    ARC2 started with pid=21, OS id=1448
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    ARC0: Becoming the heartbeat ARCH
                    Tue Jun 27 11:20:35 2006
                    SMON: enabling cache recovery
                    Tue Jun 27 11:20:36 2006
                    db_recovery_file_dest_size of 5120 MB is 3.51% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Tue Jun 27 11:20:42 2006
                    Successfully onlined Undo Tablespace 1.
                    Tue Jun 27 11:20:42 2006
                    SMON: enabling tx recovery
                    Tue Jun 27 11:20:42 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=1500
                    Tue Jun 27 11:20:52 2006
                    Completed: alter database open
                    Dump file d:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                    Tue Jun 27 11:25:10 2006
                    ORACLE V10.2.0.1.0 - Production vsnsta=0
                    vsnsql=14 vsnxtr=3
                    Windows XP Version V5.1 Service Pack 1
                    CPU : 1 - type 586
                    Process Affinity : 0x00000000
                    Memory (Avail/Total): Ph:655M/887M, Ph+PgF:1676M/1818M, VA:1944M/2047M
                    Tue Jun 27 11:25:10 2006
                    Starting ORACLE instance (normal)
                    LICENSE_MAX_SESSION = 0
                    LICENSE_SESSIONS_WARNING = 0
                    Picked latch-free SCN scheme 2
                    Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                    Autotune of undo retention is turned on.
                    IMODE=BR
                    ILAT =10
                    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.1.0.
                    System parameters with non-default values:
                    sessions = 49
                    __shared_pool_size = 71303168
                    __large_pool_size = 8388608
                    __java_pool_size = 4194304
                    __streams_pool_size = 0
                    spfile = D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                    sga_target = 222298112
                    control_files = D:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                    __db_cache_size = 134217728
                    compatible = 10.2.0.1.0
                    db_recovery_file_dest = d:\DB_Backup
                    db_recovery_file_dest_size= 5368709120
                    undo_management = AUTO
                    undo_tablespace = UNDO
                    remote_login_passwordfile= EXCLUSIVE
                    dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                    shared_servers = 4
                    job_queue_processes = 4
                    audit_file_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                    background_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                    user_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                    core_dump_dest = D:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                    db_name = XE
                    open_cursors = 300
                    os_authent_prefix =
                    pga_aggregate_target = 73400320
                    MMAN started with pid=4, OS id=2136
                    PMON started with pid=2, OS id=2128
                    PSP0 started with pid=3, OS id=2132
                    DBW0 started with pid=5, OS id=2140
                    LGWR started with pid=6, OS id=2144
                    CKPT started with pid=7, OS id=2148
                    SMON started with pid=8, OS id=2152
                    RECO started with pid=9, OS id=2156
                    CJQ0 started with pid=10, OS id=2160
                    MMON started with pid=11, OS id=2164
                    Tue Jun 27 11:25:19 2006
                    starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                    MMNL started with pid=12, OS id=2168
                    Tue Jun 27 11:25:19 2006
                    starting up 4 shared server(s) ...
                    Oracle Data Guard is not available in this edition of Oracle.
                    Tue Jun 27 11:25:21 2006
                    alter database mount exclusive
                    Tue Jun 27 11:25:25 2006
                    Setting recovery target incarnation to 2
                    Tue Jun 27 11:25:25 2006
                    Successful mount of redo thread 1, with mount id 2475315937
                    Tue Jun 27 11:25:25 2006
                    Database mounted in Exclusive Mode
                    Completed: alter database mount exclusive
                    Tue Jun 27 11:25:25 2006
                    alter database open
                    Tue Jun 27 11:25:26 2006
                    Beginning crash recovery of 1 threads
                    Tue Jun 27 11:25:26 2006
                    Started redo scan
                    Tue Jun 27 11:25:27 2006
                    Completed redo scan
                    83 redo blocks read, 49 data blocks need recovery
                    Tue Jun 27 11:25:27 2006
                    Started redo application at
                    Thread 1: logseq 29, block 3
                    Tue Jun 27 11:25:27 2006
                    Recovery of Online Redo Log: Thread 1 Group 1 Seq 29 Reading mem 0
                    Mem# 0 errs 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_1_29ZR88Q1_.LOG
                    Tue Jun 27 11:25:27 2006
                    Completed redo application
                    Tue Jun 27 11:25:27 2006
                    Completed crash recovery at
                    Thread 1: logseq 29, block 86, scn 1151072
                    49 data blocks read, 49 data blocks written, 83 redo blocks read
                    Tue Jun 27 11:25:29 2006
                    LGWR: STARTING ARCH PROCESSES
                    ARC0 started with pid=19, OS id=2252
                    ARC1 started with pid=20, OS id=2256
                    Tue Jun 27 11:25:29 2006
                    ARC0: Archival started
                    Tue Jun 27 11:25:29 2006
                    ARC1: Archival started
                    LGWR: STARTING ARCH PROCESSES COMPLETE
                    Thread 1 advanced to log sequence 30
                    Thread 1 opened at log sequence 30
                    Current log# 2 seq# 30 mem# 0: D:\DB_BACKUP\XE\ONLINELOG\O1_MF_2_29ZR81M4_.LOG
                    Successful open of redo thread 1
                    Tue Jun 27 11:25:31 2006
                    ARC0: STARTING ARCH PROCESSES
                    Tue Jun 27 11:25:31 2006
                    ARC2: Archival started
                    ARC2 started with pid=21, OS id=2276
                    ARC0: STARTING ARCH PROCESSES COMPLETE
                    Tue Jun 27 11:25:31 2006
                    ARC1: Becoming the 'no FAL' ARCH
                    ARC1: Becoming the 'no SRL' ARCH
                    Tue Jun 27 11:25:31 2006
                    ARC0: Becoming the heartbeat ARCH
                    Tue Jun 27 11:25:31 2006
                    SMON: enabling cache recovery
                    Tue Jun 27 11:25:32 2006
                    db_recovery_file_dest_size of 5120 MB is 3.51% used. This is a
                    user-specified limit on the amount of space that will be used by this
                    database for recovery-related files, and does not reflect the amount of
                    space available in the underlying filesystem or ASM diskgroup.
                    Tue Jun 27 11:25:36 2006
                    Successfully onlined Undo Tablespace 1.
                    Tue Jun 27 11:25:36 2006
                    SMON: enabling tx recovery
                    Tue Jun 27 11:25:36 2006
                    Database Characterset is WE8MSWIN1252
                    replication_dependency_tracking turned off (no async multimaster replication found)
                    Starting background process QMNC
                    QMNC started with pid=22, OS id=2296
                    Tue Jun 27 11:25:45 2006
                    Completed: alter database open
                    Tue Jun 27 11:31:20 2006
                    Shutting down archive processes
                    Tue Jun 27 11:31:25 2006
                    ARCH shutting down
                    ARC2: Archival stopped
                    • 7. Re: Error  backing up Oracle Express Edition
                      520180
                      I had a look at the batch file which does the back up and it seems to stop here:

                      if "%LOGMODE%" == "NOARCHIVELOG" goto process_noarchivelog
                      if "%LOGMODE%" == "ARCHIVELOG" goto process_archivelog
                      set Errorstr= Unknown log mode : %LOGMODE%
                      goto :backupfailederr

                      I don't know how it determines the value of %LOGMODE% It isn't set anywhere unless it is an environment variable.

                      /John
                      • 8. Re: Error  backing up Oracle Express Edition
                        512198
                        If your installation is default, you don’t want to set log_archive_dest.
                        You’re archive logs will be written to a subdirectory of the flash_recovery_area.
                        Check this:

                        SQL> show parameter db_recovery_file_dest

                        NAME TYPE VALUE
                        ------------------------------------ ----------- ------------------------------
                        db_recovery_file_dest string C:\oraclexe\app\oracle\flash_recovery_area
                        db_recovery_file_dest_size big integer 10G


                        Also, you’ll be using an spfile, not a pfile. The spfile will likely be named spfilexe.ora. (The pfile would be named initXE.ora.)
                        Look for, but do not edit, your spfile in the directory specified by:

                        SQL> show parameter spfile

                        NAME TYPE VALUE
                        ------------------------------------ ----------- ------------------------------
                        spfile string C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILEXE.ORA



                        Also, to see the status of archiving, look at these settings:

                        SQL> select archiver from v$instance;

                        ARCHIVE
                        -------
                        STARTED


                        SQL> select log_mode from v$database;

                        LOG_MODE
                        ------------
                        ARCHIVELOG

                        The author of that script should be getting the value of log mode from here. However, the error, SP2-0640 is indicative of not being able to connect. That would explain why the value of %LOGMODE% isn't getting set to one of the valid choices.
                        Troubleshoot the connectivity and see what you find out.
                        • 9. Re: Error  backing up Oracle Express Edition
                          520180
                          Hi Darrell,

                          Thanks very much for your response. It got me to the root of the problem. The script assumes that you can connect to the database as follows:
                          connect / as sysdba

                          I tried that in sqlplus and it didn't work so then I changed the script so that it included the user name and password. However, I wasn't able to modify the script as I don't have admin rights on this machine, so instead I made a copy. I ran that from the root of the D: drive and got the following:

                          Doing online backup of the database.
                          RMAN-00566: could not open TRACE "D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\D
                          ATABASE\OXE_BACKUP_CURRENT.LOG"

                          Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 27 17:55:05 2006

                          Copyright (c) 1982, 2005, Oracle. All rights reserved.

                          RMAN-00571: ===========================================================
                          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                          RMAN-00571: ===========================================================
                          RMAN-00554: initialization of internal recovery manager package failed
                          RMAN-04005: error from target database:
                          ORA-01031: insufficient privileges
                          ==================== ERROR =============================
                          Backup of the database failed.
                          RMAN Error - See log for details .
                          Log file is at D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OX
                          E_BACKUP_CURRENT.LOG.
                          ==================== ERROR =============================
                          Archive state is:
                          Press any key to continue . . .

                          I think this might be related to the fact that I am not using the original script and it can't write to certain directories as a result though I'm not sure. I put in all the sql commands listed and they look ok except for the spfile which doesn't seem to have any value:

                          SQL> show parameter db_recovery_file_dest;

                          NAME TYPE VALUE
                          ------------------------------------ ----------- ------------------------------
                          db_recovery_file_dest string d:\DB_Backup
                          db_recovery_file_dest_size big integer 5G
                          SQL> show parameter spfile;

                          NAME TYPE VALUE
                          ------------------------------------ ----------- ------------------------------
                          spfile string
                          SQL> select log_mode from v$database;

                          LOG_MODE
                          ------------
                          ARCHIVELOG

                          SQL>

                          /John
                          • 10. Re: Error  backing up Oracle Express Edition
                            512198
                            Oh, boy. Now you're getting a bit out of my neighborhood. I worked with RMAN just enough to get some scripts functioning for a particular project and the client then bought a 3rd party tool. Based on your error messages, I think you're correct about possibly not having access to the directory specified in (RMAN-00566: could not open TRACE "D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OXE_BACKUP_CURRENT.LOG").
                            As well, the (ORA-01031: insufficient privileges) could be related to that if the script is trying to do a create directory in Oracle and is pointing to that location. Unfortunately, the 1031 is very broad ... could be privileges on the directory or the "create directory" command or perhaps something the rman utility is calling. I'd resolve the privs on that directory first and see if the 1031 still occurs.

                            Glad the connection bit helped!
                            • 11. Re: Error  backing up Oracle Express Edition
                              520180
                              Hi Darell,

                              I feel like a fool... the whole thing was to do with permissions... You can only do backups as the person who installed Oracle XE. In this case the administrator. There is no point being added to the administrator group or getting local admin access - it seems to be tied to the exact user name of the person who installed the database, or started the Oracle service.

                              Thanks to everyone who helped me resolve this..

                              Darell - that error I got in the last post was because I didn't have a spfile, so I did:
                              CREATE SPFILE FROM PFILE;

                              retried the backup and it worked!

                              /John