ORACLE DATABASE BACKUP AND RECOVERY ADVANCED USERS GUIDE 11G

Oracle)Tivoli Storage Manager. See TSM (Tivoli Storage Manager)tnsnames.ora filecreating for remote RMAN backups, 37creating single-node standby database from RAC, 514duplicating RAC database on single-node database, 511duplication to remote server using disk backups, 486[r]

The parameters in the parameter file are used to build the SGA in memory and to start the background processes. Entries will be written out to the alert log describing this process. Where is the alert log? In the location given by the BACKGROUND_DUMP_DEST parameter, that can be found in the p[r]

production systems.Finally, SYS and SYSTEM passwords are initialized, and spooling to the log is switched off.This one file with the CREATE DATABASE command will create a database. After its successful execution, you will have an instance running in memory, and a <[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide96 18. What tools can be used to manage templates? (Choose one or more correct answers.) A. The Database Configuration Assistant B. The Database Upgrade Assistant C. SQL*Plus D. Database Control[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide126TIP There is some overlap between V$ views and data dictionary views. For instance, V$TABLESPACE has a row for every tablespace, as does DBA_TABLESPACES. Note that as a general rule, V$ views are singular <[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide136A Word on Oracle Net and Communication ProtocolsOracle Net is a layered protocol: it runs on top of whatever communications protocol is supported by your operating system. Historically, Sqlnet could[r]

Within the database there is a set of tables and other segments called the data dictionary. The data dictionary describes all the logical and physical structures in the database, including all the segments that store user data.The process of database creation estab[r]

Oracle blocksOperatingsystem blocksDatafilesThe physical structures:Figure 1-8 The Oracle logical and physical storage hierarchyChapter 1: Architectural Overview of Oracle Database 11g47PART Idictionary is part of the database creation process. It is maintai[r]

instance is started and run until it is terminated. There are five background processes that have a long history with Oracle; these are the first five described in the sections that follow: System Monitor (SMON), Process Monitor (PMON), Database Writer (DBWn), Log Writer (LGWR),[r]

usually be present (there are others, needed for advanced options) are the initialization parameter file, the password file, the archive redo log files, and the log and trace files.EXAM TIP What three file types must be present in a database? The controlfile, the online r[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide66of the directory into which the file was unzipped, viewed from a command window. Note the presence of the readme.html file. This contains the product release notes—open it in a browser, and read them. 3. Con[r]

TIP It can be very difficult to work out why you can see certain data. You may have been granted the SELECT privilege on specific objects; you may have been granted the ALL privilege; you may have SELECT ANY; SELECT may have been granted to PUBLIC; or you may have a role to which SELECT has been gra[r]

Permanent objects (such as tables) are stored in permanent tablespaces; temporary objects are stored in temporary tablespaces. A session will need space in a temporary tablespace if it needs space for certain operations that exceed the space available in the session’s PGA. Remember that the PGA is t[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide216 3. Confirm that the users have been created with Database Control. From the database home page, the navigation path is the Server tab and the Users link in the Security section.[r]

Logons are audited with AUDIT SESSION. For example,SQL&gt; audit session whenever not successful;This is equivalent to auditing the use of the CREATE SESSION privilege. Session auditing records each connection to the database. The NOT SUCCESFUL keywords restrict the output to only failed[r]

select * from hr.emp where employee_id=0; no audit record is generated. Why might this be? (Choose the best answer.) A. You are connected as SYS, and the parameter AUDIT_SYS_OPERATIONS is set to FALSE. B. The AUDIT_TRAIL parameter is set to NONE. C. The statement did not access any rows; ther[r]

system blockDChapter 5: Oracle Storage199PART I 2. Which statements are correct about extents? (Choose all correct answers.) A. An extent is a consecutive grouping of Oracle blocks. B. An extent is a random grouping of Oracle blocks. C. An extent can be distributed across one or[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide146user interface. For all the commands, you must specify the name of the listener, if it is not the default name of LISTENER. Figures 4-6 and 4-7 show how to check the status of a listener and to stop[r]

OCA/OCP Oracle Database 11g All-in-One Exam Guide166Self Test 1. Which protocols can Oracle Net 11g use? (Choose all correct answers.) A. TCP B. UDP C. SPX/IPX D. SDP E. TCP with secure sockets F. Named Pipes G. LU6.2 H. NetBIOS/NetBEUI[r]

163PART Ireduce performance. It is quite possible that any one statement will take longer to execute in a shared server environment than if it were executing on a dedicated server, because it has to go via queues. It may also take more CPU resources because of the enqueuing and dequeuing acti[r]