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
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is the importance of batch source set up in ar? : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Give two methods you could use to determine what DDL changes have been made.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is Tax Categories?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
How would you go about increasing the buffer cache hit ratio?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the mandatory setup in cyclecount ?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?