Re: rman test restore

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

cptkirkh wrote:

> Ok with that in mind I have one more question. If the server I am
> using to do a test restore has a database with the same name and if
> there is an application on that server that connects to the production
> DB will the application be able to connect to the production DB after
> I create a DB by the same name?
>

Naming has little to do with it (or everything...). As the application connects to the production db, which is on another machine (names....), the application will still connect to the original database instance, not the clone.

Depends somewhat on how the application connects: - - using jdbc, the connection would be of the form machine_name:listener_port:service_name. - - using Oracle Net, the connection would either be using the same form, or a TNS alias.

In the first case, the machine name differs, so the application will connect to the original database instance. In the seconds case, you either have the first case, or your TNS alias would point to the original machine, causing the application to connect to the original database instance.

In short: it will connect to the original one, unless you change the way the application connects. You may consider defining duplicate connections - SQL*Net does try all defined connections sequentially, until the connection succeeds (or fails completely, of course)
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGXGayLw8L4IAs830RAp1lAKCX9stXOAKEhi0QzDQUEZ0g+8GJuQCeKCXe C0LSujKkioBUrMuWjqEiHJc=
=J0CK
-----END PGP SIGNATURE----- Received on Tue May 29 2007 - 12:45:22 CDT