Home » Server Options » Data Guard » Check RFS server is working
Check RFS server is working [message #276945] Sat, 27 October 2007 04:16 Go to next message
vivekmenon_k@yahoo.co.uk
Messages: 6
Registered: October 2006
Location: India
Junior Member
Is RFS an background process.How do I check if its working or not.Can I stop and start RFS.
Re: Check RFS server is working [message #276992 is a reply to message #276945] Sat, 27 October 2007 14:24 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #277594 is a reply to message #277571] Tue, 30 October 2007 13:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you check working of your Data Guard?
Post oracle version 4 decimals.
Re: Check RFS server is working [message #277596 is a reply to message #277594] Tue, 30 October 2007 13:46 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I could see archives are transffered/applied properly .

i am using Oracle 10.2.0.1 on Windows.
Re: Check RFS server is working [message #277602 is a reply to message #277596] Tue, 30 October 2007 14:22 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #282606 is a reply to message #282604] Thu, 22 November 2007 08:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You still getting error...
did you properly set all reqiured parameter for primary and standby db ?
did you follow step by step below procedure ?
Physical standby database creation.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10823/create_ps.htm#63563
http://dbataj.blogspot.com/2007/03/standby-database.html

Logical standby database creation.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10823/create_ls.htm#63563
http://dbataj.blogspot.com/2007/06/logical-standby-database.html



Re: Check RFS server is working [message #283271 is a reply to message #282606] Mon, 26 November 2007 10:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Read it for DG configuration.
Re: Check RFS server is working [message #508432 is a reply to message #276945] Sat, 21 May 2011 02:33 Go to previous message
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
Previous Topic: Rac Dataguard Gap Query
Next Topic: step backup
Goto Forum:
  


Current Time: Thu Mar 28 13:54:48 CDT 2024