Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

Lab 14-1: Diagnosing and Repairing Database Failure

Back

• Lab 14-1: Diagnosing and Repairing Database Failure

---

##

$HOME/labs/DBMod_Recovery/rec_config.sh
# execute setup_14_01.sh -  setup_09_01.sh
cd $HOME/labs/DBMod_Recovery
./setup_09_01.sh

# execute break_14_01.sh - break_09_01.sh
./break_09_01.sh

---

# login
sqlplus / as sysdba

startup

show pdbs
alter pluggable database orclpdb1 open;
exit

---

• List database failure using DRA

rman target "/ as sysbackup"

-- RMAN
LIST FAILURE;

-- Get advise on how to repair the failure.
ADVISE FAILURE;

-- Repair the failure
REPAIR FAILURE;
-- want to execute the above repair? YES

-- Try to open orclpdb in rman
ALTER PLUGGABLE DATABASE orclpdb1 open;
exit

---

• Open the pdb after repairing

sqlplus / as sysdba

show pdbs
exit

---

• Clean up

./cleanup_09_01.sh

---

TOP