READ Free Dumps For Oracle- 1z0-060
| Question ID 20758 | Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Real 5
Oracle 1z0-060 Exam
|
| Option A | Oracle Data Pump
|
| Option B | Oracle Recovery Manager (RMAN)
|
| Option C | Oracle Label Security
|
| Option D | Oracle Database Vault
|
| Option E | Oracle Real Application Security
|
| Correct Answer | B |
Explanation
| Question ID 20759 | Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is
corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
|
| Option A | 6, 5, 4, 7
|
| Option B | 10, 1, 2, 5, 8
|
| Option C | 10, 1, 2, 5, 4, 9, 8
|
| Option D | 10, 1, 5, 8, 10
|
| Correct Answer | A |
Explanation Explanation: RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;Real 6 Oracle 1z0-060 Exam RMAN> RESTORE TABLESPACE sysaux; RMAN> RECOVER TABLESPACE sysaux; RMAN> ALTER TABLESPACE sysaux ONLINE; * Example: While evaluating the 12c beta3 I was not able to do the recover while testing "all pdb files lost". Cannot close the pdb as the system datafile was missing... So only option to recover was: Shutdown cdb (10) startup mount; (1) restore pluggable database recover pluggable database alter database open; alter pluggable database name open; Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB. * Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either: / Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances) / After shutting down the database using SHUTDOWN ABORT Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available. * Open the database with the RESETLOGS option after finishing recovery: SQL> ALTER DATABASE OPEN RESETLOGS;