Export will definitely work irrespective of number of references between
diff tables.I exported/imported a 40 GB database without any problems.
Yes,U can take hot backup and restore and recover the DB by applying
archivelogs.
-Original Message-
Sent: Thursday, August 09, 2001 7:06 PM
Hi,
What is the size of the database?If it is less than 4 or 5 GB better go for
exp/imp.
There are various factors, first of all can u afford to shutdown the prod
instance if so how long?
yes it is possible to copy the datafiles at OS level and up the DB on test
machine.
Regds,
Uma
normal shutdown!
-Original Message-
Sent: Thursday, August 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Yes, what this is doing is the same as restoring from a cold backup. If
the machines are the same, you can just shutdown Oracle and copy data
files, control files, redo
How about giving it a try? I'm a DBA, not a soothsayer and
to give a definite answer, I'd need minute details like OS on
each box, with version, what are you copying and how are you
copying it. As of now, I can tell you only one thing:
Idis redibis nunquam in bello peribis (commas are missing on
Just be sure that if you copy your listener.ora file from the first box you
change the hostname! Otherwise you'll risk shutting down the listener on
the original box.
-Original Message-
Sent: Thursday, August 09, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Yes, what this is
Sujatha
Yes, it will work assuming your production and test boxes are of the same OS, version etc. Technically, at least with the same endianness. You should take copy all the files including control files , init files, data files and redo log files to the test server. Then you could bring up
The export import won't work because there are so many constraints and
references between various tables. So there are a lot of errors. Also the
database is quite large (definitely more than 5 GB).
What if I do a hot backup of each tablespace and the control files. would I
be able to restore
Yes, what this is doing is the same as restoring from a cold backup. If
the machines are the same, you can just shutdown Oracle and copy data
files, control files, redo logs and the contents $ORACLE_HOME across to
an identical directory structure on a new machine, change any settings
like
i tested it on windows 2000 and oracle 816-817, it works well, nothing wrong.
if test env, i think it should work.
if in production, u'd better use other way.
- Original Message -
From: Sujatha Madan [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]