| Creating Standby database [message #425562] |
Fri, 09 October 2009 12:03  |
ankush_chawla
Messages: 74
Registered: November 2006 |
Member |
|
|
hi
We followed the metalink doc and try to create the standby database.
We took the hot backup of production and starting preparing for standby database
We faced following issues
SQL> Alter database recover managed standby database disconnect from session;
Database altered.
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1:
Kindly help .
in one of the Forum soln provided was to executed the below command
SQL> alter database recover managed standby database;
However it ran endlessly for hours(>10hrs) doesnot seeems to show any results. So we cancelled and tried again to build the standby database however still the same issue
|
|
|
|
| Re: Creating Standby database [message #425597 is a reply to message #425596] |
Fri, 09 October 2009 22:13  |
ankush_chawla
Messages: 74
Registered: November 2006 |
Member |
|
|
I am able to log on to standby database from primary database site and still it gives me the below error
tnsping to ORCLSTAND is also working.
Error in Primary Alert log file
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
*** 2009-10-10 07:03:48.578 60680 kcrr.c
Error 12154 received logging on to the standby
Error 12154 connecting to destination LOG_ARCHIVE_DEST_1 standby host 'ORCLSTAND'
kcrrwupirfs KCRROCIS Handle 0x093AE338 has NULL OCI servicehandle - Returning success
Error 12154 attaching to destination LOG_ARCHIVE_DEST_1 standby host 'ORCLSTAND'
ORA-12154: TNS:could not resolve the connect identifier specified
*** 2009-10-10 07:03:49.109 58942 kcrr.c
it seems oracle not able to contact ORCLSTAND.
SQL> /
PROCESS PID STATUS CLIENT_P
--------- ---------- ------------ --------
CLIENT_PID
----------------------------------------
CLIENT_DBID
----------------------------------------
GROUP# RESETLOG_ID THREAD# SEQUENCE#
---------------------------------------- ----------- ---------- ----------
BLOCK# BLOCKS DELAY_MINS KNOWN_AGENTS ACTIVE_AGENTS
---------- ---------- ---------- ------------ -------------
ARCH 2676 CONNECTED ARCH
2676
1218979347
N/A 0 0 0
0 0 0 0 0
ARCH 3488 CONNECTED ARCH
3488
1218979347
N/A 0 0 0
0 0 0 0 0
However i am able to log on to standby database and i have verfied listener.ora and tnsnames.ora
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
