deleted of control file how will u recover control file?
Answers were Sorted based on User's Feedback
Answer / kittu_chintu2005
Method 1:
SQL>STARTUP NOMOUNT;
SQL>CREATE CONTROLFILE REUSE DATABASE "DB_NAME" ARCHIVELOG RESETLOGS
LOGFILE
GROUP 1 ( 'location of redo1a.log','location of redo1b.log') size XXmb,
GROUP 2 ( 'location of redo2a.log','location of redo2b.log') size xxmb
DATAFILE
'location of system.dbf',
'location of users.dbf',
'location of temp.dbf',
'location of ts1.dbf';
SQL>RECOVER DATABASE;
SQL>ALTER DATABASE OPEN RESETLOGS;
Is This Answer Correct ? | 8 Yes | 4 No |
Answer / suman
we are restore the control file from cold/hot backup
after that
$sqlplus / 'as sysdba'
>startup nomount
>recover database using backup controlfile until cancel;
>alter database mount;
>alter database open resetlogs;
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Explain the use of table functions.
What are the different sql server versions you have worked on? : sql server DBA
how can you connect from 10g user to 11g user??
Query processing is slow(eg select query)how will u solve that
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Which environment variables are absolutely critical in order to run the OUI?
How would you force a log switch?
What are the operating modes in which database mirroring runs? : sql server DBA
What command would you use to encrypt a PL/SQL application?
how can you generate profile of pl/sql applications to identify performance bottlenecks?