Posted by Mir Sayeed Hassan on 2nd October 2017
Manually Perform Physical standby data Guard Failover steps In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database. standby Database: Verify… Read more..
Posted in DataGuard (DR) | Comments Off on Physical standby data Guard Failover steps
Posted by Mir Sayeed Hassan on 2nd October 2017
Perform the expdp (fulldb/schema/table) by using the ASM Storage Step 1 – Create the Directory in ASM location (Example – +DATA/mir_exp) [grid@asmdb ~]$ asmcmd ASMCMD> ls CRS/ DATA/ FRA/ ASMCMD> cd DATA ASMCMD> mkdir mir_exp ASMCMD>… Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on Perform the expdp (fulldb/schema/table) by using the ASM Storage
Posted by Mir Sayeed Hassan on 2nd October 2017
Register the archivelog Manually for single & multiple/bulk archivelog in Oracle Database Fallow the below simple steps to perform the operation Register the archive log manually in a database sql> alter database register logfile ‘/u01/app/oracle/FRA/arch_1_101.arc’; Bulk register the archive lo rman> catalog start with ‘/var/arch’;
Posted in RMAN | Comments Off on Register the archivelog Manually for single & multiple/bulk archivelog
Posted by Mir Sayeed Hassan on 2nd October 2017
RMAN Backup Compressions tested in our Test ENV RMAN Backup Compressions The compression levels are BASIC, HIGH, MEDIUM and LOW To use this option, we can run the following RMAN commands RMAN>… Read more..
Posted in RMAN | Comments Off on RMAN Backup Compressions tested in our Test ENV
Posted by Mir Sayeed Hassan on 2nd October 2017
Verify Primary & Standby Database are sync & applied logs ON PRIMARY: col MEMBER FORMAT A100 set linesize 200 sql> SELECT a.thread#, b. last_seq, a.applied_seq, a. last_app_timestamp, b.last_seq-a.applied_seq ARC_DIFF FROM (SELECT thread#, MAX(sequence#) applied_seq, MAX(next_time) last_app_timestamp FROM gv$archived_log… Read more..
Posted in DataGuard (DR) | Comments Off on Verify Primary & Standby Database are sync & applied logs