Which option identifies the correct sequence to recover the SYSAUX tablespace?

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 offline.
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?

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 offline.
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?

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

Explanation:
RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;

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 theRESETLOGSoption after finishing recovery:
SQL> ALTER DATABASE OPEN RESETLOGS;



Leave a Reply 12

Your email address will not be published. Required fields are marked *


Mohammad Rafiq

Mohammad Rafiq

A – 6, 5, 4, 7

Relo

Relo

A – assuming 7 means to say online instead of offline

VSMC

VSMC

Answer is A

RMAN> alter tablespace sysaux offline;

Statement processed

RMAN> restore tablespace sysaux;

Starting restore at 30-JUL-15
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/cdb2/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB2/backupset/2015_07_30/o1_mf_nnndf_TAG20150730T025549_bvmh35k2_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB2/backupset/2015_07_30/o1_mf_nnndf_TAG20150730T025549_bvmh35k2_.bkp tag=TAG20150730T025549
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 30-JUL-15

RMAN> recover tablespace sysaux;

Starting recover at 30-JUL-15
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:04

Finished recover at 30-JUL-15

RMAN> alter tablespace sysaux online;

Statement processed

praveen

praveen

I don’t think even A is correct because 4 says apply archive redo logs. Which not performed in to recover SYSAUX.

Judo

Judo

There is typo mistake. Its online instead of offline.

Please correct the step 7 Place the SYSAUX tablespace offline.

it should be Place the SYSAUX tablespace online.