|Exam Name||:||Oracle Database 11g Release 2- SQL Tuning|
|Questions and Answers||:||125 Q & A|
|Updated On||:||July 20, 2018|
|PDF Download Mirror||:||[1Z0-117 Download Mirror]|
|Get Full Version||:||Pass4sure 1Z0-117 Full Version|
by way of Joel Pérez and Skant Gupta
listed here, we will display you a way to fail over and reinstate Oracle Database in the cloud.
notice: to use the process offered in this article, you need two Oracle Cloud database situations. additionally, the procedure offered was performed on Oracle Database 11g; despite the fact, the procedure should work on later releases comparable to Oracle Database 12c unencumber 1 and unencumber 2.Create the fundamental Database example
- For provider name enter basic.- From the provider level list, select Oracle Database Cloud provider.- From the Metering Frequency checklist, opt for whatever frequency is applicable on your ambiance.- From the application unlock listing, select Oracle Database 11g release 2.- From the application version checklist, select business edition.- From the Database classification listing, opt for Single example.
Then click on subsequent to proceed.
determine 1. developing a brand new carrier
- For DB identify (SID), enter ORCL.- Set an administrative password of your choice and ensure the password (this might be your sys password).- For Usable Database Storage (GB), enter 25.- From the Compute shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the naked minimal required).- For SSH Public Key, enter rsa-key-20170111.pub.
Then click subsequent to proceed.
figure 2. Specifying the service particulars
figure 3. developing the basic cloud database illustration
After a few minutes, the fundamental cloud database example has been created efficiently.
determine four. The fundamental database has been created
figure 5. leading page of the fundamental database
a. Open the database service and choose entry rules from the menu.
determine 6. picking the entry guidelines merchandiseb. For the ora_p2_dblistener rule, opt for allow from the actions menu.
determine 7. Enabling the ora_p2_dblistener rule
- For carrier identify enter Standby.- From the provider degree checklist, select Oracle Database Cloud service.- From the Metering Frequency checklist, select anything frequency is appropriate in your ambiance.- From the application unencumber listing, opt for Oracle Database 11g free up 2.- From the application edition listing, choose commercial enterprise version.- From the Database class listing, opt for Single example.
Then click on subsequent to proceed.
figure eight. growing one more new carrier
- For DB name (SID), enter ORCL.- Set an administrative password of your option and ensure the password (this should be your sys password).- For Usable Database Storage (GB), enter 25.- From the Compute shape record, select OC3 -1 OCPU, 7.5GB RAM (here is the naked minimum required).- For SSH Public Key, enter rsa-key-20170111.pub.
click on subsequent to proceed.
notice: This dummy database will be dropped later.
figure 9. Specifying the carrier details
determine 10. developing the standby cloud database illustration
After a few minutes, the standby cloud database instance has been created efficiently.
figure eleven. The standby database has been created
figure 12. leading page of the standby database
a. Open the database service and select entry rules from the menu.
figure 13. picking out the entry guidelines itemb. For the ora_p2_dblistener rule, choose enable from the moves menu.
determine 14. Enabling the ora_p2_dblistener rule
determine 15. Connecting to both machines the use of PuTTY
be aware: In here figures, the simple example is shown with a black heritage and the standby instance is shown with a yellow heritage.
determine sixteen. Checking the host names and pmon techniques
determine 17. dropping the standby database
in the subsequent steps, you're going to re-create the standby database manually
also, because you'll deserve to configure the statistics guard broker in an upcoming step, add a static entry for its command-line interface (DGMGRL) in the listener.ora file on each the fundamental and standby servers. (The records defend broking service is a distributed administration framework supplied by Oracle Database, commercial enterprise version.)SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = STBY_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/eleven.2.0/dbhome_1) (SID_NAME = STBY) ) (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = STBY) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = STBY) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (tackle = (PROTOCOL = TCP)(HOST = Standby.compute-aeetisalat78358.oraclecloud.inside)(PORT = 1521)) (address = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )
figure 18. Configuring the listener.ora data
figure 19. Restarting the listener
determine 20. Verifying the configuration of the tnsnames.ora info
determine 21. running the tnsping command
determine 22. creating directories on the standby machine
figure 23. starting the standby database and checking the connections
After some time, the standby database is created and working within the installed state.
determine 24. Standby database operating in the mounted state
On the primary:create table look at various as select * from dict;
On the standby:alter database open; ALTER device SET LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STBY'; ALTER device SET LOG_ARCHIVE_DEST_2= 'carrier=ORCL LGWR ASYNC confirm VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL' scope=both; get well managed standby database the use of current logfile disconnect;
determine 25. Opening the standby database and starting the restoration
Failover is the manner of activating the standby database in case the production (primary) database is deformed with a purpose to lower the chance of information loss. It is not reversible. When the failover manner is enabled, the standby database is switched to function as the simple database and you would have to re-create the standby database.
In a worst-case situation when the information shield simple database isn't attainable for creation, you can prompt the standby database to be the primary construction database by using performing the following steps.
determine 26. Activating the standby database
figure 27. Manually re-creating the ancient basic database
determine 28. starting the historic fundamental database and reinstating it
After a while, the historical primary database is re-created as the standby database and it's working within the hooked up state.
determine 29. old basic database working in the mounted state
On the simple:SQL> alter database open examine only; SQL> improve managed standby database the use of existing logfile disconnect; SQL> select count number(*) from look at various; count(*) ---------- 0 SQL> opt for name,db_unique_name,database_role,open_mode from v$database; name DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE --------- ------------------------------ ---------------- -------------------- ORCL ORCL actual STANDBY examine simplest WITH observe
On the standby:SQL> opt for count(*) from look at various; count number(*) ---------- 2666 SQL> delete from test; 2666 rows deleted. SQL> commit; Commit complete. SQL> choose count(*) from check; count(*) ---------- 0
figure 30. Opening the standby database and starting the restoration
Hardware crashes have turn into very general this present day. it really is why creating a disaster restoration (DR) configuration for information shield is awfully constructive for every database, even with its size. but the size of the database defines the device a DBA can use to re-create the fundamental database and set up the DR configuration.
If database is quite small, doing a simple "bloodless reproduction" using the Oracle RMAN reproduction command is decent ample. youngsters, within the case of massive facts warehouses or facts marts, doing that takes too long. therefore, it's counseled to reinstate standby databases by using the Oracle Flashback Database skill of Oracle Database.
determine 31. consequences of beginning the flashback expertise on each machines
next, we can configure the statistics defend broking service.
here are the primary and standby database server details:fundamental server: basic.compute-aeetisalat78358.oraclecloud.internalDatabase: ORCL
Standby server: StandBy-1.compute-aeetisalat78358.oraclecloud.internalDatabase: STBY1
a. allow the broking service system with the aid of setting the cost of the parameter DG_BROKER_START to genuine.ALTER system SET DG_BROKER_START=genuine SCOPE=both;
b. make sure that the listener.ora file on both servers has a static entry for the DGMGRL command-line interface. (This was brought previous in step 9.)
c. On the fundamental server, create the data shield broker configuration by using working the statements:DGMGRL> CREATE CONFIGURATION 'Cloud DG' as basic DATABASE IS'ORCL' connectIDENTIFIER IS 'ORCL'; Configuration "CloudDG" created with primary database "ORCL" DGMGRL> demonstrate CONFIGURATION Configuration - CloudDG coverage Mode :MaxPerformance individuals: ORCL - basic database speedy-start Failover:DISABLED Configuration status: DISABLED
d. Add the standby database to the configuration by working the following statements:DGMGRL> ADD DATABASE 'STBY' as join IDENTIFIER IS 'STBY'; Database "STBY" brought DGMGRL> display CONFIGURATION Configuration - CloudDG insurance plan Mode :MaxPerformance Databases: ORCL - primary database STBY - actual standby database quickly-start Failover:DISABLED Configuration status: DISABLED
e. permit the configuration by using running the following statements:DGMGRL> allow CONFIGURATION Enabled. DGMGRL> demonstrate CONFIGURATION Configuration - CloudDG coverage Mode: MaxPerformance Databases: ORCL - simple database STBY - actual standby database quickly-delivery Failover: DISABLED Configuration reputation: SUCCESS
figure 32. effects of enabling the broking service
figure 33. State of the primary database after is it crashed
figure 34. Performing a failover
note: Now the standby database becomes the fundamental database.
because we have Oracle Flashback Database already configured, that you can use the following command to reinstate database devoid of restoring the backup:DGMGRL> reinstate database 'ORCL';
determine 35. Reinstating the database
Failing which we would had been required to configure flashback database with a view to reinstate the database immediately. As determine 35 suggests, the reinstate project failed as a result of flashback isn't configured to reinstate automatically across the Reinstate Database <DB identify> command.
figure 36. Performing a switchover operation
So now you comprehend that it is very convenient to perform a failover over the cloud with and devoid of the usage of Oracle Flashback Database.
We hope this text is valuable and we invite you to proceed analyzing our subsequent publications concentrated on Oracle Cloud.about the Authors
Joel Pérez is an expert DBA and Oracle ACE Director and an Oracle licensed grasp in Oracle optimum Availability architecture, Oracle Database cloud administration, and Oracle Database 11g and12c. He has over 17 years of real-world journey with Oracle know-how and specializes in the design and implementation of solutions for the cloud, excessive availability (HA), disaster recuperation, improvements, replication, and most areas concerning Oracle Database. at the moment, he works as chief technologist and architect for cloud applied sciences, Oracle maximum Availability structure, and HA at Yunhe Enmo (Beijing) technology Co., Ltd. in Beijing, China.Skant Gupta is an Oracle licensed Cloud professional in Oracle Database 12c, an Oracle licensed professional in Oracle real utility Clusters (Oracle RAC) in Oracle Database 11g, and an Oracle licensed expert in Oracle Database 10g, 11g, and 12c. He works at Vodafone know-how in the UK and formerly labored as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle applied sciences, focusing in particular on cloud, database, and excessive availability options, Oracle WebLogic Suite, and Oracle GoldenGate. He has presented at a few Oracle consumer companies global, most recently within the US, the United Arab Emirates, and India.
Title: C-stage/President supervisor VP staff (associate/Analyst/and many others.) Directorcharacteristic:
position in IT determination-making process: Align enterprise & IT dreams Create IT approach examine IT needs manage supplier Relationships evaluate/Specify manufacturers or companies different role Authorize Purchases not involvedWork phone: enterprise: company measurement: business: highway tackle city: Zip/postal code State/Province: country:
now and again, we ship subscribers particular presents from select partners. Would you want to receive these particular accomplice presents by the use of electronic mail? sure No
Your registration with Eweek will include here free email newsletter(s): information & Views
with the aid of submitting your instant number, you agree that eWEEK, its related residences, and supplier partners featuring content material you view can also contact you the usage of contact middle know-how. Your consent isn't required to view content or use web site facets.
Registercontinue devoid of consent
Zimbabwe: economic system Takes Centre Stage forward of Polls
Lesotho: 'gasoline fee Hike Spells complicated winter'
This newest era of database builds on the improvements added in Oracle Database 11g to assist groups bring better guidance throughout the business, at a higher nice of provider, and at a a whole lot lessen can charge.
during this unencumber, Oracle real software Clusters (RAC) offers grid plug and play and new server pooling capabilities that enable corporations to cut back their server expenses by streamlining the provisioning and administration of consolidated database grids.
you have chosen an editorial from the AllAfrica archive, which requires a subscription. youngsters, that you may freely entry - and not using a subscription - tons of of cutting-edge accurate Africa reports and hundreds of contemporary information articles from our home page »
click right here to move to our domestic web page for the entire present informationYou have to be an allAfrica.com subscriber for full access to certain content.
For more information about subscribing to allAfrica, please read the subscription and contribution overview. when you are ready to subscribe, please go directly to our secure server.
Copyright © 2009 leading edge. All rights reserved. disbursed via AllAfrica global Media (allAfrica.com). To contact the copyright holder directly for corrections — or for permission to republish or make other authorized use of this cloth, click on here.
AllAfrica publishes around 800 experiences a day from greater than a hundred and forty news organizations and over 500 other institutions and people, representing a diversity of positions on each topic. We publish information and views ranging from vigorous opponents of governments to govt publications and spokespersons. Publishers named above each document are accountable for his or her personal content, which AllAfrica doesn't have the felony right to edit or suitable.
Articles and commentaries that establish allAfrica.com because the writer are produced or commissioned via AllAfrica. To address comments or complaints, please Contact us.
Whilst it is very hard task to choose reliable exam questions / answers resources regarding review, reputation and validity because people get ripoff due to choosing incorrect service. Killexams. com make it certain to provide its clients far better to their resources with respect to exam dumps update and validity. Most of other peoples ripoff report complaint clients come to us for the brain dumps and pass their exams enjoyably and easily. We never compromise on our review, reputation and quality because killexams review, killexams reputation and killexams client self confidence is important to all of us. Specially we manage killexams.com review, killexams.com reputation, killexams.com ripoff report complaint, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. If perhaps you see any bogus report posted by our competitor with the name killexams ripoff report complaint internet, killexams.com ripoff report, killexams.com scam, killexams.com complaint or something like this, just keep in mind that there are always bad people damaging reputation of good services due to their benefits. There are a large number of satisfied customers that pass their exams using killexams.com brain dumps, killexams PDF questions, killexams practice questions, killexams exam simulator. Visit Killexams.com, our test questions and sample brain dumps, our exam simulator and you will definitely know that killexams.com is the best brain dumps site.
Killexams PMI-RMP test prep | Killexams JN0-634 mock test | Killexams C8060-220 cbt | Killexams 000-218 free pdf | Killexams C2020-612 practice questions | Killexams PCNSE6 essay questions | Killexams ICYB entrance exam | Killexams HP2-E44 practice questions | Killexams ADM211 free test | Killexams 920-130 practice test | Killexams HP2-N40 free test online | Killexams HP2-H17 cheat sheet | Killexams 2B0-015 test questions | Killexams HP0-M48 study tools | Killexams HP2-K09 brain dumps | Killexams 00M-640 dump | Killexams COG-135 mock exam | Killexams 920-245 test questions and answers | Killexams 700-501 reading practice test | Killexams 920-544 exam prep |
Get high marks in 1Z0-117 exam with these dumps
We are for the maximum part very a great deal conscious that a noteworthy difficulty inside the IT business is that theres an absence of price ponder substances. Our examination readiness material gives you all that you must take a confirmation exam. Our Oracle 1Z0-117 Exam will come up with examination inquiries with showed solutions that mirror the real examination. High caliber and incentive for the 1Z0-117 Exam. We at killexams.Com are resolved to permit you to clear your 1Z0-117 accreditation take a l
Are you looking for Pass4sure Oracle 1Z0-117 Dumps containing real exams questions and answers for the Oracle Database 11g Release 2- SQL Tuning Exam prep? We provide most updated and quality source of 1Z0-117 Dumps that is http://Killexams.com/pass4sure/exam-detail/1Z0-117. We have compiled a database of 1Z0-117 Dumps questions from actual exams in order to let you prepare and pass 1Z0-117 exam on the first attempt.
Killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for all exams on website
PROF17 : 10% Discount Coupon for Orders greater than $69
DEAL17 : 15% Discount Coupon for Orders greater than $99
DECSPECIAL : 10% Special Discount Coupon for All Orders
High Quality 1Z0-117 products: we have our experts Team to ensure our Oracle 1Z0-117 exam questions are always the latest. They are all very familiar with the exams and testing center.
How we keep Oracle 1Z0-117 exams updated?: we have our special ways to know the latest exams information on Oracle 1Z0-117. Sometimes we contact our partners who are very familiar with the testing center or sometimes our customers will email us the most recent feedback, or we got the latest feedback from our dumps market. Once we find the Oracle 1Z0-117 exams changed then we update them ASAP.
Money back guarantee?: if you really fail this 1Z0-117 Oracle Database 11g Release 2- SQL Tuning and don