The data file cannot be recovered.
The date file can be restored from theSYSTEMauto backup.
Take thetablespaceoffline,drop,kand re-create it.
Recovery Manager (RMAN) is used to recover the data file.
The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
第1题:
Which of the following commands should be run to verify that file system /data is not corrupted?()
第2题:
The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five/x7fdigit number starting with 0. What could be the possible reason?()
第3题:
A.fsck /dta
B.fsck datavg
C.lqueryvg datavg
D.stat /data
第4题:
You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()
第5题:
When performing an incomplete recover of the whole database, which data files must you restore? ()
第6题:
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?()
第7题:
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第8题:
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第9题:
View this parameter setting in your database: DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command: CREATE TABLESPACE USERS; Which two statements are true about the USERS tablespace?()
第10题:
You issue the following statement: SQL> SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE; You receive the following error: 01578: ORACLE data block corrupted (file# 6, block # 54) ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()