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 ABOR
Which option identifies the correct sequence to recover the SYSAUX tablespace?
A.6, 5, 4, 7
B.10, 1, 2, 5, 8
C.10, 1, 2, 5, 4, 9, 8
D.10, 1, 5, 8, 10
Answer is A
lets check
[code]
RMAN> report schema;
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 800 SYSTEM YES +DATA/ORCL/DATAFILE/system.257.892974075
3 770 SYSAUX NO +DATA/ORCL/DATAFILE/sysaux.256.892974029
4 225 UNDOTBS1 YES +DATA/ORCL/DATAFILE/undotbs1.259.892974131
5 250 PDB$SEED:SYSTEM NO +DATA/ORCL/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/system.266.892974227
6 5 USERS NO +DATA/ORCL/DATAFILE/users.258.892974129
7 550 PDB$SEED:SYSAUX NO +DATA/ORCL/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/sysaux.265.892974227
8 260 PDBORCL:SYSTEM NO +DATA/ORCL/21FCC007021718A9E053480A0A0A9442/DATAFILE/system.269.892975245
9 590 PDBORCL:SYSAUX NO +DATA/ORCL/21FCC007021718A9E053480A0A0A9442/DATAFILE/sysaux.270.892975245
10 5 PDBORCL:USERS NO +DATA/ORCL/21FCC007021718A9E053480A0A0A9442/DATAFILE/users.272.892975347
11 260 SW:SYSTEM NO +DATA/ORCL/21FDF80F8BC11D67E053480A0A0A30E0/DATAFILE/system.274.892980465
12 590 SW:SYSAUX NO +DATA/ORCL/21FDF80F8BC11D67E053480A0A0A30E0/DATAFILE/sysaux.273.892980465
13 2355 SW:SOE NO +DATA/ORCL/21FDF80F8BC11D67E053480A0A0A30E0/DATAFILE/soe.276.892980749
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 197 TEMP 32767 +DATA/ORCL/TEMPFILE/temp.264.892974221
2 100 PDB$SEED:TEMP 32767 +DATA/ORCL/FD9AC20F64D244D7E043B6A9E80A2F2F/DATAFILE/pdbseed_temp012015-10-13_08-24-34-am.dbf
3 20 PDBORCL:TEMP 32767 +DATA/ORCL/21FCC007021718A9E053480A0A0A9442/TEMPFILE/temp.271.892975321
4 62 SW:TEMP 32767 +DATA/ORCL/21FDF80F8BC11D67E053480A0A0A30E0/TEMPFILE/temp.275.892980531
[/code]
first we need backup:
[code language=”sql”]
RMAN> backup as copy datafile 3 format ‘/ora01/dump/cdb_sysaux.ora’;
[/code]
and check
1. take tablespace offline
2. restore datafile
3. recover datafile
4. take tablespace online
[code language=”sql”]
13:10:37 (1)[CDB$ROOT]sys@orcl> alter tablespace sysaux offline;
RMAN> switch datafile 3 to copy;
RMAN> recover datafile 3;
13:10:39 (1)[CDB$ROOT]sys@orcl> alter tablespace sysaux online;
[/code]