Check that flashback database is enabled.

parameters to set are:

  1. db_recovery_file_dest
  2. db_recovery_file_dest_size
  3. db_flashback_retention_target

SQL> show parameter db_recovery_file_dest

NAME TYPE VALUE
———————————— ———–
db_recovery_file_dest string +ARCHIVE
db_recovery_file_dest_size big integer 4000G
SQL > show parameter db_flashback_retention_target

NAME TYPE VALUE
———————————— ———–
db_flashback_retention_target integer 4320
SQL> select log_mode,flashback_on from v$database;

LOG_MODE FLASHBACK_ON
———— ——————
ARCHIVELOG NO

SQL> alter database recover managed standby database cancel;
Database altered.

OR DGMRL
edit database brivovac set state = ‘apply-off’;

SQL> select open_mode from v$database;

OPEN_MODE
——————–
MOUNTED

SQL> alter database flashback on;
Database altered.

SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
OR DGMRL
edit database brivovac set state = ‘apply-on’;

DGMGRL> show database ‘STANDBY’

Database – STANDBY

Enterprise Manager Name: STANDBY_DB
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 42.57 MByte/s
Real Time Query: OFF
Instance(s):
STANDBY

Database Status:
SUCCESS

Ensure you are using spfile, file management is manual, and that you have space for the retention of flashback logs:

On Production DB Server:

DGMGRL> CONVERT DATABASE STANDBY TO SNAPSHOT STANDBY;
Converting database “STANDBY” to a Snapshot Standby database, please wait…
Error: ORA-01275: Operation is not allowed if standby file management is automatic.
Failed.
Failed to convert database “STANDBY”

On Standby Database:

SQL> show parameter standby_file_management

NAME TYPE VALUE
———————————— ———–
standby_file_management string AUTO

SQL> alter system set standby_file_management=manual;
System altered.

SQL> show parameter standby_file_management

NAME TYPE VALUE
———————————— ———–
standby_file_management string MANUAL

On Production DB Server:
DGMGRL> CONVERT DATABASE STANDBY TO SNAPSHOT STANDBY;
Converting database “STANDBY” to a Snapshot Standby database, please wait…
Error: ORA-15041: diskgroup “” space exhausted

Failed.
Failed to convert database “STANDBY”

Delete backed up archivelogs, or applied archivelogs, or change dest_size  to create space.

DGMGRL> CONVERT DATABASE STANDBY TO SNAPSHOT STANDBY;
Converting database “STANDBY” to a Snapshot Standby database, please wait…
Database “STANDBY” converted successfully.

DGMGRL> CONVERT DATABASE STANDBY TO PHYSICAL STANDBY;
Converting database “STANDBY” to a Physical Standby database, please wait…
Database “STANDBY” converted successfully.

DGMGRL> show database verbose STANDBY;

Database – STANDBY

Enterprise Manager Name: STANDBY_DB
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 6 hours 17 minutes 34 seconds (computed 0 seconds ago)
Average Apply Rate: 91.68 MByte/s
Active Apply Rate: 96.68 MByte/s
Maximum Apply Rate: 99.61 MByte/s
Real Time Query: OFF
Instance(s):
STANDBY
Warning: ORA-16714: the value of property StandbyFileManagement is inconsistent with the database setting

Properties:
DGConnectIdentifier = ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1560))(CONNECT_DATA=(SERVICE_NAME=STANDBY)(SERVER=DEDICATED)))’
ObserverConnectIdentifier = ”
LogXptMode = ‘ASYNC’
RedoRoutes = ”
DelayMins = ‘0’
Binding = ‘optional’
MaxFailure = ‘0’
MaxConnections = ‘1’
ReopenSecs = ‘300’
NetTimeout = ’30’
RedoCompression = ‘DISABLE’
LogShipping = ‘ON’
PreferredApplyInstance = ”
ApplyInstanceTimeout = ‘0’
ApplyLagThreshold = ‘0’
TransportLagThreshold = ‘0’
TransportDisconnectedThreshold = ’30’
ApplyParallel = ‘AUTO’
StandbyFileManagement = ‘AUTO’
ArchiveLagTarget = ‘0’
LogArchiveMaxProcesses = ‘4’
LogArchiveMinSucceedDest = ‘1’
DbFileNameConvert = ”
LogFileNameConvert = ”
FastStartFailoverTarget = ”
InconsistentProperties = ‘(monitor)’
InconsistentLogXptProps = ‘(monitor)’
SendQEntries = ‘(monitor)’
LogXptStatus = ‘(monitor)’
RecvQEntries = ‘(monitor)’
StaticConnectIdentifier = ”
StandbyArchiveLocation = ‘+ARCHIVE’
AlternateLocation = ”
LogArchiveTrace = ‘255’
LogArchiveFormat = ‘%r_%t_%s.arc’
TopWaitEvents = ‘(monitor)’

Database Status:
WARNING

On STANDBY server

SQL> alter system set standby_file_management=auto;

 

Advertisements