What command would you use to create a backup control file?
Answer / 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 |
What is database schema?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
Difference between transaction type and transaction sources. : oracle accounts receivable
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
1 Answers Pathway Technologies,
What type of index should you use on a fact table?
What view would you use to determine free space in a tablespace?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?