Home » Server Options » Data Guard » Creating Standby database (10.2.0.4)
Creating Standby database [message #425562] Fri, 09 October 2009 12:03 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior 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 #425596 is a reply to message #425562] Fri, 09 October 2009 20:10 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you checked the alert logs on each database?

Check v$archive_dest_status on the primary database and v$managed_standby on the standby to see if the two are in synch.
Re: Creating Standby database [message #425597 is a reply to message #425596] Fri, 09 October 2009 22:13 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior 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
Re: Creating Standby database [message #425684 is a reply to message #425597] Sun, 11 October 2009 15:38 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Reproduce the error

post tail end (last 30 - 40 lines) from listener.log from standby

post results from following commands on standby
lsnrctl status
lsnrctl service

Previous Topic: Shutdown standy before RMAN cold backup
Next Topic: Logical Standby SQL Apply idle Oracle 9i on Windows.
Goto Forum:
  


Current Time: Thu Mar 28 17:28:20 CDT 2024