#cat ORA11G_ORA_.TRC

Trace FILE/U02/APP/DIAG/RDBMS/ORA11G/ORA11G/TRACE/ORA11G_ORA_31212.TRC

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

With the partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

Oracle_home =/u02/app/oracle

System Name:linux

Node name:pc2.oracle.com

Release:2.6.32-300.10.1.el5uek

Version: #1 SMP Wed 17:37:40 EST 2012

Machine:x86_64

VM Name:vmware Version:6

Instance name:ora11g

Redo thread mounted by this instance:1

Oracle Process number:35

Unix process pid:31212, Image: [email protected] (TNS v1-v3)

SESSION ID: (198.71) 2013-12-19 10:18:46.905

CLIENT ID: () 2013-12-19 10:18:46.905

SERVICE NAME: (sys$users) 2013-12-19 10:18:46.905

MODULE NAME: ([email protected] (TNS v1-v3)) 2013-12-19 10:18:46.905

ACTION NAME: () 2013-12-19 10:18:46.905

--The following is current System-scope REDO Log Archival Related

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

--

--log_archive_dest= '

--log_archive_duplex_dest= '

--

--LOG_ARCHIVE_FORMAT=%T_%S_%R.DBF

--

--Db_unique_name= "ora11g"

--

--log_archive_config= ' SEND, RECEIVE, Nodg_config '

--Log_archive_max_processes=4

--Standby_file_management=manual

--Standby_archive_dest=?/dbs/arch

--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 is 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 is used only if

-The current versions of all online logs is available. The second

--Set opens the database with the Resetlogs option and should is used

--If online logs is unavailable.

--the appropriate set of statements can 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 would create a new control file and use it

-To open the database.

--Data used by Recovery Manager would be lost.

--Additional logs May is required for media recovery of offline

--Use the If the current versions of all online logs is

--Available.

--After mounting the created Controlfile, the following SQL

--statement'll place, the database in the appropriate

--Protection mode:

--ALTER database SET STANDBY database to maximize performance

STARTUP Nomount

CREATE controlfile Reuse DATABASE "ora11g" Noresetlogs ARCHIVELOG

Maxlogfiles 16

Maxlogmembers 3

Maxdatafiles 100

Maxinstances 8

Maxloghistory 292

LOGFILE

GROUP 1 (

' +data/ora11g/onlinelog/group_1.262.833721677 ',

' +data/ora11g/onlinelog/group_1.263.833721679 '

) SIZE 50M BLOCKSIZE 512,

GROUP 2 (

' +data/ora11g/onlinelog/group_2.264.833721681 ',

' +data/ora11g/onlinelog/group_2.265.833721683 '

) SIZE 50M BLOCKSIZE 512,

GROUP 3 (

' +data/ora11g/onlinelog/group_3.266.833721683 ',

' +data/ora11g/onlinelog/group_3.267.833721685 '

) SIZE 50M BLOCKSIZE 512

--STANDBY LOGFILE

DataFile

' +data/ora11g/datafile/system.256.833721555 ',

' +data/ora11g/datafile/sysaux.257.833721555 ',

' +data/ora11g/datafile/undotbs1.258.833721555 ',

' +data/ora11g/datafile/users.259.833721555 ',

' +data/ora11g/datafile/example.269.833721711 '

CHARACTER SET we8mswin1252

;

--Commands to re-create incarnation table

--Below log names must is changed to existing filenames on

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

--Re-create incarnation records.

-ALTER DATABASE REGISTER LOGFILE ' +data ';

-ALTER DATABASE REGISTER LOGFILE ' +data ';

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

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

RECOVER DATABASE

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

ALTER SYSTEM ARCHIVE LOG all;

--Database can now is opened normally.

ALTER DATABASE OPEN;

--Commands to add tempfiles to temporary tablespaces.

--Online Tempfiles has complete space information.

--Other tempfiles may require adjustment.

ALTER tablespace TEMP ADD tempfile ' +data/ora11g/tempfile/temp.268.833721699 '

SIZE 20971520 Reuse autoextend on NEXT 655360 MAXSIZE 32767M;

--End of tempfile additions.

--

--Set #2. Resetlogs case

--

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

-To open the database.

--Data used by Recovery Manager would be lost.

--The contents of online logs'll be lost and all backups would

-Be invalidated. Use the If online logs is damaged.

--After mounting the created Controlfile, the following SQL

--statement'll place, the database in the appropriate

--Protection mode:

--ALTER database SET STANDBY database to maximize performance

STARTUP Nomount

CREATE controlfile Reuse DATABASE "ora11g" Resetlogs ARCHIVELOG

Maxlogfiles 16

Maxlogmembers 3

Maxdatafiles 100

Maxinstances 8

Maxloghistory 292

LOGFILE

GROUP 1 (

' +data/ora11g/onlinelog/group_1.262.833721677 ',

' +data/ora11g/onlinelog/group_1.263.833721679 '

) SIZE 50M BLOCKSIZE 512,

GROUP 2 (

' +data/ora11g/onlinelog/group_2.264.833721681 ',

' +data/ora11g/onlinelog/group_2.265.833721683 '

) SIZE 50M BLOCKSIZE 512,

GROUP 3 (

' +data/ora11g/onlinelog/group_3.266.833721683 ',

' +data/ora11g/onlinelog/group_3.267.833721685 '

) SIZE 50M BLOCKSIZE 512

--STANDBY LOGFILE

DataFile

' +data/ora11g/datafile/system.256.833721555 ',

' +data/ora11g/datafile/sysaux.257.833721555 ',

' +data/ora11g/datafile/undotbs1.258.833721555 ',

' +data/ora11g/datafile/users.259.833721555 ',

' +data/ora11g/datafile/example.269.833721711 '

CHARACTER SET we8mswin1252

;

--Commands to re-create incarnation table

--Below log names must is changed to existing filenames on

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

--Re-create incarnation records.

-ALTER DATABASE REGISTER LOGFILE ' +data ';

-ALTER DATABASE REGISTER LOGFILE ' +data ';

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

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

RECOVER DATABASE USING BACKUP controlfile

--Database can now is opened zeroing the online logs.

ALTER DATABASE OPEN resetlogs;

--Commands to add tempfiles to temporary tablespaces.

--Online Tempfiles has complete space information.

--Other tempfiles may require adjustment.

ALTER tablespace TEMP ADD tempfile ' +data/ora11g/tempfile/temp.268.833721699 '

SIZE 20971520 Reuse autoextend on NEXT 655360 MAXSIZE 32767M;

--End of tempfile additions.

--

#cat ORA11G_ORA_.TRC