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

Thread: ORA-01111: name for data file 129 is unknown - rename to correct file

  1. #1
    Join Date
    Jul 2005
    Posts
    4

    ORA-01111: name for data file 129 is unknown - rename to correct file

    I have a 10.2.0.1 database and a standby database on another server that has the redo logs applied every 15 mins.

    I added a new file to the primary db but the standby server's disk was full so when it tried to automatically it failed.

    I've sorted the space issue out but now I get the following error :

    ORA-00283: recovery session canceled due to errors
    ORA-01111: name for data file 129 is unknown - rename to correct file
    ORA-01110: data file 129: 'C:\ORACLE\ORA10G\DATABASE\UNNAMED00129'
    ORA-01157: cannot identify/lock data file 129 - see DBWR trace file
    ORA-01111: name for data file 129 is unknown - rename to correct file
    ORA-01110: data file 129: 'C:\ORACLE\ORA10G\DATABASE\UNNAMED00129'

    I've tried manually copying the files from the live db and I've tried an alter database rename file command but that tells me renaming is not allowed if standby management is set to automatic. I've had a search but can't see a solution, any ideas?

    Thanks
    Robert

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool Rebuild it?

    Don't know if it would work, but I would try the following:

    1) Shutdown standby
    2) At primary:
    - alter tablespace (with newfile) begin backup
    - copy datafiles to standby
    - alter tablespace (with newfile) end backup
    - alter database create standby controlfile as '/tmp/control01.ctl';
    - copy controlfile to standby
    3) At standby
    - copy controlfile to other standby locations
    - recover database

    If it does not work, maybe you need to re-build the standby.
    Good luck!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Did you stop the managed recovery process and try

    ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';

    then do the renaming again

    and then try

    ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';

    and restart the MRP

    regards
    Hrishy

  4. #4
    Join Date
    Jul 2005
    Posts
    4
    Thanks for your replies, got it working using the following ...

    STEP1:- Check the name of the datafile on standby database

    select name from v$datafile; ---- This command should show the datafile name as UNNAMEDxxxxx

    STEP2:- ON STANDBY DATABASE
    alter system set standby_file_management='manual';

    STEP3:- Rename the datafile
    alter database create datafile 'C:\ORACLE\ORA10G\DATABASE\UNNAMED00129' as 'C:\ORACLE\ORA10G\DATABASE\actual_dbfile_name.dbf'


    STEP4:- On the standby database
    alter system set standby_file_management='auto';

    STEP5:- On the standby database
    recover managed standby database disconnect;

    shutdown and then reopen the standby database and continue applying the redo logs

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