Pepe2323
asked on
Oracle 10.2.0.5 Dataguard
Hi guys
i'm planning to create a dataguard using Oracle 10.2.0.5 my primary database size is 3T, so to move backup information from my primary to my new standby; i'm planning to use 4T USB3 external disk, because by network will be slowly and painful.
What i'm not sure is if i have a time limit to restore my new standby and start recovering and applying archives.
If 14 hours after my full backup i restore my database on my new standby, it will be able to perform the recovering and applying archives? will be a 14 hours of difference, i don't care if the process take a week to be sync but i 'm not sure if standby will be able to do this with that difference
The Archives has a expiration ? i mean expire after X time or depends of the volume of the information
Other option is after i recover the new standby i just create a backup of the missing sequence and that backup i can transfer by network since will be much smaller
Any suggestion will be helpful
Regards.
i'm planning to create a dataguard using Oracle 10.2.0.5 my primary database size is 3T, so to move backup information from my primary to my new standby; i'm planning to use 4T USB3 external disk, because by network will be slowly and painful.
What i'm not sure is if i have a time limit to restore my new standby and start recovering and applying archives.
If 14 hours after my full backup i restore my database on my new standby, it will be able to perform the recovering and applying archives? will be a 14 hours of difference, i don't care if the process take a week to be sync but i 'm not sure if standby will be able to do this with that difference
The Archives has a expiration ? i mean expire after X time or depends of the volume of the information
Other option is after i recover the new standby i just create a backup of the missing sequence and that backup i can transfer by network since will be much smaller
Any suggestion will be helpful
Regards.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Guys
The Standby is located in other location, the reason i'm planning to move my first full backup of the primary, using an external usb DISK to move the backup and then move that USB disk to my other location to restore the standby database.
But 3T of information is a lot and move the backup by network will be slow process.
The new standby have the purpose to sync info using the oracle 10 as standalone and when this info is synced then i'm planning to upgrade it to ORacle 11gr2 in rac
I'm moving my DB to other location and upgrade the Oracle Version.
But i was concern about the period of time that will be between the full backup and when disk arrive to the new location and the time it takes to restore it.
i hope i made me explain
The Standby is located in other location, the reason i'm planning to move my first full backup of the primary, using an external usb DISK to move the backup and then move that USB disk to my other location to restore the standby database.
But 3T of information is a lot and move the backup by network will be slow process.
The new standby have the purpose to sync info using the oracle 10 as standalone and when this info is synced then i'm planning to upgrade it to ORacle 11gr2 in rac
I'm moving my DB to other location and upgrade the Oracle Version.
But i was concern about the period of time that will be between the full backup and when disk arrive to the new location and the time it takes to restore it.
i hope i made me explain
As long as you have ALL the archived redo logs then time isn't a problem... It can be years in between. Just make sure you have ALL of the logs.
I will second that.
As long as all the logs are there you are good. If you have to restore them from a backup, that is fine. I would be sure that no backups are recycled before you get everything set up.
Also, I would recommend doing the upgrade first and then setting up the standby. In my opinion, you are reducing the level of complexity by doing the upgrades first.
As long as all the logs are there you are good. If you have to restore them from a backup, that is fine. I would be sure that no backups are recycled before you get everything set up.
Also, I would recommend doing the upgrade first and then setting up the standby. In my opinion, you are reducing the level of complexity by doing the upgrades first.
ASKER
Thanks for your help.
To the comments above, it's fairly common practice to replicate archive logs out to multiple systems -- so that the odds of a catastrophic gap are minimized.
One other side comment, the active data guard (licensed option) in 11g allows my site to maintain a hot standby two-node RAC, with logs applied upon receipt. In effect, the COOP site can be live and primary within a few minutes.