|
|
| Re: Check RFS server is working [message #276992 is a reply to message #276945] |
Sat, 27 October 2007 14:24   |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Yes.
RFS (remote file server) the Remote File Server (RFS) process receives the redo
data and writes it to a Standby Redo Log (SRL). RFS sends an acknowledgement
back to the production database that the redo has been received and written to
disk. When the production database receives this acknowledgement, it
acknowledges the commit to the client application and processes the next transaction.
You can check it by this query if the transaction are running on Primary.
SQL>SELECT PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS FROM
V$MANAGED_STANDBY;
Notice the block# for the RFS and MRP0 increasing If it keeps increasing
it means your RFS working other wise not only when transactions are running on primary.
http://www.oracle.com/technology/deploy/availability/pdf/NeuStarProfile.pdf
[Updated on: Sat, 27 October 2007 14:24] Report message to a moderator |
|
|
|
| Re: Check RFS server is working [message #277099 is a reply to message #276992] |
Sun, 28 October 2007 22:05 |
vivekmenon_k@yahoo.co.uk
Messages: 6
Registered: October 2006
Location: India
|
Junior Member |
|
|
Thanks for your reply.
1.If RFS is an background process, why is it that its not visible at OS level while using ps -ef | grep "ora_" .
2. Is RFS started in standby by default.Is there any parameter that we need to be set to start RFS process.
|
|
|
|
| Re: Check RFS server is working [message #277327 is a reply to message #277099] |
Mon, 29 October 2007 10:52 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Yes RFS is background process.
http://www.dba-oracle.com/t_background_processes.htm
SQL> SELECT PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS FROM
2 V$MANAGED_STANDBY;
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 7748 1 9 0
ARCH CLOSING 7049 59393 990 0
RFS IDLE 7749 49741 50 0
RFS IDLE 0 0 0 0
MRP0 APPLYING_LOG 7749 49739 65536 0
Here RFS process is idle its mean theres no archive log generation on Primary.
And regarding ps-ef |grep ora_rfs may be it goes active when archive generated from primary just a guess.
|
|
|
|
| Re: Check RFS server is working [message #277571 is a reply to message #276945] |
Tue, 30 October 2007 11:05 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
SQL> SELECT PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS FROM
2 V$MANAGED_STANDBY;
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 10 1 2 0
ARCH CLOSING 10 1 2 0
Any idea why it is not listing RFS ?i just created a primary-standby setup on different machines and looks like everything works fine.
[Updated on: Tue, 30 October 2007 11:13] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Check RFS server is working [message #277602 is a reply to message #277596] |
Tue, 30 October 2007 14:22 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
Are you using REAL TIME apply?Then don't do a switch .
if not using REAL TIME then on PRIMARY switch manually after committing records.
Post a test case.
On Primary
==========
SQL> create table test ( sno number(5));
Table created.
SQL> insert into test select sid from v$session;
21 rows created.
SQL> commit;
Commit complete.
SQL>
On Standby
==========
SQL> SELECT PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS FROM
V$MANAGED_STANDBY;
2
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 7758 57345 1256 0
ARCH CLOSING 7049 59393 990 0
RFS IDLE 7759 25997 1 0 <<<<<<<<<<<<<<<<< check this one
RFS IDLE 0 0 0 0
MRP0 APPLYING_LOG 7759 25995 65536 0
again
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 7758 57345 1256 0
ARCH CLOSING 7049 59393 990 0
RFS IDLE 7759 26015 32 0 <<< check this one
RFS IDLE 0 0 0 0
MRP0 APPLYING_LOG 7759 26013 65536 0
Now cancel recovery and check
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN READ ONLY;
Database altered.
SQL> conn xxx/xxx
Connected.
SQL> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
SNO NUMBER(5)
SQL> select count(*) from test;
COUNT(*)
----------
35
|
|
|
|
| Re: Check RFS server is working [message #282291 is a reply to message #276945] |
Wed, 21 November 2007 06:53 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear
whenever i check this one at standby Db
SQL> SELECT PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS
FROM V$MANAGED_STANDBY;
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 15 0 0 0
RFS RECEIVING 0 0 0 0
again and again...................
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 15 0 0 0
RFS RECEIVING 0 0 0 0
please suggest !
|
|
|
|
| Re: Check RFS server is working [message #282304 is a reply to message #276945] |
Wed, 21 November 2007 07:14 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
PROCESS STATUS SEQUENCE# BLOCK# BLOCKS DELAY_MINS
------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 15 0 0 0
RFS RECEIVING 0 0 0 0
Without waiting i issued the following
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
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: 'D:\ORACLE\ORADATA\STDY\SYSTEM01.DBF'
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 89201304 bytes
Fixed Size 453272 bytes
Variable Size 71303168 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
ORA-01666: controlfile is for a standby database
Now what to do now to startup the standby DB??
Please Suggest!
|
|
|
|
| Re: Check RFS server is working [message #282344 is a reply to message #282304] |
Wed, 21 November 2007 10:56 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
I guess your DG is not configured properly.Did you open your standby database when you copied the backup from PRIMARY and restore that on STANDBY?
Check the archive log on both system PRIMARY and STANBY copy all non-existence archive logs from PRIMARY to STANDBY and perform recovery.
Or you should recreate your data guard if your on test server.
|
|
|
|
| Re: Check RFS server is working [message #282604 is a reply to message #276945] |
Thu, 22 November 2007 08:50 |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
I m very new to DATAGAURD so i don't have an exact idea whether standby db is configured properly or not
i had recreated the physical standby db again but getting the same problem again
what i did to open the standby DB
C:\>set oracle_sid=stdy
C:\>sqlplus /nolog
SQL>conn sys as sysdba
password:
connected to an Idle Instance
SQL>create spfile from pfile='.......'
SQL>startup nomount
SQL> alter database mount standby database;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
and after that the archivelogs are applied
but if i use the following procedure to open the db in read only mode first it fails with the error
SQL> startup open read only
ORACLE instance started.
Total System Global Area 85006980 bytes
Fixed Size 453252 bytes
Variable Size 67108864 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
ORA-01666: controlfile is for a standby database
but after that i do the following
SQL> alter database mount standby database;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
AND THEN I DO THE FOLLOWING TO OPEN THE DATABASE
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
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: 'D:\ORACLE\ORADATA\ORCLSTDY\SYSTEM01.DBF'
I HAD TAKEN THE BACKUP OF PRIMARY DB WHILE DB IS SHUTDOWN CLEANLY TO RESTORE IT ONTO
STANDBY SERVER BUT I AM GETTING THIS TYPE OF ERROR
WHAT I SHOULD HAVE TO DO TO OPEN DATABASE IN READ ONLY MODE ?????
ONCE I HAD INITIATED THE LOG APPLY SERVICE BY USING THE FOLLOWING
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
i hope u'll help me in this regard.
Regards,
|
|
|
|
|
|
|
|
| Re: Check RFS server is working [message #508432 is a reply to message #276945] |
Sat, 21 May 2011 02:33 |
 |
racadmin
Messages: 1
Registered: May 2011
Location: India
|
Junior Member |
|
|
Check whether there is any trace files generated in the production or DR server..
Check whether you were able to ping DR from production..
Check whether the archiver process is sending the log files...
racadmin.blogspot.com /2011 /05 /rfs-process-not-working.html
Thanks
Vinod D
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
