SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE MOUNT STANDBY DATABASE
*
ERROR at line 1:
ORA-01665: control file is not a standby control file
SQL> SELECT database_role FROM v$database;
DATABASE_ROLE
----------------------------------------------------------------
PRIMARY
In current scenario, we see the database role as primary and trying to convert as Physical Standby. You can convert when database not mounted, otherwise you will see below error.
SQL> Alter database convert to physical standby;
Alter database convert to physical standby
*
ERROR at line 1:
ORA-01507: database not mounted
SQL> shutdown immediate
SQL> startup nomount;
SQL> Alter database convert to physical standby;
Database altered.
SQL> SELECT database_role FROM v$database;
DATABASE_ROLE
----------------------------------------------------------------
PHYSICAL STANDBY
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;
Database altered.
Make sure you start the recovery using below command
sql> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;
To avoid any user mistakes I would advise to use Data Guard broker
Refer below presentation related to Data Guard.
1. “Why Oracle DataGuard? New Features in Oracle 18c,19c”
https://www.oracleracexpert.com/2019/12/why-oracle-dataguard-new-features-in.html
2. Data Guard Physical Standby Setup in Oracle?
https://www.oracleracexpert.com/2019/02/webinar-data-guard-physical-standby.html
Regards
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com
To avoid any user mistakes I would advise to use Data Guard broker
Refer below presentation related to Data Guard.
1. “Why Oracle DataGuard? New Features in Oracle 18c,19c”
https://www.oracleracexpert.com/2019/12/why-oracle-dataguard-new-features-in.html
2. Data Guard Physical Standby Setup in Oracle?
https://www.oracleracexpert.com/2019/02/webinar-data-guard-physical-standby.html
Regards
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com
ReplyDeleteAlso known to come with crucial offerings for its sensible, down-to-earth and important clients,Call Girls in Vasant Vihar really means in fulfilling their lives with cheerful moments to make love in concern to ensure them live their lives in abetter way. Check our other Services...
Escorts Service in Chanakyapuri
Escorts Service in Vasant Kunj
Russian Escorts in Vasant Vihar
Escorts in Mahipalpur
Russian Escorts in Mahipalpur
Call Girls in Connaught Place
Packers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ???Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @ Packers And Movers Gurgaon
ReplyDeleteThanks for picking out the time to discuss this,
ReplyDeleteLajpat Nagar Escorts
Malviya Nagar Escort Service
Connaught Place Escort Service
Punjabi Bagh Call Girls
Call Girls in Mahipalpur
Escorts Service in Aerocity
karol bagh Escorts Service
I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such valuable help again.
Packers and Movers in Ghaziabad.
ReplyDeletePackers and Movers Ghaziabad.
Packers Movers Ghaziabad.
Movers and Packers in Ghaziabad.
Movers and Packers Ghaziabad.
Movers Packers Ghaziabad.
Local Packers and Movers in Ghaziabad.
International Packers and Movers in Ghaziabad.
All competitive and government recruitment exams, including those for the UPSC, SSC, Bank PO/Clerk, and other positions, have a significant and standard portion on general knowledge or general awareness. General Knowlorge on Telugu seeks to aid candidates' preparation by offering in-depth study of significant themes, extensive insights on General Knowledge essential issues, and GK questions with answers on historical as well as current events taking place in India and throughout the world.
ReplyDelete