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;
Thanks for sharing. Exactly what I needed.
How database and Search Engine Differ. Click www.gofastek.com for more information.
Cindy
www.gofastek.com
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.
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
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! :) )
this is a great post indeed. i learn a few good stuff here and be back to read more.
www.n8fan.net
Hey Really Thanks for sharing the best information regarding the database, hope you will write more great blogs.
Oracle Fusion SCM Online Training
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
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
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
good blog. your blog is really informative and helpful for me
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Oracle Integration Cloud Online Training
Oracle Fusion Technical Online Training
水replica handbags.belts https://www.coee.ru
有coach replica http://www.esbag.ru
high quality good quality replica handbags
welcome visit replica site review