| Clone database [message #58463] |
Fri, 29 August 2003 02:55  |
Dik
Messages: 27
Registered: June 2002
|
Junior Member |
|
|
Hi,
I am doing cold backup(with tar-Unix)twice a week (database is in archivelog mode).I would like to have the same database (with same data)on other machine. What is the best way to to clone it, replicate it every night (the machines are connected).
Thanks
|
|
|
|
|
|
|
|
| Re: Clone database [message #58466 is a reply to message #58464] |
Fri, 29 August 2003 04:55  |
Dik
Messages: 27
Registered: June 2002
|
Junior Member |
|
|
Am I right,
If I have the most important files (control file, password file, datafiles..) on tape (backup on Unix with tar option)I can only extract files on the other machine and database is cloned, changes should be daily updated with export an import option? I do not use rman!
|
|
|
|
| Re: Clone database [message #58529 is a reply to message #58463] |
Mon, 15 September 2003 14:02 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Cloning a DB in UNIX is much easier than export/import.
Are you using 8i or 9i ? as the procedures are a little different.
For 8i here
http://www.bijoos.com/oratom/ot_199903.htm
For 9i, there is no svrmgrl, so use
sqlplus /nolog
connect / as sysdba
and make sure there are no lines with '#' (pound) as Sqlplus DOES NOT like '#'.
Has worked fine for me.
If it does not work, contact me.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
