OCP 1Z0 053 180
来源:互联网 发布:手机淘宝无法实名认证 编辑:程序博客网 时间:2024/04/27 00:15
A. alter database open
B. alter database open repairlog
C. alter database open resetlogs
D. alter database open resetlog
E. alter database resetlogs open
Answer: C
D少了个S,汗一个
Performing Cancel-Based Incomplete Recovery
In cancel-based recovery, recovery proceeds by prompting you with the suggested file names of archived redo log files. Recovery stops when you specify CANCEL
instead of a file name or when all redo has been applied to the data files.
To perform cancel-based recovery:
Follow Step1 through Step 8 in "Performing Closed Database Recovery".
Begin cancel-based recovery by issuing the following command in SQL*Plus:
RECOVER DATABASE UNTIL CANCEL
Note:
If you fail to specify the UNTIL
clause on the RECOVER
command, then the database assumes a complete recovery and does not open until all redo is applied.The database applies the necessary redo log files to reconstruct the restored data files. The database supplies the name it expects to find from LOG_ARCHIVE_DEST_1
and requests you to stop or proceed with applying the log file. If the control file is a backup, then you must supply the names of the online redo logs if you want to apply the changes in these logs.
Continue applying redo log files until the last log has been applied to the restored data files, then cancel recovery by executing the following command:
CANCEL
The database indicates whether recovery is successful. If you cancel before all the data files have been recovered to a consistent SCN and then try to open the database, then you get an ORA-1113
error if more recovery is necessary. You can query V$RECOVER_FILE
to determine whether more recovery is needed, or if a backup of a data file was not restored before starting incomplete recovery.
Open the database with the RESETLOGS
option. You must always reset the logs after incomplete recovery or recovery with a backup control file. For example:
ALTER DATABASE OPEN RESETLOGS;
If you attempt to use OPEN
RESETLOGS
when you should not, or if you neglect to reset the log when you should, then the database returns an error and does not open the database. Correct the problem and try again.
See Also:
"About User-Managed Media Recovery Problems" for descriptions of situations that can cause ALTER
DATABASE
OPEN
RESETLOGS
to failAfter opening the database with the RESETLOGS
option, check the alert log.
Note:
The easiest way to locate trace files and the alert log is to run the following SQL query:SELECT NAME, VALUE FROM V$DIAG_INFO
.When you open with the RESETLOGS
option, the database returns different messages depending on whether recovery was complete or incomplete. If the recovery was complete, then the following message appears in the alert log:
RESETLOGS after complete recovery through change scn
If the recovery was incomplete, then this message is reported in the alert log, where scn
refers to the end point of incomplete recovery:
RESETLOGS after incomplete recovery UNTIL CHANGE scn
Also check the alert log to determine whether the database detected inconsistencies between the data dictionary and the control file. Table 29-3 describes two possible scenarios.
Table 29-3 Inconsistencies Between Data Dictionary and Control File
Data File Listed in Control File Data File Listed in the Data Dictionary Result Yes
No
References to the unlisted data file are removed from the control file. A message in the alert log indicates what was found.
No
Yes
The database creates a placeholder entry in the control file under MISSING
nnnnn
(where nnnnn
is the file number in decimal).MISSING
nnnnn
is flagged in the control file as offline and requiring media recovery. You can make the data file corresponding to MISSING
nnnnn
accessible by using ALTER
DATABASE
RENAME
FILE
for MISSING
nnnnn
so that it points to the data file. If you do not have a backup of this data file, then drop the tablespace.
Performing Time-Based or Change-Based Incomplete Recovery
Performing Cancel-Based Incomplete Recovery
In cancel-based recovery, recovery proceeds by prompting you with the suggested file names of archived redo log files. Recovery stops when you specify CANCEL
instead of a file name or when all redo has been applied to the data files.
To perform cancel-based recovery:
Follow Step1 through Step 8 in "Performing Closed Database Recovery".
Begin cancel-based recovery by issuing the following command in SQL*Plus:
RECOVER DATABASE UNTIL CANCEL
Note:
If you fail to specify theUNTIL
clause on theRECOVER
command, then the database assumes a complete recovery and does not open until all redo is applied.The database applies the necessary redo log files to reconstruct the restored data files. The database supplies the name it expects to find from
LOG_ARCHIVE_DEST_1
and requests you to stop or proceed with applying the log file. If the control file is a backup, then you must supply the names of the online redo logs if you want to apply the changes in these logs.Continue applying redo log files until the last log has been applied to the restored data files, then cancel recovery by executing the following command:
CANCEL
The database indicates whether recovery is successful. If you cancel before all the data files have been recovered to a consistent SCN and then try to open the database, then you get an
ORA-1113
error if more recovery is necessary. You can queryV$RECOVER_FILE
to determine whether more recovery is needed, or if a backup of a data file was not restored before starting incomplete recovery.Open the database with the
RESETLOGS
option. You must always reset the logs after incomplete recovery or recovery with a backup control file. For example:ALTER DATABASE OPEN RESETLOGS;
If you attempt to use
OPEN
RESETLOGS
when you should not, or if you neglect to reset the log when you should, then the database returns an error and does not open the database. Correct the problem and try again.See Also:
"About User-Managed Media Recovery Problems" for descriptions of situations that can causeALTER
DATABASE
OPEN
RESETLOGS
to failAfter opening the database with the
RESETLOGS
option, check the alert log.Note:
The easiest way to locate trace files and the alert log is to run the following SQL query:SELECT NAME, VALUE FROM V$DIAG_INFO
.When you open with the
RESETLOGS
option, the database returns different messages depending on whether recovery was complete or incomplete. If the recovery was complete, then the following message appears in the alert log:RESETLOGS after complete recovery through change scn
If the recovery was incomplete, then this message is reported in the alert log, where
scn
refers to the end point of incomplete recovery:RESETLOGS after incomplete recovery UNTIL CHANGE scn
Also check the alert log to determine whether the database detected inconsistencies between the data dictionary and the control file. Table 29-3 describes two possible scenarios.
Table 29-3 Inconsistencies Between Data Dictionary and Control File
Data File Listed in Control File Data File Listed in the Data Dictionary Result Yes
No
References to the unlisted data file are removed from the control file. A message in the alert log indicates what was found.
No
Yes
The database creates a placeholder entry in the control file under
MISSING
nnnnn
(wherennnnn
is the file number in decimal).MISSING
nnnnn
is flagged in the control file as offline and requiring media recovery. You can make the data file corresponding toMISSING
nnnnn
accessible by usingALTER
DATABASE
RENAME
FILE
forMISSING
nnnnn
so that it points to the data file. If you do not have a backup of this data file, then drop the tablespace.
Performing Time-Based or Change-Based Incomplete Recovery
- OCP 1Z0 053 180
- OCP 1Z0 052 180
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- OCP 1Z0 053 16
- 要嗨到爆,也能沉到底——致努力敲代码的自己
- Android学习之笔记---Animation的使用
- 走在机房重构的路上之七层(一)
- lodop 调用打印机打印条码
- Bomb
- OCP 1Z0 053 180
- HDU 2527 Safe Or Unsafe
- ZOJ 1709 Oil Deposits(油田问题DFS)
- FORM中ON-INSERT ON-UPDATE ON-DELETE ON-LOCK代码生成程序
- C++文件读写详解(ofstream,ifstream,fstream)
- The current deployment target does not support automated __weak references
- poj1651Multiplication Puzzle(取数,区间DP)
- Android中Service类onStartCommand
- MyEclipse优化全攻略