Home » RDBMS Server » Backup & Recovery » rename database
rename database [message #186386] Mon, 07 August 2006 14:58
sweet_angel
Messages: 4
Registered: July 2006
Junior Member
once again


Hi all
i am a newbie to oracle database with an issue
i currently have a production database(LIVE) and a standby database to the production database (LIVEBY).

The production machine initSID.ora file has the database name, domain name etc as

db_name = "LIVE"
#
db_domain = gbti.com
#
instance_name = LIVE
#
service_names = LIVE.gbti.com
#

the standby machine has the initSID.ora file has the database name, domain name etc as

db_name = "LIVE"
#
db_domain = gbtibank.com
#
instance_name = LIVE
#
service_names = LIVEBY.gbtibank.com
#

my problem is when i do a database failover of the standby database i cannot access the new production database with out putting @LIVEBY

eg user/pwd@LIVEBY

what parameters or name do i need to change so that i can now access the standby database as 'LIVE'


Regards
Previous Topic: ORA-00904 -- Export Problem
Next Topic: cannot register backup on catalog and resync fail
Goto Forum:
  


Current Time: Thu May 02 20:27:54 CDT 2024