当前位置:1Z0-053题库

问题:

[单选]

You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.  
SQL> startup ORACLE instance started. 
Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. 
ORA-00313: open failed for members of log group 2 of thread 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 logfile group 2; alter database clear logfile group 2 * ERROR at line 1: 
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02.log ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02a.log  
What steps must you take to resolve the error?()
a. Issue the recover database redo logs command. 
b. Issue the Startup Mount command to mount the database. 
c. Restore the last full database backup. 
d. Perform a point-in-time recovery, applying all archived redo logs that are available. 
e. Restore all archived redo logs generated during and after the last full database backup. 
f. Open the database using the alter database open resetlogs command. 
g. Issue the alter 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

A retail customer is looking at ways to reduce power requirements. They are considering deploying two hundred IBM HS22 blades running Red Hat Linux in the IBM BladeCenter E chassis. The customer has already chosen Intel L5640 CPUs to reduce power. Which on-board storage option allows the customer to reduce power consumption of each blade?() One 50 GB SATA 1.8 inch SSD。 Two 73GB 10K SAS HDD SFF。 Two 31 GB SATA 2.5 inch SSD。 Two 50GB SATA 1.8 inch SSD。 ()是建设有中国特色的社会主义理论的精髓。 一国两制。 以经济建设为中心。 坚持四项基本原则,坚持改革开放。 解决思想,实事求是。 Companycom would like the ability to shrink filesystems. They currently have JFS filesystems. Which of the following is necessary to shrink the filesystems?() Copy the existing filesystems to JFS2。 Defragment the filesystem, then reduce its size。 Change the file system attribute allow_shrink=yes on the existing filesystems。 Modify the logical volume attribute allow_shrink=yes on the existing logical volume。 During a NIM install,the system stops with the LED code 611.What is the cause of the issue?() A failure to NFS mount filesystems from the NIM client。 A failure to NFS mount filesystems from the NIM master。 A failure to retrieve the tftp client info from the NIM master。 A failure to retrieve the tftp server info from the NIM master。 电子签名

You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.  
SQL> startup ORACLE instance started. 
Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. 
ORA-00313: open failed for members of log group 2 of thread 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 logfile group 2; alter database clear logfile group 2 * ERROR at line 1: 
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02.log ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02a.log  
What steps must you take to resolve the error?()
a. Issue the recover database redo logs command. 
b. Issue the Startup Mount command to mount the database. 
c. Restore the last full database backup. 
d. Perform a point-in-time recovery, applying all archived redo logs that are available. 
e. Restore all archived redo logs generated during and after the last full database backup. 
f. Open the database using the alter database open resetlogs command. 
g. Issue the alter database open command.

参考答案:

  参考解析

本题暂无解析

在线 客服