| dataguard configuration physical [message #574496] |
Fri, 11 January 2013 05:22  |
 |
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 #574861 is a reply to message #574501] |
Wed, 16 January 2013 04:32  |
|
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 #574865 is a reply to message #574864] |
Wed, 16 January 2013 04:53 |
John Watson
Messages: 8964
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 #574952 is a reply to message #574939] |
Thu, 17 January 2013 01:20 |
John Watson
Messages: 8964
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 |
 |
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 #597481 is a reply to message #585354] |
Fri, 04 October 2013 23:52 |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
