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
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.
can we use lexical perameter in oracle plsql if yes how
which one is currently in used software cmpanies.
What is the use of lockboxes? : oracle accounts receivable
8. Supporting AP, AR and GL?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
default triggers available for reports
Explain about party and customer in ar : oracle accounts receivable
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is auto invoicing? Explain : oracle accounts receivable
Could you please let me know the interfaces in OM / FA??
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
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?