The database is in ARCHIVELOG mode.
There is not a current backup of the database available.
The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
The USERS tablespace is not eligible for TSPITR because it has invalid objects.
The recover tablespace command is incorrect and generates the error.
第1题:
In which scenario will you perform a cancel-based recovery?()
第2题:
What RMAN command is used to execute a tablespace point-in-time recovery?()
第3题:
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()
第4题:
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?()
第5题:
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()
第6题:
In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?()
第7题:
Which command is used to begin a tablespace point-in-time recovery?()
第8题:
When youre performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance?()
第9题:
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.
第10题:
In which of the following scenarios is a tablespace recovery required?()