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
on purpose).
This should satisfy your urge for knowledge.
-Original Message-
From: Sujatha Madan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 10:06 PM
To: Multiple recipients of list ORACLE-L
Subject: O/S copies of datafiles
Hi,
This might be a stupid question
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
Certified Oracle DBA
i2 technologies www.i2.com
Sujatha Madan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/08/01 09:05 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:O/S copies of datafiles
Hi,
This might
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
Hi,
This might be a stupid question, but I'll give it a go anyway.
I have two Unix boxes - a production and a newly created test box. The
production box has 8.0.5 and the test has 8.0.6 installed.
Is it possible to stop the database, take a backup of all the datafiles
(through the operating
]
Sent: Thursday, August 09, 2001 10:05 AM
Subject: O/S copies of datafiles
Hi,
This might be a stupid question, but I'll give it a go anyway.
I have two Unix boxes - a production and a newly created test box. The
production box has 8.0.5 and the test has 8.0.6 installed
10 matches
Mail list logo