if we have many more missing files ...like in my case we have 2200 files are missing . which procedure should be followed to resolve archive log gap. its production environment.
In roll-forwad method ,what is actual location of backup? is it happend in network or where? because I have tried this method but not found location of backup-piece..
It does not require any archive log, support last 3 month archive logs are deleted from your prod and your DR is out of sync from last 3 month. This method will use database backup based restore does not require archive logs
I have added tns entries on both primary and standby n they pinged each other but when I connect rman target / on standby server it gives error cannot connect remote server invalid userid and password while executing recover database from service prod , even I copied password file from prod to stb dbs location.. What should I do.plz advice
Is it applicable on ACTIVE physcial standyby?? means Read Only mode Or Can we use this method on only physical standby db means db is in MOUNT state not in read only. ????
Hi malikarjun,
kindly make video on Stat gather ,optmizer as well Partition concept.
if we have many more missing files ...like in my case we have 2200 files are missing . which procedure should be followed to resolve archive log gap. its production environment.
Hope you cover RECOVER FROM SERVICE for 12c, thanks
Thats true its recover based on service name
@@VismoTechnologies Yes I have tried. How can we delete archive log automatically in RMAN once applied on standby?
Hello sir.. we have 2node pr and 2 node dr.. i cleared the FRA thats why pr and dr are not in sync.. is this possible to recover
Can we use this in 19c also?
Yes
In roll-forwad method ,what is actual location of backup?
is it happend in network or where?
because I have tried this method but not found location of backup-piece..
It does not need any backup location.
nice explanation.
Thank you
How to check standby database size which is in mount state.?
top command, du -sh command at home level
Hai mallik, while recovering the database the system datafile to restoreed error is coming. Can you please help me through it
very informative ........ thanks ..
i performed this in 19c and no restore of standby controlfile or catalog required. all steps performed automatically.
Do you have the steps?
If archive gap is for 2-3 months like 20k arch files can we still use recover from service , kindly confirm in 12c
I have same question
It does not require any archive log, support last 3 month archive logs are deleted from your prod and your DR is out of sync from last 3 month.
This method will use database backup based restore does not require archive logs
I have added tns entries on both primary and standby n they pinged each other but when I connect rman target / on standby server it gives error cannot connect remote server invalid userid and password while executing recover database from service prod , even I copied password file from prod to stb dbs location..
What should I do.plz advice
Did you copy the password file ?
can you share ung document guide?
Is it applicable on ACTIVE physcial standyby?? means Read Only mode
Or
Can we use this method on only physical standby db means db is in MOUNT state not in read only. ????
Thanks 🙏
Thank you 👍🏻
Nice 👍
Thank you 😊