| Author | Message | ||
     Entikaburlu Side Hero Username: Entikaburlu Post Number: 5071 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
we will try to get a sample backup and try restoring it and see how it goes. thanks for the documentation link. very helpful. all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Airliner Junior Artist Username: Airliner Post Number: 243 Registered: 11-2011 Posted From: 136.223.19.43 Rating: N/A |
you may need to start ground up with features you use in EE database which you may not use with standard edition. If endian formats are different looks like you can still use transportable TS (From the doc: Import of transportable tablespaces supported into SE, SE1, and EE) | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 5070 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
not sure. do not know about the app or data model at this point. it's an existing db with a large user base. still proposal stage. all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Airliner Junior Artist Username: Airliner Post Number: 242 Registered: 11-2011 Posted From: 136.223.19.43 Rating: N/A |
I am not sure on this. Which enterprise features you use in EE database?http://docs.oracle.com/cd/B19306_01/license.102/b14199/editi ons.htm#BABJICBB | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 5068 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
no online/network/vpn/ssl connectivity of any kind is possible. only possible to excahnge files. all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Airliner Junior Artist Username: Airliner Post Number: 241 Registered: 11-2011 Posted From: 136.223.19.43 Rating: N/A |
I take my words back on oracle streams. Oracle will pull the plug soon on streams. Oracle is moving towards golden gate (recent acquisition). This should be the perfect solution for long term: (if budget is there) http://www.oracle.com/webfolder/technetwork/tutorials/obe/fm w/odi/odi_11g/odi_gg_integration/odi_gg_integration.htm | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 5065 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
thanks.. this is the approach we want to use. question is more in terms of AIX/Linux and Enterprise/SE compatibility. all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Beat22 Junior Artist Username: Beat22 Post Number: 160 Registered: 01-2012 Posted From: 95.154.230.191 Rating: N/A |
ek bro oracle nunchi java loki backup sesi yamaha loo store seyandi | ||
| Airliner Junior Artist Username: Airliner Post Number: 240 Registered: 11-2011 Posted From: 136.223.19.43 Rating: N/A |
Bedar it depends. When you say large how large is it? In tera bytes? Both RMAN and datapump does a pretty good job with encryption(secure xfer)/compression(moves fast between sites). These adv features needs separate license (esp datapump). If you want to do this daily, you should probably look at something like oracle streams logical replication(licensed product) to move only changed data in last 24 hrs instead of moving entire database RMAN backups daily from A to B. If you don't have a choice, stick with RMAN. You can move RMAN incremental backups daily (sizes should be small compared to full backup and with RMAN block change tracking incremental backup will be very very fast) and ship full backup weekly or bi weekly. Construct the instance from backups every night from the shipped RMAN backups. Hope this helps! | ||
| Saint Side Hero Username: Saint Post Number: 2871 Registered: 01-2011 Posted From: 65.248.129.30 Rating: N/A |
idedo DBA related question anukunta..DBs ithe naaku teliyadu kaani annayi.... regular data ithe...normal gane work avvali kada..if u use tar with standard UNIX options... I'm not a Saint. | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 5062 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
Thanks brother, will read that. if you dont mind, a quick qn. What do you recommend? The use case is: A large production database has to be daily replicated to another site. no VPN or any sort of connectivity is allowed. some type of backup/restore export/import is permissible. source is AIX/Enterprise Dest is Linux/Standard. Daily operation. What will work? all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 5061 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
yes; and also, AIX has Enterprise Edition, but Linux will have only Standard Edition. all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Airliner Junior Artist Username: Airliner Post Number: 239 Registered: 11-2011 Posted From: 136.223.19.43 Rating: N/A |
when you say backup I hope you are talking about RMAN. This should help you: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxpl at.htm#BRADV89979 check the endian formats, if they are same RMAN convert will do the trick. If they are different it is a bit complex. I have never done this before, we always use Datapump export and import for cross platform migration. | ||
| Saint Side Hero Username: Saint Post Number: 2862 Registered: 01-2011 Posted From: 65.248.129.30 Rating: N/A |
EK... AIX backup ithe linux meeda restore cheyyacha ani meeru aduguthunnara? but Oracle installation... I'm not a Saint. | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 5058 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
AIX Enterprise 11 G backup - can it be restored in Linus Standard Edition Oracle? if it is confitional what are the conditions. I am sure if the source had enterprise features such as bitmap indices you cannot restore probably. has anyone been there and done that. all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. |
