oracle 12c ocp

Just passed OCP last exam, from the training to review and complete the exam for a total of one months, the whole process is very compact also very nervous, very lucky or passed the exam, also not in vain this month's hard. First is the training, has been engaged in development work, although also has been using the Oracle database, but is not a DBA, so for the training of DBA knowledge is very important,

July 8, 2013, Oracle China announced that the company's new generation of database oracle12c officially listed, and can be downloaded through the Oracle Technology Network (OTN). The product was released by CEO Larry Ellison at Oracle's global convention as early as October 1, 2012, and after 9 months of waiting, users can finally use Oracle's most heavyweight products. Compared with Oracle's previous gener

Tags: io os ar using the for SP file div onSince Oracle 12c is already a multitenant architecture, there are a few things to consider when using Ogg synchronization A CDB contains multiple PDB, and one extract of the source-side deployment can access all PDB redo, which theoretically does not require a separate configuration of extract per PDB. Extraction mode can only be integrated (integrated

/enmoeduDiag Trace /u01/app/oracle/diag/rdbms/enmoedu/enmoedu/traceDiag Alert /u01/app/oracle/diag/rdbms/enmoedu/enmoedu/alertDiag Incident /u01/app/oracle/diag/rdbms/enmoedu/enmoedu/incidentDiag Cdump /u01/app/oracle/diag/rdbms/enmoedu/enmoedu/cdumpHealth Monitor /u01/app/

non-routine recovery of Oracle 12C CDB database without database backupFamiliar with Dul friends know Dul is file# 1 Block 1 kcvfhrdb find bootstarp$ Segment Header (in fact Kcvfhrdb is bootstarp$ segment Header RDBA address), Then through the related SQL stored in the bootstarp$ to find some base table objects (obj$,tab$,col$,seg$, etc.), and then through their positioning to the specific object of the seg

Tags: 11g OCP database Oracle Certification Exam Exam QuestionsQUESTION 1You notice the performance of the database have degraded because of frequent checkpoints.Which resolve the issue? (Choose.)A. Disable Automatic checkpoint TuningB. Check the size of the redo log file size and increase the size if it is smallC. Set the Fast_start_mttr_target parameter as per the advice given by the MTTR AdvisorD. Decrea

= Db_name)))(3) External name resolutionLDAP Directory server1.7 Monitoring ManagerListener configuration file: $ORACLE _home/network/admin/listener.oraDefault listener host 1521 port.LISTENER =(Description_list =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = hostname) (PORT = 1521))(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))))The listener can use the NETCA program configuration.Listener Control Program Lsnrctl:Start Start listenerStop Stop L

references to outdated backups from the warehouseDelete Obsolete--remove any unwanted backups from the disk or tape and remove the backup references from the warehouse.Catalog-The location of the user-managed backup is included in the warehouse. 2) Archive Backup: Backup XXX Keep {forever | until time xxxx} [restore point xxxx]-----The restore point xxxx is the name in the control file.V$archived_log still exists after the archive log is removed:Rman Target/Rman> crosscheck Archivelog All;rma

PARENT 1 2005-06-30:19:09:402 2 ORCL 1316499950 PARENT 446075 2012-07-15:16:40:153 3 ORCL 1316499950 PARENT 604802 2012-08-08:10:35:104 4 ORCL 1316499950 CURRENT 607329 2012-08-08:11:28:40 Alter database open resetlog allows sequence # To start from serial number 1 againOracle created a backup when sequence # is 100 and crashed when sequence # is 400, because you only haveTherefore, you can only r

Environment: idle> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for Linux: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 - Production Under assm The size of this parameter is the minimum value of the shared pool. The allocated value cannot be lower th

QUESTION 2Identify the memory component from which memory is allocated for:session memory for the shared server, buffers for I/O Slaves Oracle Database Recovery Manager (RMAN) Backup and restore operationsA. Large PoolB. Redo Log BufferC. Database Buffer CacheD. Program Global Area (PGA)Correct answer:a Explanation/reference:Large PoolThe large pool is a optional memory area intended for memory allocations, is larger than was appropriate

Tags: oracle 11g OCP test Bank Analysis certification Exam TU Institute Oracle Oracle OCP Certification ExamQUESTION 4In which of the scenario would the DBA perform recovery? (Choose all, apply.)A. The alert log file is corruptedB. A Tablespace is accidentally droppedC. One

, indexes, partitions, and more.SQL Tuning Advisor: can provide materialized views, indexes, partitions and other suggestions; run automatically in the Maintenance window.Small difference: SQL Tuning advisor adjusts each SQL statement individually; SQL Access Advisor adjusts all SQL statements at the same time.27.Database Configuration Assistant: In the Nomount State, only the service is deleted and the data is not deleted.28.Automatic Workload reporsitory (AWR): Automated Workload repositoryThe

Oracle OCP 11G 053 (1-200) Answer resolution directory 　 V13.02 version, 711 questions File version:3.2,200 problem version:5.4 1 http://blog.csdn.net/rlhua/article/details/16369867 490 2 http://blog.csdn.net/rlhua/article/details/16527169 491 3 http://blog.csdn.net/rlhua/article/details/14057145 142 7

Tags: Image type LLB Oracle POI IMG Abort IMA wait30, which is true when a database instance are shut down?A. Only transactional and normal modes wait for all uncommitted transactions to commit or rollback and then close the data Base.B. Immediate, transactional, and normal modes all result in a checkpoint.C. Neither the immediate nor the Abort mode rolls back uncommitted transactions.D. Immediate, transactional, and normal modes wait for all uncommit

Tags: Modify OCA res scope control File View 11g routed iOS1. Understanding Backup and Recovery issuesThree indicators related to backup recovery are: MTBF average trouble-free timeMTTR mean failure recovery time.Data loss: How much to lose the book data.There are three advanced options for Oracle RAC Steam and DG that have an impact on performance (good bad)2. Type of failure1) Statement failure: DML statements are rolled back, other DML statements a

free space in the data block, the new state of the block is reflected in the bitmap. By using bitmaps, the Oracle DB You can increase the degree of automation in managing free space. Therefore, this type of space management is called "Automatic segment Space Management (ASSM)".Manual: This method specifies that you want to use an idle list to manage free space in a segment. A free list is a list of blocks of data that have space to insert rows. Becau

In previous versions of Oracle 12C, if you wanted to achieve column growth, you would need to implement a sequence + trigger, and then 12C ORACLE introduced the Identity columns new feature, enabling the column to grow, and Mysql,sql server-like functionality.Using syntaxORACLE 12C