| dataguard configuration physical [message #574496] |
Fri, 11 January 2013 05:22  |
 |
priteshranjan.preet
Messages: 125
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: 125
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: 3110
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: 3110
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
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
