In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
Which two statements are true regarding undo tablespaces()
The following query will provide what information about transportable tablespaces for the current database?() select d.platform_name "Source", t.platform_name "Compatible Targets", endian_format from v$transportable_platform t, v$database d where t.endian_format = (select endian_format from v$transportable_platform t, v$database d where d.platform_name = platform_name);
Data files of which three tablespaces can be recovered by performing an openrecovery?()
Which two statements about bigfile tablespaces are true? ()
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: 1.RESTORE CONTROLFILE; 2.RESTORE DATABASE; 3.ALTER DATABASE MOUNT; 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS; 6.RECOVER DATABASE; 7.STARTUP NOMOUNT; In what sequence would you use this process to perform the recovery?()
Which tablespaces are mandatory in an Oracle database for it to be operational()
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()