deleted of control file how will u recover control file?
Answer Posted / bolla
At o/s level we are restore control.file from cold/hot backup
after
]$sqlplus /'as sysdba'
sys>startup nomount
sys>recover database using backup controlfile until cancel;
sys>alter database mount;
sys>alter database open resetlogs;
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is a system database and what is a user database? : sql server DBA
what is the use of recording information about current session?
How would you extract DDL of a table without using a GUI tool?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the different sql server versions you have worked on? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Where would you look for errors from the database engine?
what is grd?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you implement fine-grained auditing?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
who owns the operating system files created by the utl_file package?
What are statistics, under what circumstances they go out of date, how do you update them?
what is the last version,the release date of that version and fix pack of ibm db2 udb?