Turning Redo Transport Services On and Off

  Turning Redo Transport Services On and Off.

  Turning Redo Transport Services Off.

Setting the primary database state to TRANSPORT-ON starts redo transport services at the primary database, and setting the primary database state to TRANSPORT-OFF stops redo transport services at the primary database.

If the primary database state is set to TRANSPORT-OFF, redo transport services to all the standby databases are stopped regardless of the LogShipping property values of the individual standby databases.

If the primary database state is set to TRANSPORT-ON, redo transport services to each standby database are determined by the LogShipping property of that database.

Welcome to DGMGRL, type "help" for information.

DGMGRL> Connected to "LAPPRIMDB"

Connected as SYSDBA.

DGMGRL> Property "Logshipping" updated

DGMGRL>

Error: ORA-16627: operation disallowed since no member would remain to support protection mode

Oh I got the error let me see why????

Welcome to DGMGRL, type "help" for information.

DGMGRL> Connected to "LAPPRIMDB"

Connected as SYSDBA.

DGMGRL>

Configuration - DRENV

  Protection Mode: MaxAvailability===> let me change the protection Mode.

  Members:

  LAPPRIMDB - Primary database

    lapdrdb   - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:

SUCCESS   (status updated 14 seconds ago)

Below Command to Change to Max avail to MaxAvail.

 

EDIT DATABASE 'lapprimdb' SET PROPERTY 'LogXptMode'='ASYNC';

EDIT DATABASE 'lapdrdb' SET PROPERTY 'LogXptMode'='ASYNC';

EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

check_stat.sh

dgmgrl <<eof

connect sys/abc#123@lapdrdb

show configuration;

eof

[oraprd@prd1 STANDBY]$ cat transport_off.sh

dgmgrl <<eof

connect sys/abc#123@lapprimdb

edit database LAPPRIMDB set property 'Logshipping'='OFF';

edit database LAPDRDB set property 'Logshipping'='OFF';

show database 'LAPPRIMDB' 'logshipping';

show database 'LAPDRDB' 'logshipping';

eof

Primary Database.

System altered.

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u001/PRD/arch

Oldest online log sequence     351

Next log sequence to archive   352

Current log sequence           353

[oraprd@prd1 STANDBY]$

=================================================================

Standby Archivelog Apply.

 SEQUENCE# APPLIED

---------- ---------

       337 YES

       338 YES

       339 YES

       340 YES

       341 YES

       342 YES

       343 YES

       344 YES

       345 YES

       346 YES

373 rows selected.

So no Archivelog apply on standby database. Redo Transport also disable.

 Turning Redo Transport Services On.

[oraprd@prd1 STANDBY]$ cat transport_on.sh

dgmgrl <<eof

connect sys/abc#123@lapprimdb

edit database LAPPRIMDB set property 'Logshipping'='ON';

edit database LAPDRDB set property 'Logshipping'='ON';

show database 'LAPPRIMDB' 'logshipping';

show database 'LAPDRDB' 'logshipping';

eof

***********************************EOD***************************