Categoria: Data Guard

Rename Datafile on Physical Data Guard Fixing Error ORA-01111 and ORA-01110

16 de dezembro de 2024

Sometimes, because you forget to set standby_file_management to AUTO for example, or any other reason you can get the issues below on alert log or starting database, you can rename datafile with a new feature on Data Guard. This tip help you fix the issue without copy datafiles via RMAN or have to set tablespaces … Mais Rename Datafile on Physical Data Guard Fixing Error ORA-01111 and ORA-01110

Using Recover Standby Database From Service To Fix Physical Data Guard

11 de dezembro de 2024

Oracle Data Guard is a secondary database environment used for disaster recovery, failover, or data recovery, however, this environment can also experience failures, such as synchronization issues, maintenance, and others. Oracle has simplified the process of fixing the database in the Data Guard environment with the command Recover Standby Database From Service, which uses a connection … Mais Using Recover Standby Database From Service To Fix Physical Data Guard

Recriar Banco Standby via Backup Incremental

4 de dezembro de 2017

Neste artigo, vamos recriar um fisical standby, aplicando um backup incremental, a partir do servidor primário. Inicialmente, caso o standby não esteja aberto, abrir o banco em modo READ ONLY: — standby SQL> startup nomount; SQL> alter database mount standby database; SQL> alter database open read only; Precisamos coletar o ultimo SCN do standby, para … Mais Recriar Banco Standby via Backup Incremental