Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What command would you use to create a backup control file?

Answer Posted / robertson

HOW TO CREATE BACKUP CONTROL FILE;
In the primary server
sql>alter database backup controlfile to trace;

It gets created in the user_dump_dest path.
sql>show parameter user_dump_dest

HOW TO CREATE STANDBY CONTROL FILE;
In the primary server
sql>alter database backup controlfile
to '/uo1/app/bkpctrl.ctl';

Then ftp the file to the standby controlfile.

Rename the standby controlfile witht the primary file.

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2140


can we use lexical perameter in oracle plsql if yes how

2264


which one is currently in used software cmpanies.

2103


What is the use of lockboxes? : oracle accounts receivable

1156


8. Supporting AP, AR and GL?

2263


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4389


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2058


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1006


default triggers available for reports

2156


Explain about party and customer in ar : oracle accounts receivable

1143


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2160


What is auto invoicing? Explain : oracle accounts receivable

1055


Could you please let me know the interfaces in OM / FA??

2186


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7566


What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2099