DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: control file for data guard

  1. #1
    Join Date
    Apr 2006
    Posts
    24

    control file for data guard

    Hi
    I am in process to create standby database. I am wondering that while I issued this---
    alter database create standby controlfile 'filename'

    it will create only one controlfile ,do I needt to issue three file name or what?
    Any help would be appreciated
    thanks in advance

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Just copy it to a new name as many times as you need.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  3. #3
    Join Date
    Apr 2006
    Posts
    24
    Thanks DaPi

  4. #4
    Join Date
    Apr 2006
    Posts
    24
    During standby database open up I am getting this error, so I am wondering do I need to recreate or modify standby controlfile?
    C:\Documents and Settings\Lisa>set oracle_sid=newstand

    C:\Documents and Settings\Lisa>sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 28 09:22:51 2006

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> connect /as sysdba
    Connected.
    SQL> startup nomount
    ORA-01081: cannot start already-running ORACLE - shut it down first
    SQL> shutdown immediate;
    ORA-01507: database not mounted


    ORACLE instance shut down.
    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 126950220 bytes
    Fixed Size 453452 bytes
    Variable Size 109051904 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 667648 bytes
    SQL> alter database mount standby database;

    Database altered.

    SQL> recover automatic standby database;
    ORA-00283: recovery session canceled due to errors
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'


    SQL> recover automatic standby database using backup controlfile;
    ORA-00283: recovery session canceled due to errors
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
    ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'

    Thanks in advance

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to have db_filename_convert set (or whatever the parameter is) if the locations are not the same as the primary

  6. #6
    Join Date
    Apr 2006
    Posts
    24
    Thanks davey23uk.
    I did it in my init.ora file. *.db_file_name_convert='C:/oracle/oradata/standby',
    'C:/oracle/oradata/NEWSTAND'
    here do I need to specify each file or what?
    Thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width