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
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain prerequisites and post activities of oracle database installation
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Explain about party and customer in ar : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
can u give guidance abt packages of plsql
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
key flexfield structure
HOW TO SPOT AHIERARCHY?
how to write customizations in po
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable