OCP-052考试题库汇总(32)-CUUG内部解答版

简介: Which state must a database be to enable ARCHIVELOG ?A)NOMOUNTB)OPEN IN READ WRITE modeC)OPEN IN READ ONLY modeD)OPEN IN RESTRICTED modeE)MOUNT...

Which state must a database be to enable ARCHIVELOG ?

A)NOMOUNT

B)OPEN IN READ WRITE mode

C)OPEN IN READ ONLY mode

D)OPEN IN RESTRICTED mode

E)MOUNT

Answer: E

赵:

题译:数据库必须是哪个状态才能启用 ARCHIVELOG?

oracle 启动分为三步:

nomount --根据参数文件启动实例(instance)

mount --加载控制文件,让实例和数据库相关联

open --根据控制文件找到并打开数据文件和日志文件,从而打开数据库

Oracle 的归档(ARCHIVELOG)模式启动和关闭:

1、登录数据库:

sqlplus / as sysdba

2、查看当前归档模式

archive log list;

3、关闭数据库

可以使用 shutdown immediate;或者 shutdown normal ,若一直等待,执行 shutdown abort

4、mount 状态启动数据库

startup mount;

5、归档模式操作

启用归档模式:alter database archivelog;

关闭归档模式:alter database noarchivelog;

6、启动数据库

alter database open;

目录
相关文章
OCP-052考试题库汇总(59)-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
2827 0
|
数据库管理
OCP-052考试题库汇总(46)-CUUG内部解答版
Examine this command: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Whi...
770 0
|
SQL 数据库 关系型数据库
OCP-052考试题库汇总(43)-CUUG内部解答版
Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes.
2131 0
|
XML SQL 数据库
OCP-052考试题库汇总(41)-CUUG内部解答版
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE ----...
890 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(33)-CUUG内部解答版
Which two can be exported by a non-administrative account by using Data Pump? A)directory objects B)tables C)tablespaces D)schemas E)database Answer: BD 赵: EXP 和 IMP 是客户端工具程序,它们既可以在客户端使用,也可以在服务端使用。
648 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(31)-CUUG内部解答版
which four are true about the tools used to administer Oracle database? A)the Data Pump utility can be used to load data from text files.
792 0
OCP-052考试题库汇总(27)-CUUG内部解答版
Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file.
512 0
|
Oracle 关系型数据库 数据库
OCP-052考试题库汇总(28)-CUUG内部解答版
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, and not specified.
611 0
|
数据库
OCP-052考试题库汇总(26)-CUUG内部解答版
Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSAUX tablespace. E)spfile Answer: ABC 赵: 1 nomount:实例已经启动,进程和内存已经分配。
675 0
OCP-052考试题库汇总(24)-CUUG内部解答版
Which structure can span multiple data files? A)a bigfile tablespace B)a permanent tablespace C)a segment D)a temporary tablespace E)an extent Answer...
410 0

热门文章

最新文章