Oracle control文件,查看oracle中controlfile的内容

最新推荐文章于 2024-07-17 07:03:33 发布

weixin_39769627

最新推荐文章于 2024-07-17 07:03:33 发布

阅读量372

点赞数

文章标签： Oracle control文件

本文提供了一套详细的Oracle数据库控制文件重建步骤，包括在不同情况下的NORESETLOGS和RESETLOGS选项使用方法。此外，还介绍了如何创建新的控制文件并重新注册日志文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Trace file d:\oracle\diag\rdbms\orcl\orcl\trace\orcl_ora_7176.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Windows NT Version V6.1 Service Pack 1

CPU : 4 - type 586, 2 Physical Cores

Process Affinity : 0x0x00000000

Memory (Avail/Total): Ph:1513M/3566M, Ph+PgF:4403M/7130M, VA:971M/2047M

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 22

Windows thread id: 7176, image: ORACLE.EXE (SHAD)

*** 2011-07-14 17:31:26.271

*** SESSION ID:(132.807) 2011-07-14 17:31:26.271

*** CLIENT ID:() 2011-07-14 17:31:26.271

*** SERVICE NAME:(SYS$USERS) 2011-07-14 17:31:26.271

*** MODULE NAME:(sqlplus.exe) 2011-07-14 17:31:26.271

*** ACTION NAME:() 2011-07-14 17:31:26.271

-- The following are current System-scope REDO Log Archival related

-- parameters and can be included in the database initialization file.

-- LOG_ARCHIVE_DEST=''

-- LOG_ARCHIVE_DUPLEX_DEST=''

-- LOG_ARCHIVE_FORMAT=ARC%S_%R.%T

-- DB_UNIQUE_NAME="orcl"

-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'

-- LOG_ARCHIVE_MAX_PROCESSES=4

-- STANDBY_FILE_MANAGEMENT=MANUAL

-- STANDBY_ARCHIVE_DEST=%ORACLE_HOME%\RDBMS

-- FAL_CLIENT=''

-- FAL_SERVER=''

-- LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

-- LOG_ARCHIVE_DEST_1='MANDATORY NOREOPEN NODELAY'

-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM EXPEDITE NOVERIFY SYNC'

-- LOG_ARCHIVE_DEST_1='NOREGISTER NOALTERNATE NODEPENDENCY'

-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'

-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'

-- LOG_ARCHIVE_DEST_STATE_1=ENABLE

-- Below are two sets of SQL statements, each of which creates a new

-- control file and uses it to open the database. The first set opens

-- the database with the NORESETLOGS option and should be used only if

-- the current versions of all online logs are available. The second

-- set opens the database with the RESETLOGS option and should be used

-- if online logs are unavailable.

-- The appropriate set of statements can be copied from the trace into

-- a script file, edited as necessary, and executed when there is a

-- need to re-create the control file.

-- Set #1. NORESETLOGS case

-- The following commands will create a new control file and use it

-- to open the database.

-- Data used by Recovery Manager will be lost.

-- Additional logs may be required for media recovery of offline

-- Use this only if the current versions of all online logs are

-- available.

-- After mounting the created controlfile, the following SQL

-- statement will place the database in the appropriate

-- protection mode:

-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 'D:\ORACLE\ORADATA\ORCL\REDO01.LOG' SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\ORACLE\ORADATA\ORCL\REDO02.LOG' SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\ORACLE\ORADATA\ORCL\REDO03.LOG' SIZE 50M BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

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

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

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

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

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

CHARACTER SET ZHS16GBK

;

-- Commands to re-create incarnation table

-- Below log names MUST be changed to existing filenames on

-- disk. Any one log file from each branch can be used to

-- re-create incarnation records.

-- ALTER DATABASE REGISTER LOGFILE 'D:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_14\O1_MF_1_1_%U_.ARC';

-- Recovery is required if any of the datafiles are restored backups,

-- or if the last shutdown was not normal or immediate.

RECOVER DATABASE

-- All logs need archiving and a log switch is needed.

ALTER SYSTEM ARCHIVE LOG ALL;

-- Database can now be opened normally.

ALTER DATABASE OPEN;

-- Commands to add tempfiles to temporary tablespaces.

-- Online tempfiles have complete space information.

-- Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORADATA\ORCL\TEMP01.DBF'

SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;

-- End of tempfile additions.

-- Set #2. RESETLOGS case