I have a UAT database with physical standby setup.
I want to disable physical standby because I am reloading entire database on the primary from backup expdp full.
This will sure cause achivelog full to both primary and standby. Is there a way to disable it?
>Is there a way to disable it?
disable archiving redo files
As SB said, put your primary in NOARCHIVELOG mode.... but at your own risk... and note that you will have to rebuild your standby after your import completes...
Is your database that big that disabling archive mode and later rebuilding the standby is a much better approach than just do the import with your current configuration?
Im referring to physical standby. and after loading data, I will enable it again.
But by doing so, you will essentially be killing your physical standby database. Your standby needs those transactions in order to remain a copy of the primary. In fact, when the standby resumes, it will be asking for "missing" archived redo logs that were never generated.
If you do insist on this plan, which I say is a bad idea, then you will need to roll-forward your standby database.
When you have a physical standby, it is a very big tail wagging your dog. If you even have to think about disabling archiving to prevent a destination full issue, you are going to have to recreate your standby from scratch anyways. So yes, it makes sense to turn archiving off, do the load, turn it back on, take a backup, use the backup to recreate the standby.
This does beg the question, why a standby on UAT? To make performance comparable so users don't get their expectations too high? Test failover?
Various details including extra storage temporarily available, size of db, network speed, what actually needs to be accomplished and so on can affect solutions.
you can try as below :
1. Stop log_archive_dest_2_state=defer into primary
2. Open Physical standby [UAT] on read only mode. do export.
3. Do your import into primary. Extend your archivelog space.
4. Then on standby do roll forward by using rman incremental backup of current scn into standby.