OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN Rsync

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Rsync [message #120039]

Tue, 17 May 2005 08:01

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

I have a few databases that turn over archive logs on a regular basis due to Materialized views refreshing. I use RMAN to back up these databases to a remote machine and these databases that generate so many logs are proving to be a problem.

1. Has anyone had a problem where the rsync of the catalog to the controlfile starts to take forever because of the number of archive logs? How do you fix it if you did have the same issue?

2. Does anyone have experience with setting Materialized views to not log? I have turned the logging off on the views and the indexes and it still seems to generate the logs.

Any help would be appreciated.

Thanks

RucknRun

Report message to a moderator

Re: RMAN Rsync [message #120044 is a reply to message #120039]

Tue, 17 May 2005 08:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1.)
Known issue.
increase the sort_area_size for the target database.

2.)

Depends on what kind of refresh you do.
Tom Kyte talks about this
http://asktom.oracle.com/pls/ask/f?p=4950:8:7335939276318300124::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:15695764787749

Report message to a moderator

Re: RMAN Rsync [message #120053 is a reply to message #120044]

Tue, 17 May 2005 09:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>1. Has anyone had a problem where the rsync of the catalog to the controlfile starts to take forever because of the number of archive logs? How do you fix it if you did have the same issue?

what is the oracle version and OS?
this might also be a bug in 9i that is fixed in 10g.

Report message to a moderator

Re: RMAN Rsync [message #120058 is a reply to message #120044]

Tue, 17 May 2005 09:42

rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD

Junior Member

I am not sure what type of resync it does. Can you configure the database to only do a partial resync?

Report message to a moderator

Re: RMAN Rsync [message #120059 is a reply to message #120058]

Tue, 17 May 2005 09:45

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>I am not sure what type of resync it does. Can you configure the database to only do a partial resync?

The only resync option available to RMAN is

RMAN> resync catalog;

Report message to a moderator

Previous Topic:	Backup database on distinct OS using RMAN ( RMAN Hangs )
Next Topic:	Oracle 10g: Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:20:55 CDT 2024