Oracle 053 124-185译文



在开发库rac0上,有6个 raw设备:/dev/raw/raw1到/dev/raw/raw6;  raw1-2每个8G,剩余的每个6G。已存在的磁盘组 +data1,普通冗余,使用raw1,raw2。.下面哪些命令将drop data1失败组中的1个;创建一个新的磁盘组+data2使用剩余4个raw设备中的2个;接着从data1中取消drop操作。

 

A.  ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;

 

CREATEDISKGROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK ‘/dev/raw/raw3’FAILGROUP DATA1B DISK ‘/dev/raw/raw4’;

ALTERDISKGROUP DATA1 UNDROP DISKS;

 

 

QUESTION NO:126

哪个类型的数据库文件可以扩展在磁盘组内的所有磁盘上。

A. All types of files are spread acrossall disks in the disk group.

B. Datafiles

C. Redo log files

D. Archived redo log files

E. Control files

Explanation:

QUESTION NO:127

如何反转alterdiskgroup…drop disk命令,如果该命令已经执行完毕…

A. Issue the ALTER DISKGROUP … ADD DISKcommand.

 

 

Explanation:

Use theundrop_disk_clause cancel the drop of disks from the disk group. This clause isnot relevant for disks that have already been completely dropped from the diskgroup or for disk groups that have been completely dropped.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1006.htm#i21687

80 Use the CREATEDISKGROUP clause to create a collection of disks.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5008.htm

Use the add_disk_clauseto add one or more disks to the disk group and specify attributes for the

newly added disk.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1006.htm#i21687

80

QUESTION NO:128---重点记住

下面哪个alter diskgroup命令不使用v$asm_operation去记录操作的状态?

A. ADD DIRECTORY

B. DROP DISK

C. RESIZE DISK

D. REBALANCE

E. ADD FAILGROUP

Explanation:

·   REBAL - Rebalance pending for this group. The diskgroup needs rebalance to complete.

·   COD - COD recovery pending for group. There are COD's that need to be recovered, These could be CODs which are part of the rebalance or CODs which are rolling back operations, such as file creations.

·   DSCV - Disk rediscovery pending. RBAL is doing disk discovery, probing the system for devices that ASM can use.

·   ACD - ACD grow chunk pending for group. New ASM instance has joined the cluster and this instance is growing the ACD to accommodate it.

·   RFRSH - PST refresh/disk expel required. Requesting PST refresh and asking the disk to be expelled after it is refreshed.

·   EXPEL - End of rebalance expel required. Background operation complete, winding down.

 

 

 

QUESTION NO:129

If you use ALTER DISKGROUP … ADD DISKand specify a wildcard通配符 forthe discovery string, what happens to disks that are already a part of the sameor another disk group?如果你使用alter diskgroup … add disk 且指定一个通配符在discovery string字符串上,什么将发生(磁盘已经作为相同的或者其他磁盘组的一部分)

D. The other disks, already part of thedisk group, are ignored.其他的磁盘,已经作为磁盘组中的一部分,将跳过。

 

Explanation:

QUESTION NO:130---重点理解

You are an Oracle DBAresponsible for an ASM instance. The disk controller on your system fails.Yoususpect that the disk itself is okay. You know it will take 24 hours to replacethe controller and you don't want to have to rebuild the disks from scratch. What do you do?

你是一个ASM实例的 DBA,你的系统的磁盘控制器失效。你怀疑硬盘本身是ok的。你知道它将花费24小时去代替控制器,你不想去重新修正磁盘。你做什么呢?

E. Change the attributeDISK_REPAIR_TIME on the disk group to a time greater than 24 hours.改变磁盘组上disk_repair_time属性到一个大于24小时的时间。

 

Explanation:

设定DISK_REPAIR_TIME这个属性使失效磁盘在被修复和再次联机这段时间内重新整理这样的操作不发生。这个时间可以以分钟(m或M)或者小时(h或H)为单位,如果你不指定时间单位,缺省的时间单位为小时。如果DISK_REPAIR_TIME这个属性没有设定,其缺省值为3.6小时。需要注意的是,这个缺省值适用于磁盘被设定为脱机模式而操作语句没有DROP AFTER子句这样的情况。大部分来说环境,3.6个小时这个DISK_REPAIR_TIME缺省属性数值应该都是合适的。

  注意:

  使用这项新功能,ASM磁盘组的兼容性需要设定至11.1或更高。

 

 

QUESTION NO:131

 (Choose two.) 作为DBA,你在你的ASM实例上运行以下查询。这个查询的结果的含义是?

SQL> select group_number, name, statefrom v$ASM_DISKGROUP;

 

GROUP_NUMBER NAME STATE

------------------------------------------ -----------

0 DGROUP1 DISMOUNTED

2 DGROUP2 MOUNTED

3 DGROUP3 MOUNTED

A. The DGROUP1 disk group was unmountedby another DBA. DGROUP1磁盘组被其他DBA unmounted

B. A datafile has been lost, causing the ASM disk groupDGROUP1 to go into the DISMOUNTED state

C. One of the redundant disks (DGROUP1) has been lost in adisk group.

D. This query has no meaning in an ASM instance.

E. A disk associated with a disk groupwas discovered after the ASM instance initially opened.  磁盘组中关联的磁盘被发现(在ASM实例初始打开后)

Explanation:

 

QUESTION NO:132

你的数据库处于Noarchivelog模式。你启动一个备份,但你的用户抱怨他们不想关闭数据库去执行备份。哪个选项对你来说是有效的。

C. You will have to wait until you canshut down the database to perform the backup.你将不得不等待直到你关闭数据库去执行备份。

 

Explanation:

 

 

QUESTION NO:133

当执行一个在线备份时,下列步骤正确的顺序是:

a. Issue the alterdatabase end backup command. 发起alter database endbackup命令

b. Back up the archivedredo logs. 备份归档重做日志

c. Issue the alterdatabase begin backup command. 发起alter databasebegin backup 命令

d. Back up the databasefiles. 备份数据文件

e. Determine thebeginning log sequence number. 判断log 序列号开始

f. Determine the endinglog sequence number.   判断log序列号结束

g. Force a log switchwith the alter system switch logfile command. 用alter systemswitch logfile 命令去强制切换。

A. a, b, c, d, e, f, g

B. c, d, a, b, e, g, f

C. f, d, b, g, a, c, e

D. e, c, d, a, g, f, b

E. a, f, b, g, e, c, d

Explanation:

 

QUESTION NO:134

你想将一个指定的表空间my_data放置进热备模式,因此你可以备份它。你使用哪个命令

What command would youuse?

A. alter tablespace MY_DATA beginbackup;

 

 

QUESTION NO:135

Which of the following actions would ensure that thechanges could be recovered using the 8 a.m. backup?

你在今天早晨8点使用在线备份进行数据库备份。会计在10点到正午期间对基础数据进行大量的修改。下面哪个行为能确保你能够使用8点的备份change可以被恢复?

B. Back up all the archived redo logsgenerated since the 8 a.m. backup.备份自8点备份依赖所产生的归档重做日志。

 

 

QUESTION NO:136

 (Choose two.) oracle11g中的日志模式?

B. NOARCHIVELOG mode

E. ARCHIVELOG mode

 

QUESTION NO:137

 

将数据库置于archivelog模式正确的命令是:

A. alter database archivelog

B. alter system enable archivelog mode

C. alter database enable archive

D. alter database archivelog enable

E. None of the above

 

Explanation:

QUESTION NO:138

 

执行一个在线数据库备份的正确的步骤?

a. alter database beginbackup;

b. alter database endbackup;

c. Back up the databasedatafiles.

d. Back up the archivelog files.

e. alter system switchlogfile;

 

E. a, c, b, e, d

 

 

QUESTION NO:139

?哪个命令将导致一个trace文件被创建(用create controlfile命令)

B. alter database backup controlfile totrace;

 

 

QUESTION NO:140

下列哪个是将表空间dave_tbs置于hot备份模式的有效途径

A. alter tablespace DAVE_TBS backup mode;

B. alter tablespace DAVE_TBS start backup;

C. alter tablespace DAVE_TBS beginbackup;

D. alter tablespace DAVE_TBS backup begin;

E. alter tablespace DAVE_TBS backup;

 

-------

 

QUESTION NO:141

Every Sunday the Unixsystem administrator has a job that executes a full backup of the entire Unixsystem your database is on. Is this backup usable for backup and recovery ofyour database?每个星期天,unxi系统管理员有个工作-执行一个基于unix系统(你数据库所在的unix系统)的完全的备份。这个备份是否可以用于你的数据库的恢复?

C. No, the backup is not usable in anyway.

 

Explanation:

QUESTION NO:142

备份一个控制文件的无效方法?

A. Backing up the control file to trace备份控制文件到trace

B. Copying the existing control file ofthe database to the backup location during a hot backup

C. Copying the existing control file of the database to thebackup location during a cold backup复制数据库的已存在的控制文件到备份位置(在冷备期间)

D. Creating a backup control file创建一个备份控制文件

E. Using the create controlfile command 使用create controlfile命令

 

Explanation:

QUESTION NO:143

Oracle应该创建归档重做日志的位置由下列哪个参数定义其位置??

D. LOG_ARCHIVE_DEST_1

 

Explanation:

QUESTION NO:144

Archived redo logs canbe copied to more than one destination by Oracle.归档重做日志可copy到多个目标位置(被Oracle)

A. True

B. False

 

Explanation:

QUESTION NO:145

下列配置的结果是什么?

Log_archive_dest_1=’location=c:\oracle\arch\mydb’

Log_archive_dest_2=’location=z:\oracle\arch\mydb’

C. Archived redo logs will be createdin two different locations by the ARCH process.归档重组日志将被创建在2个不同的位置,被 arch进程。

 

 

Explanation:

QUESTION NO:146

数据库中的数据文件的备份状态信息由哪个视图提供?

A. V$BACKUP

 

 

Explanation:

QUESTION NO:147

另一个DBA发起一个shutdown abort命令,在你运行在线备份时。当你尝试restart数据库时什么将发生?

C. Oracle will generate an error whentrying to open the database, indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.oracle将产生一个错误,当尝试打开数据库时,暗示一个数据文件处于hotbackup 模式。你打开数据库之前需要纠正这个错误哦。

 

Explanation:

QUESTION NO:148

What is the propercommand to shut down the database in a consistent manner?

D. shutdown immediate

 

QUESTION NO:149

 

如果你发起命令shutdown abort优先于去尝试去将数据库置于archivelog模式,当你发起命令alter database archivelog时的结果是?

A. The alter database archivelogcommand will fail.   Alter database archivelog命令将失败。

 

Explanation:

QUESTION NO:150

你的归档日志目标目录空间溢出。在数据库中,这个事件的影响是?

E. Once Oracle has cycled through allonline redo logs, it will stop processing any DML or DDL until the out-of-spacecondition is corrected.一旦oracle已经循环了所有在线重做日志以后,它将停止处理所有的DML或DDL直到空间溢出问题纠正。

 

Explanation:

QUESTION NO:151

多少个独立的归档日志目标目录可以在oracle11g中支持:

A. 7

B. 1

C. 10

D. 11

E. 21

 

Explanation:

QUESTION NO:152---重点

你的数据库经历了一个丢失的数据文件users_01.dbf,对应的表空间是users。数据库仍在运行。哪个answer正确描述了你恢复这个错误的步骤

a. Shut down thedatabase.关闭数据库

b. Take the users_01.dbf datafile offline with the alter database command.将users_01.dbf数据文件offline,用alter database命令

 

c. Restorethe users_01.dbf datafilefrom backup media with the required archivedredo logs. 还原users_01.dbf数据文件(从备份介质管理中,用需要的归档重做日志)

d. Restore all userstablespace-related datafiles from backup media.还原所有的用户表空间关联的数据文件(从备份介质中)

e. Issue the recovertablespace users command.发起恢复表空间users命令

f. Issue the recoverdatafile users_01.dbf command. 发起recover数据文件users_01.dbf命令

g. Start up thedatabase.启动数据库

h. Bring the users_01.dbf datafile online with the alter database command.将users_01.dbf文件online。

 

--datafileoffline---restore datafile---recover datafile---datafile online

A. a, c, f, g

B. b, c, f, h

C. a, b, c, f, g

D. a, b, c, f, g, h

E. b, c, f, e, g

 

QUESTION NO:153

一旦你发现你丢失了一个在线重做日志文件,如果数据库仍然能用,你首先要做的是?

D. Checkpoint the database. 对整个数据库执行checkpoint

 

Explanation:

QUESTION NO:154

你已经丢失你的所有的SYSTEM表空间的数据文件(system01.dbf和system02.dbf),数据库已经崩溃。纠正这个问题的操作顺序?

 

a. Mount the database with the startup mount command.

b. Take the SYSTEMdatafile offline with the alter database command.

c. Restorethe SYSTEM_01.dbf datafile from backup media with the required archived redologs.

d. Restore all SYSTEM tablespace–related datafiles frombackup media.

e. Issue the recover tablespace SYSTEM command.

f. Issue the recoverdatafile SYSTEM_01.dbf command.

g. Open the database with the alter database opencommand.

h. Open the databasewith the alter database open resetlogs command.

 

Restore systemfile--Startup mount---recover system表空间—open数据库

A. a, c, f, g

B. b, d, e, h

C. a, b, c, f, g

D. d, a, e, g

E. b, c, f, e, g

 

Explanation:

QUESTION NO:155

?你已经发现3个控制文件中的某个已经丢失。如何去恢复你的控制文件?

a. Shut down the database.

b. Restore acontrol-file copy from backup media.

c. Use the createcontrol file command to create a new control file.

d. Copy the backupcontrol file into place.

e. Create a new copy of the control file from one of thesurviving control files.

f. Recover the databaseusing the recover database using backup controlfile command.

g. Start up the database.

关闭数据库----创建一个控制文件的副本---启动数据库

A. a, b, f, g

B. c, f, g

C. a, d, f, g

D. a, f, g

E. a, e, g

 

Explanation:

QUESTION NO:156

 (Choose all that apply.)你需要哪些文件执行一个完全恢复,使用在非归档模式下的数据库的备份??

A. Database datafiles

B. Control files

C. Archived redo logs

D. Online redo logs

E. Flashback logs

 

 

Explanation:

QUESTION NO:157

如果数据库尚未崩溃,如何处理在线重做日志丢失的情况?

 

a. Issue a checkpoint.

b. Shut down thedatabase.

c. Issue an alterdatabase open command to open the database.

d. Startup mount thedatabase.

e. Issue an alterdatabase clear logfile command.

f. Recoverall database datafiles.

发起一个检查点---shutdown数据库---startup mount---alter database clear logfile---alterdatabase open;

A. a, b, c, d

B. b, d, e, c

C. a, b, d, e, c

D. b, f, d, f, c

E. b, d, a, c

 

 

QUESTION NO:158

 (Choose all that apply.)基于时间点恢复的方法有效的是:

A. Change-based  基于修改

B. Cancel-based   基于cancel

C. Time-based     基于时间

D. Sequence number-based   基于SCN

E. Transaction number-based

 

 

QUESTION NO:159与156题目的区别,一个归档一个非归档模式

(Choose three.) 处于归档模式的数据库的一个完全恢复,需要的文件有哪些?

A. Database datafiles数据库数据文件

B. Online redo logs

C. Archived redo logs归档重做日志文件

D. Backup control file备用控制文件

E. Control file from a backup

 

QUESTION NO:160

恢复一个丢失tempfile文件的正确的过程

E. Re-create the tempfile with thealter tablespace command.用alter tablespace命令重建tempfile文件。

 

QUESTION NO:161

当启动你的数据库时,你接收到一下错误信息。

SQL> startup

ORACLE instance started.

Total System Global Area171581440 bytes

Fixed Size 1 298640bytes

Variable Size 146 804 528bytes

Database Buffers 20 971 520bytes

Redo Buffers 2 506 752bytes

Database mounted.

ORA-00313: open failed for members of log group 1 ofthread 1

ORA-00312: online log 1 thread 1:'/oracle01/oradata/orcl/redo01.log'

ORA-00312: online log 1 thread 1:'/oracle01/oradata/orcl/redo01a.log'

You can choose from the following steps:你可以从以下步骤中选择:

 

a. Restorethe database datafiles.还原数据库的数据文件

b. Issue the alter database clear unarchived logfilegroup 1 command.发起alter databaseclear unarchived logfile group 1 命令

c. Issue the alter database open command.发起alter databaseopen命令

d. Issue the alterdatabase open resetlogs command.发起alter database open resetlogs命令

e. Recoverthe database using point-in-time recovery.基于时间点的数据库恢复

f. Issue the Startup Mount command to mount the database.发起startup mount命令

g. Back up the database.备份数据库

Which is the correctorder of these steps in this case?

Startup mount—alterdatabase clear unarchived logfile---open—backup database;

 

A. a, f, e, d, g

B. f, e, d

C. f, b, c, g

D. a, f, c

E. The database cannot be recovered.

 

 

QUESTION NO:162

一个用户发送你一个email有以下错误消息:

create table idtable(idnumber)

*

ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4:‘/oracle01/oradata/orcl/users01.dbf’

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

 

You can choose from thefollowing steps:

 

a. Restore the missing database datafiles.还原丢失的数据库文件

b. Take the missing datafile offline.将丢失的数据文件offline

c. Shut down thedatabase. 关闭数据库

d. Issue the recover tablespace USERS command.发起recover表空间users命令

e. Issue the StartupMount command to mount the database.发起启动mount命令

f. Bring the USERS tablespace online.将users表空间Online

g. Issue the alterdatabase open command.  发起打开命令

 

在这个案例中纠正问题的步骤

A. b, a, d, f

B. c, a, e, b, d, f, g

C. c, e, d, g

D. b, d, f

E. e, d, g

 

QUESTION NO:163

你已经丢失了所有的控制文件。为了恢复它们,你正在使用alter database backup controlfile to trace命令的结果。你的数据文件和你的在线重做日志文件都是完整的all intact。关于你的恢复正确的步骤是:

D. You will use the noresetlogsversion of the create controlfile command.

 

 

Noresetlogs与resetlogs的区别:noresetlog保留在线重做日志文件可用。

 

1\Alter  database backup  controlfile to trace  noresetlogs;将控制文件所记载的物理信息备份到跟踪文件,然后使用该跟踪文件建立控制文件。

2\Show parameteruser_dump_dest

3\Select a.spid fromv$process a,v$session b where a.addr=b.paddr and b.username=’SYS’;

4\打开trc文件,去掉跟踪文件的说明信息、注释信息等无关信息之后,剩余就是用于重新建立控制文件的全部内容。

Create controlfilereuse database ‘sid’ noresetlogs archivelog……

 

QUESTION NO:164

你的开发者请求你去还原开发库,处于非归档模式,还原到20号周2,。你最后的备份是19号周1,。你应该做什么?

B. Tell them that their request cannotbe met with the current backup strategy.告诉他们,他们的请求不能满足(用当前备份策略)

 

 

QUESTION NO:165

(Choose all that apply.)恢复丢失的控制文件的方法有效的是?

A. Backup control file.

B. Emergency control file.

C. The create controlfile command.

D. The restore controlfile SQL*Pluscommand.

E. No backup is required. The database will re-create thecontrol file when it is discovered to be lost.

 

QUESTION NO:166(Jesse)

 

You can choose from thefollowing steps to recover your database:你的归档模式数据库已经丢失了3个数据文件且关闭。一个指向SYSTEM表空间;2个指向users表空间。你可以从以下步骤中选择去恢复你的数据库

a. Restore the threedatabase datafiles that were lost.还原3个数据库文件

b. Issue the StartupMount command to mount the database. Startup mount

c. Issue the alterdatabase open command.   open

d. Issue thealter database open resetlogs command.  Openresetlog

e. Recover the databaseusing the recover database command.  Recoverdatabase

f. Recover the datafileswith the recover datafile command.  Recoverdatafile

g. Take thedatafiles offline.    

 

Restoredatafile---startup mount---recover ---open database

在本case中正确的步骤是:

A. a, b, e, c

B. b, e, d

C. a, b, d, c

D. b, g, c, f

E. a, b, d, f

 

QUESTION NO:167 (Jesse)

你丢失了所有的在线重做日志文件。作为结果,你的数据库已经崩溃。你尝试restart数据库和清空在线重做日志文件,但当你尝试打开数据库时发生以下错误:

SQL> startup

ORACLE instance started.

Total System Global Area167395328 bytes

Fixed Size 1298612 bytes

Variable Size 142610252bytes

Database Buffers20971520 bytes

Redo Buffers 2514944bytes

Database mounted.

ORA-00313: open failed for members of log group 2 ofthread 1

ORA-00312: online log 2 thread 1: ‘/oracle01/oradata/orcl/redo02a.log’

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00312: online log 2 thread 1:‘/oracle01/oradata/orcl/redo02.log’

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

SQL> alter database clear logfilegroup 2;

alter database clearlogfile group 2

*

ERROR at line 1:

ORA-01624: log 2 neededfor crash recovery of instance orcl (thread 1)

ORA-00312: online log 2thread 1: ‘/oracle01/oradata/orcl/redo02.log’

ORA-00312: online log 2thread 1: ‘/oracle01/oradata/orcl/redo02a.log’

What steps must you take to resolve the error?

 

a. Issue therecover database redo logs command.

c. Restore the last fulldatabase backup.还原最后完整数据库备份

e. Restore all archivedredo logs generated during and after the last full database backup.还原最后完整数据库备份以后产生的所有归档重做日志文件

 

b. Issue the StartupMount command to mount the database.启动startup mount命令去绑定数据库

 

d. Perform apoint-in-time recovery, applying all archived redo logs that are available. 执行基于时间点的恢复,应用所有归档重做日志文件有效的

f. Open the databaseusing the alter database open resetlogs command.

使用alterdatabase open resetlogs命令去打开数据库

g. Issue thealter database open command.

A. b, a, f

B. e, b, a, f

C. e, b, a, g

D. b, a, g

E. c, e, b, d, f

 

QUESTION NO:168

SCN代表什么?

A. The system change number, which is apoint in time relative to transactions within a given database.  代表系统修改号,在给定的数据库内部的事务相关的时间点。

 

QUESTION NO:169

你已经丢失了4个数据库文件。还原你的数据库最快的途径是:

A. Restore and recover the datafile.还原和恢复数据文件

 

 

QUESTION NO:170

你尝试去恢复你的数据库。在恢复期间,你接收到以下错误信息:

ORA-00279: change5033391 generated at 08/17/200806:37:40 needed for thread 1

ORA-00289: suggestion :

/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arc

ORA-00280: change5033391 for thread 1 is in sequence #11

ORA-00278: log file

‘/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_10_4bj6wnqm_.arc’no longer needed for this recovery

Specify log:{<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log

‘/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arc’

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information:3

 

对应这个错误,你应该怎么做?(Choose two.)

A. Restore the archived redo log thatis missing and attempt recovery again.还原归档重做日志(已经丢失),尝试再次recovery

C. Recovery needs redo that is notavailable in any archived redo log. Attempt to apply an online redo log ifavailable.恢复需要重做日志(在所有的归档重做日志中是无效的)。尝试应用一个在线重做日志(如果有效的话)。

 

 

 

QUESTION NO:171

 (Choose all that apply.)在恢复期间,你需要知道,日志序列11是否在在线重做日志中,因此,你需要知道在线重做日志的文件名,在恢复期间你可以应用他们。哪些视图可以被用于去判断这些信息?

A. V$LOGFILE

B. V$RECOVER_LOG

C. V$RECOVER_DATABASE

D. V$LOG_RECOVER

E. V$LOG

 

QUESTION NO:172

怎样启用block-changetracking

A. With alter database enable blockchange tracking

B. With alter system enable block change tracking

C. With an init.ora parameter change

D. With an spfile parameter change

 

QUESTION NO:173

 

那种类型的备份存储在专属proprietary的RMAN格式。

A. Backup set

 

QUESTION NO:174

考虑以下命令

Backup databaseplus archivelog delete input;

:如果正确的,通过这个命令可以创建的备份集数量?

Control-file a NN uto backups wereenabled.

NN    The size of backup sets was not restricted.

NN    Onechannel was allocated.

A. 1

B. 2

C. 3

D. 4

E. 5

 

 

backup database plusarchivelog delete input;     (备份全库及控制文件、服务器参数文件与所有归档的重做日志,并删除旧的归档日志)

 

QUESTION NO:175

哪个命令创建了一个image copy

A. backup as copy

 

 

QUESTION NO:176

compressed backups压缩备份一般和下面哪些命令一起工作

C. backup

 

 

QUESTION NO:177

哪个命令可以去备份数据库,备份归档日志,接着删除备份过的归档重组日志?

D. backup database plus archivelogdelete input

 

 

QUESTION NO:178

哪个是fullbackup最佳描述?

 

D. All the used blocks in a datafile

 

 

QUESTION NO:179

?哪种类型的备份只备份(自相同级别或较低级别的最近的备份)以来的修改的数据块

A. Differential incremental backup差异增量备份

B. Different incremental backup

 

QUESTION NO:180

Which type of backupmust be performed firstwith an incrementalbackup?

备份的哪种类型必须被首先执行,关于一个增量备份。

A. Level 1

B. Level 0

C. Level 2

D. Level 3

 

QUESTION NO:181

 

哪个备份选项定义了一个用户自定义的名字(为备份)

C. TAG

 

QUESTION NO:182

给出下列步骤,哪个是正确的顺序去创建一个非归档模式下的oracle数据库的备份

a. shutdown immediatefrom RMAN 从RMAN下shutdown Immediate

b. Log into RMAN                               登陆到RMAN

c. startup mount fromRMAN       从RMAN下startupmount

d. backup database               备份数据库

e. alter database open             打开

f. backupdatabase plus archivelog delete input  

A. b, c ,a, d, e

B. b, a, c, f, e

C. a, c, e, d

D. b, a, c, e, f

E. b, a, c, d, e

 

QUESTION NO:183

 

下面哪个最接近image copy

 

A. Unix cp command of a file

B. Bit-by-bit copy of a file

C. Windows COPY command of a file

D. All of the above

 

QUESTION NO:184

哪个动态视图显示了block-change tracking

B. V$BLOCK_CHANGE_TRACKING

 

QUESTION NO:185

什么功能comes into play积极作用有助于确保备份的完成,3个备份设备中一个1个失败(在使用3个不同的通道进行备份期间)。

A. Channel failover

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值