OraFAQ Forum: Data Guard » Creating Standby database

Home » Server Options » Data Guard » Creating Standby database (10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating Standby database [message #425562]

Fri, 09 October 2009 12:03

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

Report message to a moderator

Re: Creating Standby database [message #425596 is a reply to message #425562]

Fri, 09 October 2009 20:10

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.

Report message to a moderator

Re: Creating Standby database [message #425597 is a reply to message #425596]

Fri, 09 October 2009 22:13

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

Report message to a moderator

Re: Creating Standby database [message #425684 is a reply to message #425597]

Sun, 11 October 2009 15:38

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 01:22:36 CST 2025