Data Guard

Sometimes Archive Gap is Just Temporary

Posted on
As a DBA, you might see many gaps on the standby database in your career like this.SQL> select * from v$archive_gap;   THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#———- ————- ————–         1        113187         113187Just don’t rush to take some actions on archived logs, we can check the arrival of the […]
Data Guard

How to Start Data Guard Services

Posted on
Starting data guard services is actually a reverse process of stopping data guard services by any ways. Let’s see how we start the services along the same route of stopping. With the broker Enable apply service of the standby database. DGMGRL> EDIT DATABASE ‘standby_db’ SET STATE=’APPLY-ON’; Succeeded. Enable transport service of the primary database. DGMGRL> […]
Data Guard

How to Stop Data Guard Services

Posted on
Stop Data Guard Is Broker Enabled? First of all, you need to know whether the data guard broker is configured, started and controls over the data guard. SQL> show parameter dg_broker_start NAME                                 TYPE        VALUE ———————————— ———– […]
Data Guard

How to Resolve ORA-01196 and ORA-01110

Posted on
ORA-01196 Saw errors ORA-01196 thrown by the database when trying to activate a standby database. SQL> alter database activate standby database; alter database activate standby database * ERROR at line 1: ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: ‘+data/system.243.34698032′ Generally, if we’d like to open the […]
Data Guard

How to Resolve ORA-16009: remote archive log destination must be a STANDBY database

Posted on
Saw an error in the alert log…. Sat Mar 21 10:28:48 2015Errors in file /oracle/admin/ORCL/bdump/orcl_arc0_9548203.trc:ORA-16009: remote archive log destination must be a STANDBY databaseThere may be a misunderstanding between the primary and the standby databases, we could have two primary databases with the same database name in the same time.I know that’s essentially wrong to […]
TEMP

How to Resolve ORA-25153: Temporary Tablespace is Empty

Posted on
ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made to use space in a temporary tablespace with no files. Action Add files to the tablespace using ADD TEMPFILE command. This is because the temporary tablespaces contain no any temp […]
Data Guard

Will Newly Created Standby Controlfile Contain Backup Records of Primary Database?

Posted on
The answer is definite. Today I created a controlfile for standby database in the primary database. After I mounted the newly created controlfile in the standby database. I tested it by RMAN like this$ rman target /…connected to target database: ORCL (DBID=3469582309)RMAN> list backup of database summary;using target database controlfile instead of recovery catalogList of […]