What command would you use to create a backup control file?
- 1 Answers
- 8217 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
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
How do you create a credit note against an invoice? : oracle accounts receivable
What is an Oracle database Full Backup?
HOW TO SPOT AHIERARCHY?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
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.
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain the payment term in ar. : oracle accounts receivable
What do you mean by Oracle MEDIA RECOVERY?
Explain prerequisites and post activities of oracle database installation
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
