one of my database is already shutdown in my DR,but the log still copying to DR.how to stop the log applying from my DR server
i don;t have access to primary server.
Which database is shutdown? Primary or any of standby DB?
What do you mean by log still copying to DR? Do you mean logs are transferring from primary site to standby site? I hope this wont happen as the (primary) DB is already shutdown and will not generate archives.
If you mean log apply is taking place on your standby DB, you can stop it but using below command
SQL> recover managed standby database cancel;
Alter system set LOG_ARCHIVE_DEST_STATE_2=defer ;
Alter system set LOG_ARCHIVE_DEST_STATE_2=enable;