Re: Copy cold backup to another DB
Carlos:
If the test database and the production database are in different hosts
you can restore the cold backup on the host for test and you have a
database identical to production for testing. The sid is the same on
both hosts and you have to configure the tnsnames properly to access to
them.
If the databases are in the same host you will need to recreate the
instance and import. This can be easy made if your database is not very
big.
Un saludo.
.
Relevant Pages
- querying a table in Master as a semaphore
... We have a production database and a test database on different servers, ... if we restore the test database from the ... production database, we won't run the risk of forgetting to change the ...
(microsoft.public.sqlserver.connect) - Re: oracle standby datase with select option
... I need to create test database like production database. ... solution for now is standby databse but it not good enough there is any ...
(comp.databases.oracle.server) - Re: Any other way for non-static IPs?
... The current DNS ... often misunderstood RARP is actually a database lookup, ... >there should be no restriction), say: I have a local network named ABCD, ... >be different hosts and it will work. ...
(comp.os.linux.networking) - Re: oracle standby datase with select option
... I need to create test database like production database. ... The best solution for now is standby databse but it not good enough there is any other solution????? ...
(comp.databases.oracle.server) - Re: bad hosts ?
... >>Why we could not create a database of hosts known to misbehave (I mean ... >>just infected machines, or running portscans) which people could install ... > How do you decide if you trust the information this database is populated ...
(comp.os.linux.security) |
|
