Home » Server Options » Data Guard » not log in after shutdown
not log in after shutdown [message #319380] Sat, 10 May 2008 05:29 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

Enter user-name: sys/test_bm@test_bm as sysdba
ERROR:
ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA
Re: not log in after shutdown [message #319381 is a reply to message #319380] Sat, 10 May 2008 05:36 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

i want to make one physical stand by database and for that i shutdown the TEST_BM and copies all the *.dbf file in TEST_BM_S_P .

and after i want to startup TEST_BM but i can't .

SQL> startup pfile=$ORACLE_HOME/dbs/initTEST_BM.ora open resetlogs;
ORACLE instance started.

Total System Global Area 1140397296 bytes
Fixed Size 451824 bytes
Variable Size 352321536 bytes
Database Buffers 786432000 bytes
Redo Buffers 1191936 bytes
ORA-01504: database name 'RESETLOGS' does not match parameter db_name 'TEST_BM'

i also try to open like this but not open

[Updated on: Sat, 10 May 2008 05:39]

Report message to a moderator

Re: not log in after shutdown [message #319383 is a reply to message #319381] Sat, 10 May 2008 06:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I would highly recommend reading Creating a Physical Standby Database.
Re: not log in after shutdown [message #319385 is a reply to message #319383] Sat, 10 May 2008 06:45 Go to previous message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

thanks
problem was solved

first i export ORACLE_SID

and startup with pfile
Previous Topic: Doubt regarding switchover from logical standby to primary
Next Topic: TableSpace Creation Problem in Standby database
Goto Forum:
  


Current Time: Thu Mar 28 03:09:36 CDT 2024