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
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the different types of indexes available in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is transparent data encryption? : sql server DBA
How to start SQL Server in minimal configuration mode?
Why does Oracle not permit the use of PCTUSED with indexes?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you record information about current session?
What happens on checkpoint? : sql server DBA
. 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?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is the diffrence between core dba and apps dba?
What authentication modes does sql server support? : sql server DBA