Hi DBAs,
os:windows2000professional oracle:8.1.7
Iam trying to create a standby database on the same host as primary database.I followed all the instructions given in 'oracle8i standby database concepts and administration' guide.but when iam mounting standby database ..i face this pb..try to help me..urgent...plz
Note:DB name in both cases is same I.e original
In stdby init.ora file lock_name_space is specified
regards and thanks
Raju
C:\>set oracle_sid=original
C:\>sqlplus/nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 23 15:05:12 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> connect internal
Enter password:
Connected.
SQL> startup pfile=c:\oracle\admin\original\pfile\init.ora;
ORACLE instance started.
Total System Global Area 54683676 bytes
Fixed Size 75804 bytes
Variable Size 54120448 bytes
Database Buffers 409600 bytes
Redo Buffers 77824 bytes
Database mounted.
Database opened.
C:\>set oracle_sid=stdby
C:\>sqlplus/nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 23 20:51:38 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> connect internal/oracle
Connected to an idle instance.
SQL> startup nomount pfile=c:\oracle\admin\stdby\pfile\init.ora;
ORACLE instance started.
Total System Global Area 54683676 bytes
Fixed Size 75804 bytes
Variable Size 54120448 bytes
Database Buffers 409600 bytes
Redo Buffers 77824 bytes
SQL> alter database mount standby database;
alter database mount standby database
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode
