Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 

Topic: Backup & Recovery >> Re-Configuring a Target Database

Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property. You may review the entire Oracle Certification Program Candidate Agreement online Here.



  


 Title: Re-Configuring a Target Database
 Deep  Posted: Apr 24, 2008 01:28:40 AM

 Total Post: 10
 Joined: Aug, 2006






 Hii all DBA's

I'm facing a problem with configuring a target database in the catalog, ishall explain you in steps wat i hav done

1. I have registered my target database & modified the configuration parameters as required.
Ex: CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk2/oradata/deepsdb/rman_bkp/%U.bkp';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/disk2/oradata/deeps/rman_bkp/snapcf_cvsw.f';


(My directory of database i mentioned as 'deepsdb',but actually it was 'deeps')

Now my problem is i want to reconfigure the target database and set the correct folder as 'deeps'.But i'm not able to do tht even though i tried to do Unregister database in RMAN ...it is still having the parameters of old configuration..can any one plz giv any solution to it

Thanks in advance to all DBA's..

 GOPU
Posted: Apr 24, 2008 01:34:42 AM  

 Total Post: 334
 Joined: Apr, 2008






 
Hi friend
you have to configure like this

CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk2/oradata/deeps/rman_bkp/%U.bkp';

Gopu


 Deep
Posted: Apr 24, 2008 01:43:42 AM  

 Total Post: 10
 Joined: Aug, 2006






 
Heyy thankx for immediate reply

But i have tried to do it ,it still throws an error

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk2/oradata/deeps/rman_bkp/%U.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 04/24/2008 11:10:31
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 04/24/2008 11:10:31
ORA-01580: error creating control backup file /disk2/oradata/deepsdb/rman/snapcf_deeps.f
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory


 GOPU
Posted: Apr 24, 2008 01:54:50 AM  

 Total Post: 334
 Joined: Apr, 2008






 
Hi,
It seems your snapshot controlfile configuration is mismatched, try to clear this
ORA-01580: error creating control backup file /disk2/oradata/deepsdb/rman/snapcf_deeps.f

Gopu

 ramesh
Posted: Apr 24, 2008 02:06:22 AM  

 Total Post: 40
 Joined: Aug, 2007






 
Hi Deep,

Had you Configured your snap shot control file in your configuration parameter file to new directory i.e:disk2/oradata/deepsdb/rman/snapcf_deeps.f

and again recompile the configuration parameter with all new parameters.

 GOPU
Posted: Apr 24, 2008 02:09:47 AM  

 Total Post: 334
 Joined: Apr, 2008






 
Hi friends
i have a small doubt
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk2/oradata/deeps/rman_bkp/%U.bkp';

Is it configure channel OR allocate channel ?

Regards
Gopu



 Deep
Posted: Apr 24, 2008 02:26:42 AM  

 Total Post: 10
 Joined: Aug, 2006






 
Hi G&G

it is CONFIGURE as i'm tryng to set these parameters as default by overwriting the default parameters.

Thanks a lot to all....

 GOPU
Posted: Apr 24, 2008 02:29:14 AM  

 Total Post: 334
 Joined: Apr, 2008






 
Is it working fine :)

 Deep
Posted: Apr 24, 2008 04:38:49 AM  

 Total Post: 10
 Joined: Aug, 2006






 
Thanks a lot to all

It's working fine now...i could resolve with your suggestions.

 Time Zone: EDT

  




Forum Rules & Description


Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user




 








Get FREE Magazines

Top 10 Forum User

  Murtuja Khokhar857
  Mohammed Taj746
  positive fanatic483
  Jayanta Sur479
  Vigyan Kaushik386
  Gopu Gopi334
  Gitesh Trivedi322
  Vinoth Kumar264
  neeraj sharma258
  Ramesh Jois246






oracle Mag



  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor
Confio Software