What command would you use to create a backup control file?
- 1 Answers
- 7854 Views
- I also Faced
- E-Mail Answers
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 |
When creating a user, what permissions must you grant to allow them to connect to the database?
why r u using etl tool.
what are the tools used for oracle 10g in real time.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What is chargeback invoice? How do we create it? : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What is the difference between the SQL*Loader and IMPORT utilities?
What background process refreshes materialized views?
Describe what redo logs are.
What is Restricted Mode of Instance Startup in Oracle?
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 API of GL,PO,AP
Oracle General 
