Skip to content

1z0-060 Q8

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

Answer is A

lets check

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

first we need backup:

RMAN> backup as copy datafile 3 format '/ora01/dump/cdb_sysaux.ora';

and check
1. take tablespace offline
2. restore datafile
3. recover datafile
4. take tablespace online

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;

[свернуть]

Primary Sidebar

Яндекс.Метрика