Standby Database Problem(LOG File)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Standby Database Problem(LOG File)

  1. #1
    Join Date
    Mar 2003
    Posts
    32

    Standby Database Problem(LOG File)

    Hi
    I have Oracle 9i version 9.0.1.1.1 Enterprise Edition.
    O/S Widows 2000 server, Intel Server Platform.

    I created a standby database using the Oracle Documentation.
    My datafiles names have been converted according to the db_file_name_convert parameter of the init.ora of the standby.

    But I have also specify the log_file_name_convert parameter as
    Log_file_name_convert=('D:\oracle\oradata\isddb\red01.log','d:\std_db\oradata\redo01.log')


    but When after mounting the database when i issue the following query.
    select * from V$logfile;

    It gives me the name and path of the file that are in primary database.
    not this path (d:\std_db\oradata\redo01.log).

    I have tried all the documentation but there is no mention of this.
    Can anybody plz help me in the matter.
    Regards Zeeshan!

  2. #2
    Join Date
    Aug 2002
    Posts
    176
    Why not use the Alter databse rename file command for the Log files?

    Hope this helps..
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  3. #3
    Join Date
    Mar 2003
    Posts
    32
    Thanx Rohit for Replying.

    But I have tried the rename command its not working.
    Because I think u need to open the database for it.
    And It cannot open the database until the logfile are
    in correct place.

    But thanx Again for replying.
    Anynody else interested in giving some ideas,
    Pzl Help!
    Regards Zeeshan!

  4. #4
    Join Date
    Aug 2002
    Posts
    176
    You do not have to open the database to rename the files. It has to be done only in the mount stage.
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

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