Hot Search: Store süß fort Windows phone execute permission denied in ssrs alv_column_tree ko8g set up labview run sub vi in the background anything Tiller mail run labview without software
Home >Default > Control File to a catalog Database

Control File to a catalog Database

-0001-11-30 | Default
Hi guys,
I'm kind of new here. So sorry if this has already been answered. (did some searching and nothing showed up)
Environment - Oracle 9i
Ok. Currently we are using RMAN with a control file. And there's a requirement to set up a catalog database. I would like to know if there's a way to migrate the current set up to a catalog database. Final goal is to make sure that the past backups will be available after moving to a catalog database.

Latest answer

Controlfile backup taken during a backup means you will have past information relevant to current state as of the time of the backup. Going forward with a catalog means you will have a longer (as in closer to forever) record of backups whereas a CF only keeps what it can up to the record keep time. You can always catalog prior backups if you want.

Related recommended

Control File to a catalog Database

Hi guys, I'm kind of new here. So sorry if this has already been answered. (did some searching and nothing showed up) Environment - Oracle 9i Ok. Currently we are using RMAN with a control file. And there's a requirement to set up a catalog database. [More]

-0001-11-30 Default

Control File error while duplicating Database through Rman

Hi, Oracle Ver: Oracle Database 10g Enterprise Edition Release - Production Os:Win Xp I am trying to create a Standby through Rman.... I am using this Run Block to take backup of Primary Database....... run { allocate channel d1 type disk; [More]

2015-10-11 Default

Problems creating control file in RMAN duplicate database

There is so much detail involved in this operation that I don't know what might be useful, so I'll start simple. I'm attempting to clone a database on the same host using RMAN "duplicate database". I finally got all the setup done, the OS authen [More]

-0001-11-30 Default


Hello All, The disk failure caused our production data on the disk to be resotred with the backup data available and recovered through RMAN with cotrolfile , and no catalog DB is configured. I had the restored the spfile and control file then recover [More]

2015-10-11 Default

Output is no longer available in the database control file

Hi All in Oracle 10g ( - on suse Linux 9, OEM (; I'm getting when I try to look at RMAN reports that databases reports are "Job output is no longer available in the database control file." - one one database. I've searched [More]

2015-11-26 Default

Database restore without temp, undo and control files.

Hi All, You might found this question silly but I don't know so asking this question here. I have cold back up of the database. Now, I want create clone of that database, but I have some different paths for the DBFs so I will create new control file [More]

-0001-11-30 Default

RMAN-06067: RECOVER DATABASE required with a backup or created control file

Hi, Oracle version :10.2.04 I recovered control files RMAN> restore controlfile to '/oracle/ora10gr4/dbs/nis.ctl'; Starting restore at 21-AUG-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: rest [More]

-0001-11-30 Default

Lost all Control files (Want to Recover)

Hi I have a database in archive log mode and we take a rman hot backup everyday. We are not using the recovery catalog. I lost all the control files few days ago. I have a control file to trace and that was generated 20 days ago. This is our test dat [More]

2015-10-11 Default

Backing up the RMAN catalog database

Version: We have created a database to host our RMAN catalog. This catalog holds backup info plus RMAN stored scripts for 5 production databases . Now, we need to backup this RMAN catalog database. I am going to use the control file as the [More]

-0001-11-30 Default

RMAN & Control file ...

Hi, Is any reason to use the control file of a production database as repository for RMAN ? If the disks where the control files are located will be broken RMAN can't be used for a restore & recovery. Thanks for your answers, PaulAre you basically as [More]

-0001-11-30 Default

Click Ranking

  • How do I go frame to frame after a few seconds?

    Hello, I'm new here so forgive any mistakes or lack of knowledge. (Brief history: I have programmed in Pascal before, currently learning Java and Flash) So my question is i want to be able to move from frame to frame after X amount of seconds. I have

  • Problem starting logical host on eGate 5.1.0

    I'm having problem starting logical host for eGate 5.1.0 on Linux platform, and I cant see where is the problem lies. Is there anybody here that can give me some hint or guide? Below is the error message from the log. [#|2006-08-22T17:57:28.506+0800|

  • Error retrieving Certificate from Default JKS in PI 7.1 WAS JAVA

    Hi everyone. I'm trying to retrieve a Certificate from the Default JKS of a WAS Java (PI 7.1). Java code follows: +InitialContext ctx = new InitialContext(ctxProp);               + Object o = (Object) ctx.lookup("keystore"); KeyStoreManager mana

  • Built in ethernet problem

    I have a two week old MBP that I migrated all files from my previous PB G4. I use a wireless network at home and plug into a routed DSL ethernet network at work. The new MBP worked perfectly at my office (as did my PB G4 for years) until two days ago

  • EWS Attachment Name Incorrect

    We are encountering an issue with EWS 2.2 Managed API(and previous versions) and attachment names.  EWS exposes two potential fields for an attachment name.  Name, and FileName.  In our findings, Name can sometimes report the same file name we see in

  • Mail As Text Pad

    Is there a way now to write personally important notes and save them without giving much though to the work flow of the Save process? Without numerous clicks to re-familiarize the 'new' user-interface styles and gimmicks? Without required looks and s

  • How to send ideas to Apple ?

    hi    I wanna send one of my ideas to apple and it's about the iOS 8 cause iOS 7 was missing something some sort of little things that can make it better.Hope they will see this.. I found a way to stop the counterfeiting of Operating Systems. Good lu


    how to effectively join two queries. lets say I have select * from employees , how do i join select * from departments with union . ThanksIts not clear from your post that what exactly you want. If you want all data from both table, then use outer jo

  • How can I duplicate my current iCloud Numbers Spreadsheet while keeping the current one?

    Hello, I spent quite sometime transforming one of the standard spreadsheets to meet my personal needs and I wouldn't like it to much if I have to do it again. So my point is, it there a way I can duplicate it without recreating it while saving my cur

  • IPhone 4 or iPhone 5 ?

    I am planning to buy an iPhone 4 from India. Can you suggest me if I should wait for iPhone 5 or purchase one now..?Nobody knows what the iphone 5 will be like, but for the iphone 4 there will be an upgrade so you get the same software, iOS 5.Read ot