oracle 11g system01.dbf,如何解决系统启动时，出现的system01.dbf文件数据块损坏的问题（在线等）...

最新推荐文章于 2023-02-12 20:25:01 发布

zhibo shan

最新推荐文章于 2023-02-12 20:25:01 发布

阅读量1.5k

点赞数

文章标签： oracle 11g system01.dbf

D:\ORACLE\ORADATA\ORCL\ARCHIVE\ORACLE_02835.ARC

ORA-328 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...

Mon Sep 20 22:12:46 2004

ALTER DATABASE RECOVER CANCEL

ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...

Mon Sep 20 22:22:10 2004

Shutting down instance (immediate)

License high water mark = 11

Mon Sep 20 22:22:11 2004

ALTER DATABASE CLOSE NORMAL

ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...

Mon Sep 20 22:22:11 2004

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

archiving is disabled

Mon Sep 20 22:22:14 2004

ARCH shutting down

ARC0: Archival stopped

Starting up ORACLE RDBMS Version: 8.1.6.0.0.

System parameters with non-default values:

processes = 160

sessions = 181

shared_pool_size = 23688576

large_pool_size = 7286400

java_pool_size = 5165824

control_files = D:\Oracle\oradata\ORCL\control01.ctl, D:\Oracle\oradata\ORCL\control02.ctl, D:\Oracle\oradata\ORCL\control03.ctl

db_block_buffers = 5359

db_block_size = 8192

compatible = 8.1.0

log_archive_start = TRUE

log_archive_dest_1 = LOCATION=D:\Oracle\oradata\ORCL\archive

log_archive_format = ORACLE_%S.ARC

log_buffer = 32768

log_checkpoint_interval = 10000

log_checkpoint_timeout = 1800

db_files = 1024

db_file_multiblock_read_count= 8

max_enabled_roles = 80

remote_login_passwordfile= EXCLUSIVE

global_names = FALSE

distributed_transactions = 500

instance_name = ORCL

service_names = ORCL

open_links = 4

sort_area_size = 33554432

sort_area_retained_size = 8388608

db_name = ORCL

open_cursors = 100

os_authent_prefix =

job_queue_processes = 10

job_queue_interval = 10

parallel_max_servers = 5

background_dump_dest = D:\Oracle\admin\ORCL\bdump

user_dump_dest = D:\Oracle\admin\ORCL\udump

max_dump_file_size = 10240

oracle_trace_collection_name=

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

SNP0 started with pid=8

SNP1 started with pid=9

SNP2 started with pid=10

SNP3 started with pid=11

SNP4 started with pid=12

SNP5 started with pid=13

SNP6 started with pid=14

SNP7 started with pid=15

SNP8 started with pid=16

SNP9 started with pid=17

Mon Sep 20 22:32:44 2004

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=18

ARC0: Archival started

Mon Sep 20 22:32:44 2004

ARCH: STARTING ARCH PROCESSES COMPLETE

Mon Sep 20 22:32:44 2004

CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG

MAXLOGFILES 32

MAXLOGMEMBERS 2

MAXDATAFILES 32

MAXINSTANCES 16

MAXLOGHISTORY 32672

LOGFILE

GROUP 1 'D:\ORACLE\ORADATA\ORCL\REDO03.LOG' SIZE 1M,

GROUP 2 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG' SIZE 1M,

GROUP 3 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG' SIZE 1M

DATAFILE

'D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF',

'D:\ORACLE\ORADATA\ORCL\RBS01.DBF',

'D:\ORACLE\ORADATA\ORCL\USERS01.DBF',

'D:\ORACLE\ORADATA\ORCL\TEMP01.DBF',

'D:\ORACLE\ORADATA\ORCL\TOOLS01.DBF',

'D:\ORACLE\ORADATA\ORCL\INDX01.DBF',

'D:\ORACLE\ORADATA\ORCL\DR01.DBF',

'D:\ORACLE\ORADATA\ORCL\ZLTOOLSTBS.DBF',

'D:\ORACLE\ORADATA\ORCL\ZLTOOLSTMP.DBF',

'D:\ORACLE\ORADATA\ORCL\ZL9BASEITEM.DBF',

'D:\ORACLE\ORADATA\ORCL\ZL9PATIENT.DBF',

'D:\ORACLE\ORADATA\ORCL\ZL9EXPENSE.DBF',

'D:\ORACLE\ORADATA\ORCL\ZL9MEDLST.DBF',

'D:\ORACLE\ORADATA\ORCL\ZL9ADVICE.DBF',

'D:\ORACLE\ORADATA\ORCL\ZL9EXPENSE1.DBF'

CHARACTER SET ZHS16GBK

Mon Sep 20 22:32:48 2004

Successful mount of redo thread 1, with mount id 986824039.

Mon Sep 20 22:32:48 2004

Completed: CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS

Mon Sep 20 22:33:14 2004

alter database open resetlogs

Mon Sep 20 22:33:14 2004

ORA-1194 signalled during: alter database open resetlogs

...

Mon Sep 20 22:34:10 2004

ALTER DATABASE RECOVER database until cancel

Mon Sep 20 22:34:10 2004

Media Recovery Start

Media Recovery failed with error 1610

ORA-283 signalled during: ALTER DATABASE RECOVER database until cancel ...

Mon Sep 20 22:34:49 2004

ALTER DATABASE RECOVER database using backup controlfile until cancel

Mon Sep 20 22:34:49 2004

Media Recovery Start

WARNING! Recovering data file 1 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 2 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 3 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 4 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 5 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 6 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 7 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 8 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 9 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 10 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 11 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 12 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 13 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 14 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

WARNING! Recovering data file 15 from a fuzzy file. If not the current file

it might be an online backup taken without entering the begin backup command.

Media Recovery Log

kcrrga: Warning. Log sequence in archive filename wrapped

to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.

Old log archive with same name might be overwritten.

ORA-279 signalled during: ALTER DATABASE RECOVER database using backup co...

Mon Sep 20 22:35:04 2004

ALTER DATABASE RECOVER CANCEL

Mon Sep 20 22:35:04 2004

ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...

Mon Sep 20 22:35:04 2004

ALTER DATABASE RECOVER CANCEL

ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...

Mon Sep 20 22:35:42 2004

Shutting down instance (immediate)

License high water mark = 11

Mon Sep 20 22:35:43 2004

ALTER DATABASE CLOSE NORMAL

ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...

Mon Sep 20 22:35:43 2004

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

archiving is disabled

Mon Sep 20 22:35:45 2004

ARCH shutting down

ARC0: Archival stopped

Starting up ORACLE RDBMS Version: 8.1.6.0.0.

System parameters with non-default values:

processes = 160

sessions = 181

shared_pool_size = 23688576

large_pool_size = 7286400

java_pool_size = 5165824

control_files = D:\Oracle\oradata\ORCL\control01.ctl, D:\Oracle\oradata\ORCL\control02.ctl, D:\Oracle\oradata\ORCL\control03.ctl

db_block_buffers = 5359

db_block_size = 8192

compatible = 8.1.0

log_archive_start = TRUE

log_archive_dest_1 = LOCATION=D:\Oracle\oradata\ORCL\archive

log_archive_format = ORACLE_%S.ARC

log_buffer = 32768

log_checkpoint_interval = 10000

log_checkpoint_timeout = 1800

db_files = 1024

db_file_multiblock_read_count= 8

max_enabled_roles = 80

remote_login_passwordfile= EXCLUSIVE

global_names = FALSE

distributed_transactions = 500

instance_name = ORCL

service_names = ORCL

open_links = 4

sort_area_size = 33554432

sort_area_retained_size = 8388608

db_name = ORCL

open_cursors = 100

os_authent_prefix =

job_queue_processes = 10

job_queue_interval = 10

parallel_max_servers = 5

background_dump_dest = D:\Oracle\admin\ORCL\bdump

user_dump_dest = D:\Oracle\admin\ORCL\udump

max_dump_file_size = 10240

oracle_trace_collection_name=

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

SNP0 started with pid=8

SNP1 started with pid=9

SNP2 started with pid=10

SNP3 started with pid=11

SNP4 started with pid=12

SNP5 started with pid=13

SNP6 started with pid=14

SNP7 started with pid=15

SNP8 started with pid=16

SNP9 started with pid=17

Mon Sep 20 22:36:04 2004

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=18

ARC0: Archival started

Mon Sep 20 22:36:04 2004

ARCH: STARTING ARCH PROCESSES COMPLETE

Mon Sep 20 22:36:04 2004

ALTER DATABASE MOUNT

Mon Sep 20 22:36:09 2004

Successful mount of redo thread 1, with mount id 1065191385.

Mon Sep 20 22:36:09 2004

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE MOUNT

Mon Sep 20 22:36:45 2004