The data file cannot be recovered.
The date file can be restored from the SYSTEM auto 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题:
The user HR receives the following error while inserting data into the TTK table: ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation, you find that SMD is a small file tablespace. Which three action would allow the user to insert data()
第2题:
When performing an incomplete recover of the whole database, which data files must you restore? ()
第3题:
A.A file system cannot be mounted on a directory containing data.
B.Mounting a file system on a mount point containing data will delete the data.
C.Mounting a file system on a amount point containing data will make the data temporarily inaccessible.
D.A systems administrator must manually create an empty directory prior to mounting an AIX JFS.
第4题:
The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?()
第5题:
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?()
第6题:
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?()
第7题:
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace. Which three action would allow the user to insert data()
第8题:
Which two statements correctly describe the relation between a data file and the logical databasestructures()
第9题:
There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()
第10题:
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up? ()