Home » RDBMS Server » Backup & Recovery » Importance of Control file with RMAN
Importance of Control file with RMAN [message #215058] Fri, 19 January 2007 03:09 Go to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi All,

I am performing backup and recovery using RMAN on Oracle 9i. I am using Control file while backing the databases. I am not using Recovery catalog.

I have few doubts on this:

Q1). What are the major disadvantages of using Control file for Oracle database backup?

Q2). I don't want to use Recovery catalog for any backup operation. I want to use only Control file Is it possible?

Please help me.

Regards,
Kamal
Re: Importance of Control file with RMAN [message #215066 is a reply to message #215058] Fri, 19 January 2007 03:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1) http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrepos.htm#446924
2) Yes. Almost all vital operations are possible.
Re: Importance of Control file with RMAN [message #215077 is a reply to message #215058] Fri, 19 January 2007 03:57 Go to previous messageGo to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi Mahesh,

Thanks alot for the useful information.

I have one more query:

Q1). Do I need to have a separate database to create Recovery Catalog?

Q2). Assume that I want to backup a database --> DB1.
I want to use Recovery catalog. In this case can create the Recovery Catalog in DB1?

Or do I need to have separate database like -->DB2?

Please help me.

Regards,
Kamal






Re: Importance of Control file with RMAN [message #215081 is a reply to message #215077] Fri, 19 January 2007 04:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1). Yes. Recomended
2). What happens if you loose the database?
You lost your recovery catalog too!.
So, what is the whole idea? Smile
Obviosly, keep recovery catalog seperate (preferebly seperate hardware) from database that is been backed up.
Re: Importance of Control file with RMAN [message #215442 is a reply to message #215058] Mon, 22 January 2007 05:40 Go to previous messageGo to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Thanks Mahesh,

I have one more query about the size of a control file on Windows. I have read that the size of a Control file will be increased based on the Operating System.

Q1). What is the maximum size of a control file on Windows Operating System?

Q2). Is there any difference in the size of a control file on different Windows versions such as Win 2000, 2003, xp?

Please help me.

Regards,
Kamalakar.
Re: Importance of Control file with RMAN [message #215460 is a reply to message #215442] Mon, 22 January 2007 06:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Q1). What is the maximum size of a control file on Windows Operating System?


http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10739/control.htm#i1006226

Q2). Is there any difference in the size of a control file on different Windows versions such as Win 2000, 2003, xp?

It depand on some parameters ( database ) not OS AFAIK.

regards
Taj
Re: Importance of Control file with RMAN [message #215463 is a reply to message #215442] Mon, 22 January 2007 06:56 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Controlfile has no 'max' size limit. size depends on the parameters and said documentation.
If you are planning to use control file, research more about CONTROL_FILE_RECORD_KEEP_TIME.
Previous Topic: create backup database
Next Topic: restoring DB to previous stage
Goto Forum:
  


Current Time: Sat Nov 23 04:31:15 CST 2024