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 |
can u give guidance abt packages of plsql
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
pl help me, i want oracle HRMS training institute address,in chennai
How would you determine the time zone under which a database was operating?
can we drop dual table
Compare and contrast TRUNCATE and DELETE for a table.
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?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
How can you enable a trace for a session?
What does coalescing a tablespace do?
Give the two types of tables involved in producing a star schema and the type of data they hold.
What is the importance of batch source set up in ar? : oracle accounts receivable