OCP-1Z0-053-V12.02-546题
来源:互联网 发布:魔兽世界巨鹰飞行网络 编辑:程序博客网 时间:2024/06/05 02:40
546.You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up.
What command would you use?
A. alter tablespace MY_DATA begin backup;
B. alter tablespace MY_DATA start backup;
C. alter tablespace MY_DATA backup begin;
D. alter MY_DATA begin backup;
E. You cannot back up individual tablespaces.
Answer: A
答案解析:
Making User-Managed Backups of Online Read/Write Tablespaces
You must put a read/write tablespace in backup mode to make user-managed data file backups when the tablespace is online and the database is open.
The ALTER
TABLESPACE
...
BEGIN
BACKUP
statement places a tablespace in backup mode.
In backup mode, the database copies whole changed data blocks into the redo stream. After you take the tablespace out of backup mode with the ALTER
TABLESPACE
...
END
BACKUP
or ALTER
DATABASE
END
BACKUP
statement, the database advances the data file checkpoint SCN to the current database checkpoint SCN.
When restoring a data file backed up in this way, the database asks for the appropriate set of redo log files to apply if recovery is needed. The redo logs contain all changes required to recover the data files and make them consistent.
To back up online read/write tablespaces in an open database:
Before beginning a backup of a tablespace, use the
DBA_DATA_FILES
data dictionary view to identify all of the data files in the tablespace. For example, assume that you want to back up theusers
tablespace. Enter the following:SELECT TABLESPACE_NAME, FILE_NAMEFROM SYS.DBA_DATA_FILESWHERE TABLESPACE_NAME = 'USERS';TABLESPACE_NAME FILE_NAME------------------------------- --------------------USERS /oracle/oradata/trgt/users01.dbfUSERS /oracle/oradata/trgt/users02.dbfMark the beginning of the online tablespace backup. For example, the following statement marks the start of an online backup for the tablespace
users
:SQL> ALTER TABLESPACE users BEGIN BACKUP;Caution:
If you do not useBEGIN
BACKUP
to mark the beginning of an online tablespace backup and wait for this statement to complete before starting your copies of online tablespaces, then the data file copies produced are not usable for subsequent recovery operations. Attempting to recover such a backup is risky and can return errors that result in inconsistent data. For example, the attempted recovery operation can issue a fuzzy file warning, and can lead to an inconsistent database that you cannot open.Back up the online data files of the online tablespace with operating system commands. For example, Linux and UNIX users might enter:
% cp /oracle/oradata/trgt/users01.dbf /d2/users01_'date "+%m_%d_%y"'.dbf% cp /oracle/oradata/trgt/users02.dbf /d2/users02_'date "+%m_%d_%y"'.dbfAfter backing up the data files of the online tablespace, run the SQL statement
ALTER
TABLESPACE
with theEND
BACKUP
option. For example, the following statement ends the online backup of the tablespaceusers
:SQL> ALTER TABLESPACE users END BACKUP;Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived. For example, enter:
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;Caution:
If you fail to take the tablespace out of backup mode, then Oracle Database continues to write copies of data blocks in this tablespace to the online redo logs, causing performance problems. Also, you receive anORA-01149
error if you try to shut down the database with the tablespaces still in backup mode.
- OCP-1Z0-053-V12.02-546题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- 内存MCE错误导致系统崩溃的问题分析
- firefox快捷键
- 动态规划-最小代价子母树
- autoreleasing的用法介绍:
- 传说中年薪25万的面试题
- OCP-1Z0-053-V12.02-546题
- 将一个4字节的整数的二进制表示中的001替换为011,输出替换后的整数。
- Oracle sql例子
- start-stop-daemon
- 黑马有信将新装辟蓝海
- Wireshark抓包工具使用教程以及常用抓包规则
- 隐藏PHP程序头部发出的:X-Powered-By: PHP/5.2.4类似的信息
- USB gadget设备驱动解析
- .NET 4中的并行编程技术(也称之为多核编程技术) 2