Interested to Buy Any Domain ? << Click Here >> for more details...
What command would you use to create a backup control file?
- 1 Answers
- 8761 Views
- I also Faced
- E-Mail Answers
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
Explain how to close periods in ar. : oracle accounts receivable
What is an Oracle database Partial Backup?
How would you go about increasing the buffer cache hit ratio?
What is the difference between conversions and interfaces? : oracle accounts receivable
what is semphore explian it?
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.
what is difference between inner join & nested query or subqueries
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is mrc and what is its use? : oracle accounts receivable
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What view would you use to determine free space in a tablespace?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
default triggers available for reports
