This content has been marked as final. Show 8 replies
You have a good source of information on this in the same city you post from :
RMAN Incremental Backups to Roll Forward a Physical Standby Database
Given the huge numbers you would do well to find the cause. A rebuild might be faster, but I would for sure want to know why this happened so history does not repeat itself.
I'm fairly paranoid about archive gap. I have a script which runs daily and e-mails the result. Won't help with this, but something to consider for later.
Edited by: mseberg on Apr 13, 2012 10:01 PM
This happend because i found that the log_archive_dest_2 was deffered and it dint apply for last 10 days. daily it generated 400-500 of logs . I asked the other DBA and he refused to explain. I am new to the project and now i have been given the responsibillity.
I think rebuild would the best option to use but how to utilise the space. How to estimate the size of the backup from the last scn been applied on the standby?
I might consider "Create a Standby database from an active database using RMAN"
I've done it a few times and you could avoid the "Space" question.
Here are my short notes :
Best of luck on the rebuild.
h2. You are correct
My Bad, this is Oracle 11 feature. Very late here.
Edited by: mseberg on Apr 14, 2012 2:29 AM
If you use RMAN Duplicate double check you Standby afterwards and make sure you have Standby Redo Logs. There seems to be an issue with Oracle 10.
alter database recover managed standby database cancel;
alter database add standby logfile group <n> (<filename>) size <size>;
alter database recover managed standby database disconnect;
Edited by: mseberg on Apr 14, 2012 4:19 PM
I am not sure whether "Create a Standby database from an active database using RMAN" applies to Oracle 10gCreating a standby using "From active database" feature is not with oracle 10g. It comes with 11g. In 10g, you'll have to take the backup of the primary database and the standby controlfile backup of the primary and then create the standby database.
If the size of the primary database is huge and if you cannot opt for re-creating the standby database freshly, then you can go for the roll forward method (Roll Forwarding the Physical Standby Database). The procedure for roll forward is same for 10g and 11g.
You can refer this http://shivanandarao.wordpress.com/2012/03/26/roll-forward-physical-standby-database-using-rman-incremental-backup/