Home » RDBMS Server » Backup & Recovery » recovery catalog (10.2.0.3.0)
recovery catalog [message #318999] Thu, 08 May 2008 12:04 Go to next message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
Hi, I am new to RMAN, so maybe its a dumb question. Oracle documentation states that RMAN repository data is always stored in the control file of the target database. And that the repository can ALSO be kept in the recovery catalog. So it can be in both places or just one? If I choose to keep it in the recovery catalog, then I dont have to have it in the control file of the target database?

thank you!



Re: recovery catalog [message #319000 is a reply to message #318999] Thu, 08 May 2008 12:10 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The controlfile is normally limited as to how much (ie. how many days) RMAN data it can contain. The recovery catalog is essentially unlimited. The same info is kept in the controlfile and recovery catalog for a duration. It will eventually be aged out of the controlfile.

Check RMAN Repository.

[Updated on: Thu, 08 May 2008 12:11]

Report message to a moderator

Re: recovery catalog [message #319001 is a reply to message #319000] Thu, 08 May 2008 12:13 Go to previous messageGo to next message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
So I don't have to keep it in the control file then? I just got confused by the word "ALWAYS HAVE TO KEEP". thank you!
Re: recovery catalog [message #319003 is a reply to message #319001] Thu, 08 May 2008 12:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It will kept it in the control file by default, recovery catalog or not. No way around that. However, the amount of info in the control file is governed in part by CONTROL_FILE_RECORD_KEEP_TIME.

That being said, there are additional components that the recovery catalog can maintain (ie. backup/restore scripts) that the control file can not maintain.

[Updated on: Thu, 08 May 2008 12:16]

Report message to a moderator

Re: recovery catalog [message #319004 is a reply to message #319003] Thu, 08 May 2008 12:16 Go to previous messageGo to next message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
Oh, ok, so it will be kept in the control file no matter what. However, if I create a recovery catalog it will ALSO keep it there?
Re: recovery catalog [message #319005 is a reply to message #319004] Thu, 08 May 2008 12:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes.
Re: recovery catalog [message #319006 is a reply to message #319005] Thu, 08 May 2008 12:20 Go to previous message
lotusdeva
Messages: 201
Registered: March 2005
Senior Member
thank you!
Previous Topic: ORA-01190 on alter database open resetlogs after restore
Next Topic: Loss of redo-log files
Goto Forum:
  


Current Time: Tue Nov 26 06:05:30 CST 2024