Learn Database Concepts

1Z0-051 dump pdf free download - Oracle 11g SQL Fundamentals I    Download Here:  1Z0-051-1 Download Here:  1Z0-051-2   Exam Details :  Oracle Database 10g and 11g: SQL Fundamentals I 1Z0-051 Exam Number: 1Z0-051 Associated Certifications: Oracle Database 11g Administrator Certified Associate  Exam Product Version: SQL and PL/SQL,   Exam Price: US$ 125 Duration: 120 minutes Number of Questions: 70 Passing Score: 60% Validated Against: Exam 051 has been validated against Oracle Database 10g and 11g Release 2 version 11.2.0.1.0. format: Multiple Choice  Link to get more info on certification : OCA-1Z0-051 For more info on Certification program rules click : here Exam Topics: Retrieving Data Using the SQL SEL...

 Oracle Certified Associate - OCA 1Z0-052 dump pdf free download - Oracle 11g Database Administration I Download Here :  1Z0-052 Exam Details : Oracle Database 11g: Administration I 1Z0-052 Exam Number: 1Z0-052 Associated Certifications: Oracle Database 11g Administrator Certified Professional    Exam Product Version: Oracle Database 11g, Exam Price: US$ 245 Duration: 90 minutes Number of Questions: 70 Passing Score: 66% Validated Against: The exam has been validated against Oracle® Database 11 g Release 2 version 11.2.0.1.0. format: Multiple Choice

 Applying CPU Patch On Primary Database Server Environment.  Step 1: Incase if you have standby server. Now disable log shipping on the primary database by setting the log_archive_dest_state_2 to disable. As I said earlier, parameter log_archive_dest_2 on my primary database is set to point to the standby database. SQL> alter system set log_archive_dest_state_2=disable; System altered. Step 2: Shutdown the Primary database and stop the listener running on the primary database server.   [oracle@PRIM ~]$ sqlplus sys/"as sysdba" SQL*Plus: Release 11.2.0.2.0 Production Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, DataMining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edit...

Here is a brief explanation on how to apply CPU(Critical Patch Update) in a dataguard environment In this demo, I am applying PSU 11.2.0.4.2 on the Primary and standby databases. Standby  Database Name :ORCL_STBY Primary  Database Name : ORCL Primary Server: [oracle@PRIM ~]$ sqlplus sys / oracle@srprim as sysdba SQL * Plus: Release 11.2 . 0.2 . 0 Production on Tue Sep 18 10 : 43 : 50 2012 Copyright (c) 1982 , 2010 , Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2 . 0.2 . 0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, DataMining and Real Application Testing options SQL> select status,instance_name,database_role from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - OPEN                ORCL         ...

Rman Time-based PITR run { allocate channel dev1 type disk; set until time "to_date('2014-03-24:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')"; restore database; recover database; } or run { allocate channel dev1 type disk; set until time "to_date('2014-03-25:00:00', 'yyyy-mm-dd:hh24:mi')"; restore database; recover database; } Rman Time-based Controlfile PITR run { SET UNTIL TIME "TO_DATE('20140323:12:01','YYYYMMDD:HH24:MI')"; RESTORE CONTROLFILE FROM AUTOBACKUP preview; }

[oracle@orcl01 dbcapture]$ sqlplus /"as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 20 10:26:01 2013 Copyright (c) 1982, 2007, Oracle.  All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options It looked like a nice addition because, as others have pointed out on their blogs, it could prove very useful for capturing an application workload on 10g to test how it will work on 11g before upgrading. There's a genuine business need for that. Then, having updated our first couple of test instances at work, I was reminded of the great care we take with license management at my current site (thanks, Tam) and, on closer inspection of the documentation :- The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems. I ha...

 CORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 Problem Summary  --------------------------------------------------- CORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 sequence 7677 Problem Description --------------------------------------------------- Primary database is in MAXIMUM PERFORMANCE mode Thu Jun 05 13:38:37 2014 RFS[2849]: Assigned to RFS process 5367 RFS[2849]: Opened log for thread 1 sequence 7677 dbid 752265984 branch 834506114 RFS[2850]: Assigned to RFS process 5369 RFS[2850]: Selected log 6 for thread 1 sequence 7678 dbid 752265984 branch 834506114 CORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 sequence 7677 Thu Jun 05 13:44:36 2014 RFS[2851]: Assigned to RFS process 5801 RFS[2851]: Opened log for thread 1 sequence 7636 dbid 752265984 branch 834506114 CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 1 sequence 7636...

System datafile recovery: Lets create a scenario where we will drop the system datafile, and we will recover using the rman restore and recover process.Since system datafile is key for database functioning. Before we start. Lets verify that database is functioning without any problems. [oracle@linux1 ~]$ sqlplus /"As sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 7 20:47:23 2014 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select count(*) from scott.emp;   COUNT(*) ----------         14 Lets drop system datafile now. [oracle@linux1 orcl]$ ls control01.ctl  redo03.log          standby_redo04.log  users01.dbf example01.dbf  standby_redo01.log  sysaux01.dbf redo01.log     standby_redo02.log  system01.dbf ...

Full database recovery : We will create a scenerio where we will drop all the datafiles and do a full database recovery. Database name : ORCL Assuming that you have already taken the full database backup (if not please take the full backup before your perform this test/task). Database is running in archive-log mode, if not to have a consistent backup you need to shutdown the database open it in Mount mode and take a full backup. -----------      If you haven't taken backup do so (please see below)   ------ [oracle@linux1 ~]$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jul 7 20:20:55 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connected to target database: ORCL (DBID=1378116623) RMAN>  backup database tag"full_backup"; Starting backup at 07-JUL-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=125 device type=DISK channel...