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 to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
what are the tools used for oracle 10g in real time.
Could you please let me know the interfaces in OM / FA??
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Give two methods you could use to determine what DDL changes have been made.
difference of using cursor for loop and open,fetch,close.which one is better
How would you go about increasing the buffer cache hit ratio?
What are different types of transactions in ar? : oracle accounts receivable
what is sql*loader parameters and where we will use it.
types of receipts and detail desription about recipts and tables effected by receipts?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also