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?()
- AOnly bring the tablespace back online.
- BOnly recover the tablespace and then bring the tablespace back online.
- CShut down the database, recover the data file and then start up the database.
- DIssue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online.
- ERecover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.