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