Re: NTBACKUP error
From: pinchol <pinchol1_at_gmail.com>
Date: Tue, 18 Aug 2009 04:28:42 -0700 (PDT)
Message-ID: <7974cf33-a4e3-485a-ac78-0354e7e4f004_at_s31g2000yqs.googlegroups.com>
On Aug 16, 5:25 pm, "hea..._at_googlemail.com" <hea..._at_googlemail.com> wrote:
> Have you always had this error when backing up this system,
> particularly the Oracle datafiles .DBFs ?
>
> Are you putting the oracle tablespaces in backup mode before doing the
> tape backup if you are doing a hot backup ?
>
> It looks like NT backup is noticing these files have changed since the
> start of the backup which they will be doing if the database is
> opened. What you can do is do a restore on another box and do a
> database recovery. If the database tablespaces are in backup mode
> whilst this is in process it would have been logging whole blocks to
> allow recovery of the datafiles. Best way would be to do a test
> restore on a test box and see if can restore the database up to the
> most recent archived log available from the restored data.
>
> More details on your backup strategy will also help. Looking at your
> alert log, I can't see anything bad and can see the database shutdown
> and startup. Is this a cold backup (you are shutting down the
> database before starting the NTbackup to tape/disk ?)
>
> If this is a cold backup, look at the alert log, we can see that the
> database started the dismount of the database at Fri Aug 14 04:22:52
> 2009, did the tape backup start after this or before this ?
>
> Essentially I would check if you are doing a cold backup if the
> database was shut down before the tape backup started which could
> explain the errors.
>
> regards
> Vin
>
> On Aug 15, 10:36 am, pinchol <pinch..._at_gmail.com> wrote:
>
> > I am facing this issue when i perform full ntsystem backup using
> > adimistrator account for backup.
>
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_INDX02.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_TEMP01.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_TEMP02.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_TEMP03.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBLOG_DATA01.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
>
> > Alert Log
> > Fri Aug 14 04:20:24 2009
> > SMON: enabling tx recovery
> > Fri Aug 14 04:20:24 2009
> > Database Characterset is AR8MSWIN1256
> > replication_dependency_tracking turned off (no async multimaster
> > replication found)
> > Completed: alter database open
> > Fri Aug 14 04:22:51 2009
> > Shutting down instance: further logons disabled
> > Shutting down instance (immediate)
> > License high water mark = 1
> > Fri Aug 14 04:22:52 2009
> > ALTER DATABASE CLOSE NORMAL
> > Fri Aug 14 04:22:52 2009
> > SMON: disabling tx recovery
> > SMON: disabling cache recovery
> > Fri Aug 14 04:22:52 2009
> > Shutting down archive processes
> > Archiving is disabled
> > Archive process shutdown avoided: 0 active
> > Thread 1 closed at log sequence 67613
> > Successful close of redo thread 1
> > Fri Aug 14 04:22:52 2009
> > Completed: ALTER DATABASE CLOSE NORMAL
> > Fri Aug 14 04:22:52 2009
> > ALTER DATABASE DISMOUNT
> > Completed: ALTER DATABASE DISMOUNT
> > ARCH: Archiving is disabled
> > Shutting down archive processes
> > Archiving is disabled
> > Archive process shutdown avoided: 0 active
> > ARCH: Archiving is disabled
> > Shutting down archive processes
> > Archiving is disabled
> > Archive process shutdown avoided: 0 active
> > Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
> > Fri Aug 14 05:21:29 2009
> > ORACLE V9.2.0.5.0 - Production vsnsta=0
> > vsnsql=12 vsnxtr=3
> > Windows 2000 Version 5.0 Service Pack 4, CPU type 586
> > Fri Aug 14 05:21:29 2009
> > Starting ORACLE instance (normal)
> > LICENSE_MAX_SESSION = 0
> > LICENSE_SESSIONS_WARNING = 0
> > SCN scheme 2
> > Using log_archive_dest parameter default value
> > LICENSE_MAX_USERS = 0
> > SYS auditing is disabled
> > Starting up ORACLE RDBMS Version: 9.2.0.5.0.
> > System parameters with non-default values:
> > processes = 1021
> > timed_statistics = TRUE
> > event = 10511 trace name context forever, level
> > 2, 10841 trace name context forever
> > shared_pool_size = 528482304
> > large_pool_size = 16777216
> > java_pool_size = 16777216
> > enqueue_resources = 8000
> > control_files = D:\oracle\oradata\orcl\control01.ctl, D:
> > \oracle\oradata\orcl\control02.ctl, D:\oracle\oradata\orcl
> > \control03.ctl
> > db_block_size = 8192
> > db_writer_processes = 2
> > db_cache_size = 1048576000
> > compatible = 9.2.0.5.0
> > log_buffer = 10485760
> > log_checkpoint_interval = 5242880
> > log_checkpoint_timeout = 1800
> > db_files = 512
> > db_file_multiblock_read_count= 16
> > fast_start_mttr_target = 300
> > log_checkpoints_to_alert = TRUE
> > dml_locks = 2000
> > undo_management = AUTO
> > undo_tablespace = UNDOTBS1
> > undo_retention = 10800
> > max_enabled_roles = 96
> > O7_DICTIONARY_ACCESSIBILITY= TRUE
> > remote_login_passwordfile= EXCLUSIVE
> > db_domain =
> > global_names = FALSE
> > instance_name = orcl
> > utl_file_dir = *
> > cursor_sharing = FORCE
> > background_dump_dest = D:\oracle\admin\orcl\bdump
> > user_dump_dest = D:\oracle\admin\orcl\udump
> > core_dump_dest = D:\oracle\admin\orcl\cdump
> > sort_area_size = 1572864
> > sort_area_retained_size = 65536
> > db_name = orcl
> > open_cursors = 5000
> > star_transformation_enabled= FALSE
> > query_rewrite_enabled = FALSE
> > pga_aggregate_target = 524288000
> > PMON started with pid=2
> > DBW0 started with pid=3
> > DBW1 started with pid=4
> > LGWR started with pid=5
> > CKPT started with pid=6
> > SMON started with pid=7
> > RECO started with pid=8
> > Fri Aug 14 05:21:33 2009
> > alter database mount exclusive
> > Fri Aug 14 05:21:38 2009
> > Successful mount of redo thread 1, with mount id 1222658013
> > Fri Aug 14 05:21:38 2009
> > Database mounted in Exclusive Mode.
> > Completed: alter database mount exclusive
> > Fri Aug 14 05:21:38 2009
> > alter database open
> > Fri Aug 14 05:21:40 2009
> > Thread 1 opened at log sequence 67613
> > Current log# 3 seq# 67613 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03A.LOG
> > Current log# 3 seq# 67613 mem# 1: D:\ORACLE\ORADATA\ORCL\REDO03B.LOG
> > Successful open of redo thread 1
> > Fri Aug 14 05:21:40 2009
> > LOG_CHECKPOINT_INTERVAL was set when MTTR advisory was switched on.
> > Fri Aug 14 05:21:40 2009
> > SMON: enabling cache recovery
> > Fri Aug 14 05:21:42 2009
> > Undo Segment 1 Onlined
> > Undo Segment 2 Onlined
> > Undo Segment 3 Onlined
> > Undo Segment 4 Onlined
> > Undo Segment 5 Onlined
> > Undo Segment 6 Onlined
> > Undo Segment 7 Onlined
> > Undo Segment 8 Onlined
> > Undo Segment 9 Onlined
> > Undo Segment 10 Onlined
> > Successfully onlined Undo Tablespace 1.
> > Fri Aug 14 05:21:42 2009
> > SMON: enabling tx recovery
> > Fri Aug 14 05:21:42 2009
> > Database Characterset is AR8MSWIN1256
> > replication_dependency_tracking turned off (no async multimaster
> > replication found)
> > Completed: alter database open
> > Sat Aug 15 07:32:24 2009
> > Beginning log switch checkpoint up to RBA [0x1081e.2.10], SCN:
> > 0x0000.81bc2ea0
> > Thread 1 advanced to log sequence 67614
> > Current log# 4 seq# 67614 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO04A.LOG
> > Current log# 4 seq# 67614 mem# 1: D:\ORACLE\ORADATA\ORCL\REDO04B.LOG
>
> > Can anyone help me in this matter.
Date: Tue, 18 Aug 2009 04:28:42 -0700 (PDT)
Message-ID: <7974cf33-a4e3-485a-ac78-0354e7e4f004_at_s31g2000yqs.googlegroups.com>
On Aug 16, 5:25 pm, "hea..._at_googlemail.com" <hea..._at_googlemail.com> wrote:
> Have you always had this error when backing up this system,
> particularly the Oracle datafiles .DBFs ?
>
> Are you putting the oracle tablespaces in backup mode before doing the
> tape backup if you are doing a hot backup ?
>
> It looks like NT backup is noticing these files have changed since the
> start of the backup which they will be doing if the database is
> opened. What you can do is do a restore on another box and do a
> database recovery. If the database tablespaces are in backup mode
> whilst this is in process it would have been logging whole blocks to
> allow recovery of the datafiles. Best way would be to do a test
> restore on a test box and see if can restore the database up to the
> most recent archived log available from the restored data.
>
> More details on your backup strategy will also help. Looking at your
> alert log, I can't see anything bad and can see the database shutdown
> and startup. Is this a cold backup (you are shutting down the
> database before starting the NTbackup to tape/disk ?)
>
> If this is a cold backup, look at the alert log, we can see that the
> database started the dismount of the database at Fri Aug 14 04:22:52
> 2009, did the tape backup start after this or before this ?
>
> Essentially I would check if you are doing a cold backup if the
> database was shut down before the tape backup started which could
> explain the errors.
>
> regards
> Vin
>
> On Aug 15, 10:36 am, pinchol <pinch..._at_gmail.com> wrote:
>
> > I am facing this issue when i perform full ntsystem backup using
> > adimistrator account for backup.
>
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_INDX02.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_TEMP01.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_TEMP02.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBGNL_TEMP03.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
> > WARNING: Portions of "\oracle\oradata\orcl\SAIBLOG_DATA01.DBF" cannot
> > be read. The backed up data is corrupt or incomplete.
> > This file will not restore correctly.
>
> > Alert Log
> > Fri Aug 14 04:20:24 2009
> > SMON: enabling tx recovery
> > Fri Aug 14 04:20:24 2009
> > Database Characterset is AR8MSWIN1256
> > replication_dependency_tracking turned off (no async multimaster
> > replication found)
> > Completed: alter database open
> > Fri Aug 14 04:22:51 2009
> > Shutting down instance: further logons disabled
> > Shutting down instance (immediate)
> > License high water mark = 1
> > Fri Aug 14 04:22:52 2009
> > ALTER DATABASE CLOSE NORMAL
> > Fri Aug 14 04:22:52 2009
> > SMON: disabling tx recovery
> > SMON: disabling cache recovery
> > Fri Aug 14 04:22:52 2009
> > Shutting down archive processes
> > Archiving is disabled
> > Archive process shutdown avoided: 0 active
> > Thread 1 closed at log sequence 67613
> > Successful close of redo thread 1
> > Fri Aug 14 04:22:52 2009
> > Completed: ALTER DATABASE CLOSE NORMAL
> > Fri Aug 14 04:22:52 2009
> > ALTER DATABASE DISMOUNT
> > Completed: ALTER DATABASE DISMOUNT
> > ARCH: Archiving is disabled
> > Shutting down archive processes
> > Archiving is disabled
> > Archive process shutdown avoided: 0 active
> > ARCH: Archiving is disabled
> > Shutting down archive processes
> > Archiving is disabled
> > Archive process shutdown avoided: 0 active
> > Dump file d:\oracle\admin\orcl\bdump\alert_orcl.log
> > Fri Aug 14 05:21:29 2009
> > ORACLE V9.2.0.5.0 - Production vsnsta=0
> > vsnsql=12 vsnxtr=3
> > Windows 2000 Version 5.0 Service Pack 4, CPU type 586
> > Fri Aug 14 05:21:29 2009
> > Starting ORACLE instance (normal)
> > LICENSE_MAX_SESSION = 0
> > LICENSE_SESSIONS_WARNING = 0
> > SCN scheme 2
> > Using log_archive_dest parameter default value
> > LICENSE_MAX_USERS = 0
> > SYS auditing is disabled
> > Starting up ORACLE RDBMS Version: 9.2.0.5.0.
> > System parameters with non-default values:
> > processes = 1021
> > timed_statistics = TRUE
> > event = 10511 trace name context forever, level
> > 2, 10841 trace name context forever
> > shared_pool_size = 528482304
> > large_pool_size = 16777216
> > java_pool_size = 16777216
> > enqueue_resources = 8000
> > control_files = D:\oracle\oradata\orcl\control01.ctl, D:
> > \oracle\oradata\orcl\control02.ctl, D:\oracle\oradata\orcl
> > \control03.ctl
> > db_block_size = 8192
> > db_writer_processes = 2
> > db_cache_size = 1048576000
> > compatible = 9.2.0.5.0
> > log_buffer = 10485760
> > log_checkpoint_interval = 5242880
> > log_checkpoint_timeout = 1800
> > db_files = 512
> > db_file_multiblock_read_count= 16
> > fast_start_mttr_target = 300
> > log_checkpoints_to_alert = TRUE
> > dml_locks = 2000
> > undo_management = AUTO
> > undo_tablespace = UNDOTBS1
> > undo_retention = 10800
> > max_enabled_roles = 96
> > O7_DICTIONARY_ACCESSIBILITY= TRUE
> > remote_login_passwordfile= EXCLUSIVE
> > db_domain =
> > global_names = FALSE
> > instance_name = orcl
> > utl_file_dir = *
> > cursor_sharing = FORCE
> > background_dump_dest = D:\oracle\admin\orcl\bdump
> > user_dump_dest = D:\oracle\admin\orcl\udump
> > core_dump_dest = D:\oracle\admin\orcl\cdump
> > sort_area_size = 1572864
> > sort_area_retained_size = 65536
> > db_name = orcl
> > open_cursors = 5000
> > star_transformation_enabled= FALSE
> > query_rewrite_enabled = FALSE
> > pga_aggregate_target = 524288000
> > PMON started with pid=2
> > DBW0 started with pid=3
> > DBW1 started with pid=4
> > LGWR started with pid=5
> > CKPT started with pid=6
> > SMON started with pid=7
> > RECO started with pid=8
> > Fri Aug 14 05:21:33 2009
> > alter database mount exclusive
> > Fri Aug 14 05:21:38 2009
> > Successful mount of redo thread 1, with mount id 1222658013
> > Fri Aug 14 05:21:38 2009
> > Database mounted in Exclusive Mode.
> > Completed: alter database mount exclusive
> > Fri Aug 14 05:21:38 2009
> > alter database open
> > Fri Aug 14 05:21:40 2009
> > Thread 1 opened at log sequence 67613
> > Current log# 3 seq# 67613 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO03A.LOG
> > Current log# 3 seq# 67613 mem# 1: D:\ORACLE\ORADATA\ORCL\REDO03B.LOG
> > Successful open of redo thread 1
> > Fri Aug 14 05:21:40 2009
> > LOG_CHECKPOINT_INTERVAL was set when MTTR advisory was switched on.
> > Fri Aug 14 05:21:40 2009
> > SMON: enabling cache recovery
> > Fri Aug 14 05:21:42 2009
> > Undo Segment 1 Onlined
> > Undo Segment 2 Onlined
> > Undo Segment 3 Onlined
> > Undo Segment 4 Onlined
> > Undo Segment 5 Onlined
> > Undo Segment 6 Onlined
> > Undo Segment 7 Onlined
> > Undo Segment 8 Onlined
> > Undo Segment 9 Onlined
> > Undo Segment 10 Onlined
> > Successfully onlined Undo Tablespace 1.
> > Fri Aug 14 05:21:42 2009
> > SMON: enabling tx recovery
> > Fri Aug 14 05:21:42 2009
> > Database Characterset is AR8MSWIN1256
> > replication_dependency_tracking turned off (no async multimaster
> > replication found)
> > Completed: alter database open
> > Sat Aug 15 07:32:24 2009
> > Beginning log switch checkpoint up to RBA [0x1081e.2.10], SCN:
> > 0x0000.81bc2ea0
> > Thread 1 advanced to log sequence 67614
> > Current log# 4 seq# 67614 mem# 0: D:\ORACLE\ORADATA\ORCL\REDO04A.LOG
> > Current log# 4 seq# 67614 mem# 1: D:\ORACLE\ORADATA\ORCL\REDO04B.LOG
>
> > Can anyone help me in this matter.
Thanks for your reply
This is a cold backup. The database and all oracle services are down/ stopped before starting backup on tape. I don't know about tablespace backup is included or not sorry i am new. This is a full system backup along with oracle.
Waiting for your reply
Kind regards
Received on Tue Aug 18 2009 - 06:28:42 CDT