Home » Server Options » Data Guard » dataguard configuration physical (rhel-5)
dataguard configuration physical [message #574496] Fri, 11 January 2013 05:22 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
hi i just try to configure the the psysical datagurad on the two system. but i cant success...
when i m going to recover primary database on secondary database using rman it gives me following errror...

both system have same os and oracle version (RHEL-5,oracle 10g 10.2)
i take the backup of the primary database and copy the backup on the secondary database in the same directory...

i dont know where i miss....plz help me to take the backup of the primary database using rman for standby physical database(specially controlfile)...

[oracle@pritesh backup]$ rman target=sys/oracle@orcl auxiliary=/

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jan 11 16:30:00 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1332164789)
connected to auxiliary database: ORCL (not mounted)
########################################################################

RMAN> duplicate target database for standby dorecover NOFILENAMECHECK;

Starting Duplicate Db at 11-JAN-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:
{
set until scn 490219;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 11-JAN-13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/backup/09nv5ipk_1_1
ORA-19870: error reading backup piece /u01/app/oracle/backup/09nv5ipk_1_1
ORA-19505: failed to identify file "/u01/app/oracle/backup/09nv5ipk_1_1"
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 2
failover to previous backup

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/backup/stancontrol.ctl
ORA-19870: error reading backup piece /u01/app/oracle/backup/stancontrol.ctl
ORA-19505: failed to identify file "/u01/app/oracle/backup/stancontrol.ctl"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/11/2013 16:30:21
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN>
##############################################################################
stancontrol.ctl is the name of controfile backup(rman)


please plz please help me.....

thanks and regards
pritesh ranjan
Re: dataguard configuration physical [message #574497 is a reply to message #574496] Fri, 11 January 2013 05:27 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
plz help me to take the backup of database, archive log and creating controlfile for standby database...

please refer me any link is avaliable....(i already search all the doc on the google)...
Re: dataguard configuration physical [message #574501 is a reply to message #574497] Fri, 11 January 2013 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Data Guard Concepts and Administration

Regards
Michel
Re: dataguard configuration physical [message #574507 is a reply to message #574501] Fri, 11 January 2013 07:35 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks to replay...
no dought u send me the best document..but in this document the dataguard configured with the backup as copy rather than rman and i m looking for datagrard configuration with the rman ....
plzz ref me any doc in that dataguard configured with the rman backup(controlfile create for standby with rman).

thanks & regards
pritesh ranjan
Re: dataguard configuration physical [message #574509 is a reply to message #574507] Fri, 11 January 2013 07:48 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
sory i have not seen the doc full the rman method define at the last of doc..
thanks & regards
pritesh ranjan
Re: dataguard configuration physical [message #574861 is a reply to message #574501] Wed, 16 January 2013 04:32 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
hi expert please help me
i success fully done all the steps of the creation of standby database on another linux system.
os- RHEL 5.4
DATABASE- 10G release 2
primary db name-- orcl
standby db name--stan


but when i m going to recover the standby database after successfully run the duplicate commnad its give me the following error-----

###############################################################################################################
SQL> startup
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/stan/system01.dbf'


SQL> alter database recover managed standby database disconnect from session;

Database altered.

i run this command after run duplicate command and wait 1:30 hr to recover the database..but no result found..
and at last i shutdown and restart the database and repeat the same step again but found no result...

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now


SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/stan/arch/
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL> select recovery_mode from v$archive_dest_status;

RECOVERY_MODE
-----------------------
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED
MANAGED

11 rows selected.



SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now


SQL
SQL> select database_role from v$database;

DATABASE_ROLE
----------------
PHYSICAL STANDBY

SQL> select name from v$database;

NAME
---------
ORCL



SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

no rows selected

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

no rows selected


#######################################################################################

please help me how can i resolve this...

thanks & regards
pritesh ranjan
Re: dataguard configuration physical [message #574862 is a reply to message #574861] Wed, 16 January 2013 04:36 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
i cant able to see the applyed archive log on the standby database (and open the standby database)

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/stan/arch/
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL>

please plz help me.......
Re: dataguard configuration physical [message #574864 is a reply to message #574862] Wed, 16 January 2013 04:43 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
i search all the metalink doc and google doc...all of the doc say to wait until the recovery is complete or cancel the recovery mode and restart the database normally.. i do that but cant success full..
so please help me
Re: dataguard configuration physical [message #574865 is a reply to message #574864] Wed, 16 January 2013 04:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Pritesh, you have not yet shown any evidence that the configuration is working, or that it is not. After this,
Quote:
SQL> alter database recover managed standby database disconnect from session;

Database altered.
query the v$managed_standby view in both the primary and the standby, and you will see what is happening.
Re: dataguard configuration physical [message #574867 is a reply to message #574865] Wed, 16 January 2013 05:28 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
as your suggeston is query the v$managed_standby table on both database the output is below

standby database

SQL> select process,status,client_pid,client_dbid from v$managed_standby;

PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6213
1332164789

ARCH CONNECTED 6215
1332164789

ARCH CONNECTED 6217
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6219
1332164789

ARCH CONNECTED 6221
1332164789

ARCH CONNECTED 6223
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6225
1332164789

ARCH CONNECTED 6227
1332164789

ARCH CONNECTED 6229
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6231
1332164789

ARCH CONNECTED 6233
1332164789

ARCH CONNECTED 6235
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6237
1332164789

ARCH CONNECTED 6239
1332164789

ARCH CONNECTED 6241
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6243
1332164789

ARCH CONNECTED 6245
1332164789

ARCH CONNECTED 6247
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6249
1332164789

ARCH CONNECTED 6251
1332164789

ARCH CONNECTED 6253
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6255
1332164789

ARCH CONNECTED 6257
1332164789

ARCH CONNECTED 6259
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6261
1332164789

ARCH CONNECTED 6263
1332164789

ARCH CONNECTED 6265
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6267
1332164789

ARCH CONNECTED 6269
1332164789

ARCH CONNECTED 6271
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
MR(fg) WAIT_FOR_LOG N/A
N/A


31 rows selected.

SQL>

output of the primary database----
SQL> select process,status,client_pid,client_dbid from v$managed_standby;

PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4387
1332164789

ARCH OPENING 4389
1332164789

ARCH CONNECTED 4391
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4393
1332164789

ARCH CONNECTED 4395
1332164789

ARCH CONNECTED 4397
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4399
1332164789

ARCH CONNECTED 4401
1332164789

ARCH CONNECTED 4403
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4405
1332164789

ARCH CONNECTED 4407
1332164789

ARCH CONNECTED 4409
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4411
1332164789

ARCH CONNECTED 4413
1332164789

ARCH CONNECTED 4415
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4417
1332164789

ARCH CONNECTED 4419
1332164789

ARCH CONNECTED 4421
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4423
1332164789

ARCH CONNECTED 4425
1332164789

ARCH CONNECTED 4427
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4429
1332164789

ARCH CONNECTED 4431
1332164789

ARCH CONNECTED 4433
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4435
1332164789

ARCH CONNECTED 4437
1332164789

ARCH CONNECTED 4439
1332164789


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 4441
1332164789

ARCH CLOSING 4443
1332164789

ARCH CONNECTED 4445
1332164789


30 rows selected.

SQL>

on the primary---
SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
52
on the standby---

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------


on the standby ---



SQL> select process,status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
MR(fg) WAIT_FOR_LOG

31 rows selected.

SQL>

on the primary---

SQL> select process,status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH OPENING
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
ARCH CONNECTED

30 rows selected.

SQL>
Re: dataguard configuration physical [message #574883 is a reply to message #574867] Wed, 16 January 2013 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

Regards
Michel
Re: dataguard configuration physical [message #574939 is a reply to message #574883] Wed, 16 January 2013 23:37 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
sory for that but please suggest me what can i do......to start the standby database..

thanks & regards
pritesh ranjan
Re: dataguard configuration physical [message #574952 is a reply to message #574939] Thu, 17 January 2013 01:20 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
sory for that but please suggest me what can i do.
Don't be sorry, man, just do it: read the guide, and learn how to use the code tags.
Then run this query against both databases, after starting the managed recovery:
select process,status,sequence#,block# from v$managed_standby;
Re: dataguard configuration physical [message #585353 is a reply to message #574952] Fri, 24 May 2013 01:16 Go to previous messageGo to next message
justinxavier
Messages: 1
Registered: May 2013
Location: chennai
Junior Member
Hi friends,
i am also facing same issue,pls how do resolve the issue,
SQL> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active


SQL> recover managed standby database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'E:\APP\BGH30512\ORADATA\MIA\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'E:\APP\BGH30512\ORADATA\MIA\SYSTEM01.DBF'


SQL> select recovery_mode from v$archive_dest_status;

RECOVERY_MODE
-----------------------
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE

11 rows selected.

SQL>
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

no rows selected

SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\app1\Administrator\flash_recovery_area\ARICENT\ONLINELOG
Oldest online log sequence 66
Next log sequence to archive 68
Current log sequence 68
SQL> select process,status,client_pid,client_dbid from v$managed_standby;

PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 5176
3081466420

ARCH CONNECTED 5800
3081466420

ARCH CONNECTED 4004
3081466420


PROCESS STATUS CLIENT_PID
--------- ------------ ----------------------------------------
CLIENT_DBID
----------------------------------------
ARCH CONNECTED 6980
3081466420

ARCH CONNECTED 7160
3081466420


SQL>
SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------


SQL>
SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------


SQL>
SQL> select process,status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED

SQL>
SQL> select process,status,sequence#,block# from v$managed_standby;

PROCESS STATUS SEQUENCE# BLOCK#
--------- ------------ ---------- ----------
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0

SQL>


but still i could not able to connect both db as sysn ,kindly advise any one.

regards,
justin
Re: dataguard configuration physical [message #585354 is a reply to message #585353] Fri, 24 May 2013 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-01110: data file 1: 'E:\APP\BGH30512\ORADATA\MIA\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file


Regards
Michel
Re: dataguard configuration physical [message #597481 is a reply to message #585354] Fri, 04 October 2013 23:52 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Priteshranjan, what happened to init.ora file parameter in both primary and standby, did you entered all the parameters correctly,can you just post those file parameters for refererence, what happened to the password files did you created them in the correct location?
icon5.gif  Re: dataguard configuration physical [message #597484 is a reply to message #597481] Sat, 05 October 2013 00:38 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

How all these will/can fix the error on datafile?

Previous Topic: Recovery not running
Next Topic: ORA_01157 and ORA_01110
Goto Forum:
  


Current Time: Thu Mar 28 04:45:46 CDT 2024