| archiving is not transfering on standby location [message #242256] |
Fri, 01 June 2007 06:17  |
rrajesh_jain
Messages: 13
Registered: May 2007
|
Junior Member |
|
|
HI All
I am very fresh dba. I am trying to create a standby database on the same machine. i have create pfile for primary and standby database. My connectivity with both services are working. after mounting up the standby database when i try to cancell the recovery by issuing command ALTER DATABASE RECOVER MANAGED STANDBY DATABASE then i got following error:-
ORA-00283 RECOVERY SESSION CANCELED DUE TO ERROR
ORA-01110 DATAFILE1 'D:\ORACLE\ORADATA\RAJESH1\SYSTEM01.DBF'
ORA-01157 CANNOT IDENTIFIE/LOCK DATAFILE1 -SEE DBWR TRACE FILE
ORA-01110 DATAFILE1 'D:\ORACLE\ORADATA\RAJESH1\SYSTEM01.DBF'
and when i query "SELECT DEST_ID,DEST_NAME,STATUS FROM V$ARCHIVE_DEST_STATUS;
then i got LOG_ARCHIVE_DEST_2
ERROR and also when i query the ERROR COLUMN THEN I GET DETAILS OF ERROR AS "ERROR ORA-16032: parameter STANDBY_ARCHIVE_DEST destination string cannot translated"
I have check the path for archiving destination that also sound to be right. below is pfile for my primary and standby database
ARCHIVING PARMETER FOR PRIMARY DATABASE
#########################################################
#################################################
# Arhiving
###############################################################
log_archive_dest_1 ='LOCATION=D:\oracle\admin\rajesh1\archive'
log_archive_dest_state_1 = 'ENABLE'
log_archive_dest_2 ='SERVICE=stby'
log_archive_dest_state_2 = 'ENABLE'
log_archive_start = true
log_archive_format = arc%t_%s.arc
remote_archive_enable =true
###############################################################
ARCHIVING PARAMETER FOR STANDBY PFILE
###############################################################
log_archive_dest_1 ='LOCATION=C:\oracle_STBY\admin\rajesh_STBY\archive'
log_archive_dest_state_1 = 'ENABLE'
log_archive_start = true
log_archive_format= arc%t_%s.arc
standby_archive_dest ='c\oracle_stby\admin\rajesh_stby\archive'
db_file_name_convert = 'd\oracle\oradata\rajesh1' 'c:\oracle_stby\oradata\data'
log_file_name_convert = 'd\oracle\oradata\rajesh1' 'c:\oracle_stby\oradata\data'
standby_file_management = AUTO
remote_archive_enable =TRUE
lock_name_space = stby
fal_server= rajesh1
fal_client =stby
##########################################################
plz help me where i m wrong and how can i create standby database on same machine. thanks
Regards
rajesh
|
|
|
|
| Re: archiving is not transfering on standby location [message #242299 is a reply to message #242256] |
Fri, 01 June 2007 09:27  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | log_archive_dest_1 ='LOCATION=D:\oracle\admin\rajesh1\archive'
log_archive_dest_state_1 = 'ENABLE'
log_archive_dest_2 ='SERVICE=stby'
log_archive_dest_state_2 = 'ENABLE'
|
Did you create service??
Log_archive_config=’DG_CONFIG=(primary,standby)’
Log_archive_dest_1=’Location=c:\oracle\backup
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=primary’
Log_archive_dest_2=’Service=to_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=standby’
Log_archive_dest_state_1=ENABLE
Log_archive_dest_state_2=DEFER
kEEP THE second dest defer until ur full configuration of standby.
take a look on file.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
