Oracle Data Guard Physical Standby Configuration

Stage-3 How To Create An Oracle 12c Data Guard Active Standby Database Primary Database Name indiaStandby Database name China Step:1 Enable Archive log mode and Flashback on Flashback database is highly recommended because in case of failover, you need not re-create primary database from scratch shut immediatestartup mountalter database archive log;alter database flashback on; Step:2 […]

Read More

Rman Commands

RMAN BACKUP STATUS set linesize 500 pagesize 2000 col Hours format 9999.99 col input_type for a20 col STATUS format a10 col RMAN_Bkup_start_time for a20 col RMAN_Bkup_end_time for a20 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_start_time, to_char(END_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_end_time, elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS order by session_key;  Database backups  RMAN> BACKUP DATABASE;  RMAN> BACKUP DATABASE […]

Read More

Hinzinfotech

We are aspiring technology services company, specializing in Software Development, Database Consulting, and Digital Solutions. With a passion for innovation, We empower businesses to thrive in the digital age, providing tailored solutions that drive growth and efficiency.”

Read More