Restore & Recovery - Restore For Tcc (tcc Example)

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Restore & Recovery - Restore For Tcc (tcc Example) as PDF for free.

More details

  • Words: 203
  • Pages: 3
restore for tct (offline) things to restore: 1) sapdata (cd sapdata1) 2) ctrl file (cd cntrl<sid>.dbf) 3) online redo log (oracle/TCT/mirrorlogA) (oracle/TCT/mirrorlogB) steps involved:1) remove segala sapdata cp -Rf backup/exportdir/* 2) su - tctadm 1. stopsap r3 2. su – oratct 3. sqlplus /nolog 4. conn / as sysdba 5. shutdown immediate 6. lsnrctl stop 3) choose file yg nak direstore. Check dekat db13 or dekat /oracle/TCT/sapbackup 4) vi clssap.sh remove certain files for sapdata1 Rm –Rf /oracle/TCT/sapdata1/btabd_12/* Rm –Rf /oracle/TCT/sapdata1/clui_1/* Rm –Rf /oracle/TCT/sapdata1/cntrl/* Rm –Rf /oracle/TCT/sapdata1/ddicd_1/* Rm –Rf /oracle/TCT/sapdata1/loadd_1/* Rm –Rf /oracle/TCT/sapdata1/oldredo/* Rm –Rf /oracle/TCT/sapdata1/proti_1/* Rm –Rf /oracle/TCT/sapdata1/roll_1/* Rm –Rf /oracle/TCT/sapdata1/roll_2/* Rm –Rf /oracle/TCT/sapdata1/roll_3/* Rm –Rf /oracle/TCT/sapdata1/roll_4/* Rm –Rf /oracle/TCT/sapdata1/roll_5/* Rm –Rf /oracle/TCT/sapdata1/sourced_1/* Then, remove Rm –Rf /oracle/TCT/sapdata2/* Rm –Rf /oracle/TCT/sapdata3/* and so on 5) run clssap.sh -> so bila df –k, sapdata byk free space

6) under oratct, Brrestore –m all –b Then, continue, continue 7) control file Brrestore –m 0 –b bdtuopar.aff 8) online redo log Cd sapbackup Brrestore –m 011-014 –b bdtuopar.aff 9) under oratct lsnrctl start startup 10) startsap r3 11) lepas tu spam (kalau nak update package) Under client 000 Sap* tak bole buat spam Define queries Import queries Check queries

Ps –ef | grep brrestore

Related Documents