Recreate Control

http://www.eygle.com/faq/How.To.Backup.and.Recreate.Controlfile.htm

alter database backup controlfile to trace

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 200
    MAXLOGMEMBERS 10
    MAXDATAFILES 200
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/u02/oradata/PROD/redo01_1.log',
    '/u03/oradata/PROD/redo01_2.log',
    '/u04/oradata/PROD/redo01_3.log'
  ) SIZE 50M,
  GROUP 2 (
    '/u02/oradata/PROD/redo02_1.log',
    '/u03/oradata/PROD/redo02_2.log',
    '/u04/oradata/PROD/redo02_3.log'
  ) SIZE 50M,
  GROUP 3 (
    '/u02/oradata/PROD/redo03_1.log',
    '/u03/oradata/PROD/redo03_2.log',
    '/u04/oradata/PROD/redo03_3.log'
  ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/u02/oradata/PROD/system.dbf',
  '/u02/oradata/PROD/undotbs01.dbf',
  '/u02/oradata/PROD/sysaux.dbf',
  '/u02/oradata/PROD/perfstat.dbf',
  '/u02/oradata/PROD/tbs_ybbuser_01.dbf'
CHARACTER SET WE8ISO8859P1
;

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;

ALTER TABLESPACE TEMP ADD TEMPFILE '/u02/oradata/PROD/temp01.dbf'
     SIZE 20971520  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License