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 |
How many segment are present in Oracle Manufacturing
key flexfield structure
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?
hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
A scenario for amount correction & how to use amount correction functionality in AP invoices
difference of using cursor for loop and open,fetch,close.which one is better
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 are the tools used for oracle 10g in real time.
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?