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 |
Difference between negative and positive adjustments : oracle accounts receivable
How many segment are present in Oracle Manufacturing
Name two files used for network connection to a database.
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.
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the use of lockboxes? : oracle accounts receivable
what is the difference between oracle 81,91,11i
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
You have just compiled a PL/SQL package but got errors, how would you view the errors?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
How would you determine who has added a row to a table?