Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
-- script: 37_win_prod3_rebuild_controlfile_1.sql
-- Features: This sql script rebuilds the control file.
-- NOTE: The contents of this file can only be used to rebuild the
-- control file if no datafiles have been added/moved since
-- the database was originally created.
-- The best option is to use the lastest backed up version of
-- of the control file backed up to trace (generally done nightly).
-- In order to use the tracefile information, replace the #'s with --
-- for comments.
--
-- Script Sequence#: 37
-- Used By: run manually as SYS user
-- Usage: c:\v901\bin\sqlplus.exe /nolog @37_win_prod3_rebuild_controlfile_1.sql
-- Copyright 2002 by .com Solutions Inc.
--
-- ---------------------- Revision History ---------------
-- Date By Changes
-- 12-06-2001 dsimpson Initial Release
-- 06-18-2002 dsimpson Added "M" after redo log size.
-- This output file was created by Installgen version 1.38 on Thu Nov 14 17:48:05 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
-- make sure the database is shut down before starting
-- The following commands will create a new control file and use it
-- to open the database.
-- Data used by the recovery manager will be lost. Additional logs may
-- be required for media recovery of offline data files. Use this
-- only if the current version of all online logs are available.
connect / as sysdba
set echo on;
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD3" NORESETLOGS ARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 454
LOGFILE
GROUP 1 ('c:\u01\prod3\redo01.log' ,'c:\u01\prod3\redo01g1f2.log') SIZE 10M,
GROUP 2 ('c:\u01\prod3\redo02.log' ,'c:\u01\prod3\redo02g2f2.log') SIZE 10M,
GROUP 3 ('c:\u01\prod3\redo03.log' ,'c:\u01\prod3\redo03g3f2.log') SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'c:\u01\prod3\system01.dbf',
'c:\u01\prod3\tools01.dbf',
'c:\u01\prod3\users01.dbf',
'c:\u01\prod3\rbs01.dbf',
'c:\u01\prod3\indx01.dbf',
'c:\u01\prod3\xdb01.dbf',
'c:\u01\prod3\drsys01.dbf'
CHARACTER SET US7ASCII
;
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- 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 'c:\u01\prod3\temp01.dbf' REUSE;
-- End of tempfile additions.
--
shutdown immediate
exit;
