hi,
I have a compaq trueunix(my current db) and hp-ux unix server(target new db), can i perform a cold backup(using gzip) in compaq and ftp into hp-ux and then recreate controlfile to CLONE my db??
is this possible??or i hv to use export/import?
thank in advance
No, you can't do that.
Yes, you can use import and export.
after thought...Even though your OS's are UNIX, they're different flavors of UNIX. Kinda like Orange's and Tangerines.
so in the same sense even transportable tablespace also cant work in that way , am i right??
OracleDoc,
BTW...when u say export/import are we talking abt exporting in my hp-ux by doing a sqlplus connection to my db in compaq rite?? and then perform an import at the same unix prompt?
Yes you are correct transportable tablespaces won't work either. It has to be the same OS. :( That feature is great if you have a prod and dev database on the same OS.
On compaq: exp system/bla bla file=full_db.dmp full=y
ftp: full_db.dmp to HP.
On HP: imp system/bla bla file=full_db.dmp ect ect.
As I'm sure you're aware there's other things you need to look out for like file size and such but that's the jist of it.
hi oracledoc,
u sure it'll work using ur method? I thot it shld be:
HP: exp user/passwd@compaqdb_tns file=abc.dmp full=y
HP: imp user/passwd file=abc.dmp commit=y
....somethg like that? becos the dmp created in compaq will hv
diff format when ftp into HP OS rite? Correct me if I am wrong?
yes it will work. If you don't believe me try doing just one table. the .dmp file is basically a txt file. Yes, it has some binary headers on it and yes it will get corrupted if you go try to manually edit the contents. But, for your purposes it will work. Go try it :p
10g introduces Cross-Platform Transportable Tablespaces.Quote:
Originally posted by OracleDoc
Yes you are correct transportable tablespaces won't work either. It has to be the same OS.
Ohhh man that's right! I forgot about that, thanks Sanjay!
IMHO, IT seems that the real difference is not the difference in OS, it is the difference in file system. The other difference would be the character-set used by the OS.
Using You can always try ftping the files over and see if they won't if the file systems are different they probably won't work.
If you do the exp/imp option, you can do one of two things. You can pipe the exp to compress ftp it to the target node using binary then pipe it from compress to imp. You can also create an OS pipe to directly pipe it to the other machine. I haven't done the second option myself, however, Where I worked last they were using that option to clone a 1tb database from SGI to HP-UX.
hmm...instead of us OS pipe(as in NFS??) wouldn't it be better to us exp via oracle network ??
Why all these hassels? do the following and it will all be easier.
Use RMAN.
1. Make sure that the Target DB uses the remote_login_password_file=exclusive and there is a passwordfile for it.
2. Create a user account with the SYSDBA & SYSOPER roles
3. Take an RMAN cold backup on the target database.
(Remember to specify the backup directory in the format)
4. Copy all those backups to the HP system, under the same directory location, where it was backed up
5. Copy the controlfile, change the DBname, and other parameters
6. Connect to target and auxillary through rman
7. Issue the database duplication command. (This will change the DBID for the new database)
8. You are done.
This would be a clean approach.
Thanx,
Sam
I agree with you Sam. However, not everyone uses rman. It is good for mainting test databases, which is what I used it for. We had a couple of shell scripts one to backup, one to restore, one to create a stand by database and one to clone a database.Quote:
Originally posted by sambavan
Why all these hassels? do the following and it will all be easier.
Use RMAN.
1. Make sure that the Target DB uses the remote_login_password_file=exclusive and there is a passwordfile for it.
2. Create a user account with the SYSDBA & SYSOPER roles
3. Take an RMAN cold backup on the target database.
(Remember to specify the backup directory in the format)
4. Copy all those backups to the HP system, under the same directory location, where it was backed up
5. Copy the controlfile, change the DBname, and other parameters
6. Connect to target and auxillary through rman
7. Issue the database duplication command. (This will change the DBID for the new database)
8. You are done.
This would be a clean approach.
Thanx,
Sam
We're talking across platforms here. Rman (up to 9.2 anyway) won't work cross platforms.Quote:
Originally posted by sambavan
Why all these hassels? do the following and it will all be easier.
Use RMAN.
Whoops. Leave it to a Super-Genius to point out the obvious.Quote:
Originally posted by marist89
We're talking across platforms here. Rman (up to 9.2 anyway) won't work cross platforms.
:o
Hi all,
I have split the thread, so that the topics does not interfear with the original post.
Ref http://www.dbasupport.com/forums/sho...threadid=44011
Thanx,
Sam