Some new directories were created on the primary side and new datafiles were added in these directories.
Because creating same directories on the standby server was forgotten, file creations were failed on standby... Dataguard stopped with error :

ORA-01111: name for data file 195 is unknown - rename to correct file
ORA-01110: data file 195: '/oracle/app/oracle/product/10.2.0/dbs/UNNAMED00195'
ORA-01157: cannot identify/lock data file 195 - see DBWR trace file

In order to start dataguard;

Firstly create the missing directory(ies) on the standby machine; then on the standby database:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;
ALTER DATABASE CREATE DATAFILE '$ORACLE_HOME/dbs/UNNAMED00195' as 'correct_path/datafile.dbf';
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

12 Responses so far.

  1. Anonymous says:

    Thanks for sharing. Exactly what I needed.

  2. Cindy says:

    How database and Search Engine Differ. Click www.gofastek.com for more information.

    Cindy
    www.gofastek.com

  3. I must say you've finished an exceptionally exceptional work, I'm completely getting a charge out of the keen way you compose articles in this website. Here is a yearning web journal and truly like it. Click here http://www.localmanchesterescorts.co.uk.

  4. I'm affected. you are actually well informed and really intelligent. You wrote one thing that individuals may perceive and created the topic intriguing for everybody. i am saving this for future use. click here Movers and Packers Raipur

  5. Unknown says:

    I really like being a free man. I sometimes book DEH massages as a cure and really like the expectation major up to the occasion. Songs, candle lights, oils… Enjoyment (as they say) expanded by a stunning young, fabulous and incredibly sexy Gurgaon escort. What a way for a celebration bachelor's like me to live, I never want to get wedded again! :) )

  6. 3n1 says:

    this is a great post indeed. i learn a few good stuff here and be back to read more.

    www.n8fan.net

  7. Kiran says:

    Hey Really Thanks for sharing the best information regarding the database, hope you will write more great blogs.

    Oracle Fusion SCM Online Training

  8. sravanthi says:

    Hey Really very helpful article, Thank you for sharing Hey Really Thanks for sharing the best information regarding Oracle, hope you will write more great blogs.


    Oracle Fusion Financials Online Training

  9. I’m impressed, I have to say. Actually not often do I encounter a blog that’s each educative and entertaining, and let me tell you, you will have hit the nail on the head. Your concept is outstanding; the issue is something that not enough persons are speaking intelligently about. I am very joyful that I stumbled throughout this in my seek for something referring to this. casino blackjack

  10. Really very helpful article , Thank you for sharing we have learned so much information from your blog

    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

  11. Anonymous says:

    水replica handbags.belts https://www.coee.ru

    有coach replica http://www.esbag.ru

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -