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 would you determine what sessions are connected and what resources they are waiting for?
Is it possible to drop a column in a table which contains only one column? How?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
pl help me, i want oracle HRMS training institute address,in chennai
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
Name three advisory statistics you can collect.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
How would you determine who has added a row to a table?
Explain prerequisites and post activities of oracle database installation
what is semphore explian it?
Are These Dff's Flexible?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable