| Neeraj |
Posted: Mar 18, 2008 07:41:28 AM |
Total Post: 228
Joined: Jan, 2007
|
hi,
i hav setup standby server on my oracle 9i database,it working fine but whatever i changes in my primary database i dont get it on my standby server.
where i made mistake tell me ?
and i also get error when i write
alter system switch logfile:
ora-16038
send me the solution of both rpoblems ?
thxs |
|
|
 Gitesh |
| Posted: Mar 18, 2008 08:06:38 AM |  |
|
Total Post: 322
Joined: May, 2005
|
If archivelogs doesn't apply on standby then how can we say that it is working fine?
Did you check the all standby parameters? Does your standby database is open readonly mode? Did you check alert.log? What is another error logged after said error?
|
|
|
|
|
| Neeraj |
| Posted: Mar 19, 2008 05:41:37 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
i m not getting archiveing on the standy by location , y i dont know
ERROR at line 1:
ORA-16038: log 1 sequence# 230 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/oradata/10g/db/instant/redo01.log'
that wt i get? if i m right then archiving shud be on both place at primary location & standby location, so wt paramter shud be set to get archiving on standby side.
can u send me all the parameters fro primary & standby server on 9i as well as 10g.
it wud be gr8 help of mine.
thxs
|
|
|
|
|
| MOH_DBA |
| Posted: Mar 22, 2008 06:30:13 AM | |
|
Total Post: 123
Joined: Nov, 2007
|
"limit exceeded for recovery files"
Cause: The limit for recovery files specified by the
DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Try to increase it.
and about the data gaurd parameters.
here is a link, i upload a complete reference in rapid share, i hope that will help.
http://rapidshare.com/files/101439938/DataGuard_9i.pdf.html
|
|
|
|
|
| Neeraj |
| Posted: Mar 24, 2008 01:01:31 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
but this parameter doesnt work on 9.0 version.
m i right ?
if yes then tell me alternate of this solution.
and y m i not getting archiveing on my standby server location as primary server location, i hav set up all paramters. tell me where i m doing mistake.
thxs
|
|
|
|
|
| MOH_DBA |
| Posted: Mar 24, 2008 04:38:52 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
Yes you are right. this parameter is for 10g.
for your problem i can give you this.
after entering the sqlplus as sysdba, type this command.
sql>archive log list
and this command will give you the destination of your archives, check the destination for free space.
and about the archive log in the standby.type this command in the standby database and tell me the output.
select status,error from v$archive_dest where dest_id=2;
|
|
|
|
|
| Neeraj |
| Posted: Mar 25, 2008 01:11:22 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
it shows
no rows selected
can u write me all paramters of primeary & standby server parameter file.
so i can check where i m making mistake.bcoz i m also not getting archiving on my standy by location.
thxs
|
|
|
|
|
| Neeraj |
| Posted: Mar 25, 2008 03:29:37 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
and whatever changes i made on primary database y m i not able to c that changes on my standby server.
after following steps:
connect scott/tiger@orclc on primary database and create table or insert row in any table.
Now connect as sys on primary database and execute following SQL statement
SQL> alter system switch logfile;
On standby database execute following SQL statements
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;
Database altered.
but i m not able to c that changes on standby server.
thxs
|
|
|
|
|
| Neeraj |
| Posted: Mar 25, 2008 04:27:48 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
hi, i m sendig u my parameters file tell me where i m making mistake.
my oracle is 9.0.1.0.1 & windows 2000 server
paramater file for primary database-----
*.background_dump_dest='D:\oracle\admin\main\bdump'
*.compatible='9.0.0'
*.control_files='D:\oracle\oradata\main\CONTROL01.CTL','D:\oracle\oradata\main\CONTROL02.CTL','D:\oracle\oradata\main\CONTROL03.CTL'
*.core_dump_dest='D:\oracle\admin\main\cdump'
*.db_block_size=4096
*.db_cache_size=33554432
*.db_domain=''
*.db_name='main'
*.dispatchers='(PROTOCOL=TCP)(SER=MODOSE)','(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)','(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)'
*.fast_start_mttr_target=300
*.instance_name='main'
*.java_pool_size='33554432'
*.large_pool_size='1048576'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=33554432
*.sort_area_size=524288
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='D:\oracle\admin\main\udump'
*.aq_tm_processes=1
*.instance_name='main'
*.log_archive_dest_1='LOCATION=D:\oracle\oradata\archive\main mANDATORY REOPEN=120'
*.log_archive_dest_2='SERVICE=stby'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_start=true
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.standby_file_management=AUTO
*.remote_archive_enable=TRUE
*.lock_name_space=MAIN
parametr file for standby server ------
*.background_dump_dest='D:\oracle\admin\STBY\bdump'
*.compatible='9.0.0'
*.control_files='D:\oracle\oradata\STBY\CONTROL_SB01.CTL'
*.core_dump_dest='D:\oracle\admin\STBY\cdump'
*.db_block_size=4096
*.db_cache_size=33554432
*.db_domain=''
*.db_name='MAIN'
*.dispatchers='(PROTOCOL=TCP)(SER=MODOSE)','(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)','(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)'
*.fast_start_mttr_target=300
*.instance_name='STBY'
*.java_pool_size='33554432'
*.large_pool_size='1048576'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=33554432
*.sort_area_size=524288
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='D:\oracle\admin\STBY\udump'
*.aq_tm_processes=1
*.instance_name='STBY'
*.log_archive_dest_1='LOCATION=D:\oracle\oradata\archive\STBY mANDATORY REOPEN=120'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_start=true
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.standby_file_management=AUTO
*.remote_archive_enable=TRUE
*.lock_name_space=STBY
*.standby_archive_dest='D:\oracle\oradata\archive\main'
*.db_file_name_convert='D:\oracle\oradata\main','D:\oracle\oradata\STBY'
*.log_file_name_convert='D:\oracle\oradata\main','D:\oracle\oradata\STBY'
*.service_names = STBY
|
|
|
|
|
| MOH_DBA |
| Posted: Mar 26, 2008 04:31:35 AM | |
|
Total Post: 123
Joined: Nov, 2007
|
Send the tnsname and listener for the standby and primary.
|
|
|
|
|
| Neeraj |
| Posted: Mar 26, 2008 06:01:44 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
stby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = stby)
)
)
MAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = main)
)
)
*************************************
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = machine1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = main)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = main)
)
(SID_DESC =
(GLOBAL_DBNAME = stby)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = stby)
)
)
|
|
|
|
|
| MOH_DBA |
| Posted: Mar 26, 2008 04:48:19 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
Your parameter and configuration seem right,
just add these parameters
add service_names parameter in the primary database,
and add in the standby database these parameters LOG_ARCHIVE_DEST_2=’SERVICE=primary_database REOPEN=60’, LOG_ARCHIVE_DEST_STATE_2=ENABLE.
and then
write this statement in primary, and give me the output:
SELECT * FROM V$ARCHIVE_DEST;
and write this statement in the standby database:
SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
If the MRP0
or MRP process exists, then the standby database is performing managed
recovery.
|
|
|
|
|
| Neeraj |
| Posted: Mar 28, 2008 03:20:41 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
now i m haing this error
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\STANDBY\SYSTEM01.DBF'
|
|
|
|
|
| MOH_DBA |
| Posted: Mar 30, 2008 12:10:06 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
when you take a backup from primary database, I preffered to do the following:
1) shutdown the database.
2) take a copy of the primary database to your standby database.
3) create a control file for the standby database.
4) create standby intitializtion parameter.
5) set up network.
6) start up standby database.
|
|
|
|
|
| Neeraj |
| Posted: Apr 04, 2008 02:23:54 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
i m getting archiving on my stnd by server but my database on stand by is not getting updated whatever i do change not my primary database not doing updated to standby when i run
alter system swich logfiles;
wt paramter i shud look for,& wt shud be the right values of that paramters.
thxs
|
|
|
|
|
| MOH_DBA |
| Posted: Apr 05, 2008 02:18:42 PM | |
|
Total Post: 123
Joined: Nov, 2007
|
when you issue these commands what is the output:
select status,error from v$archive_dest;
SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
