Answer Posted / kittu_chintu2005
Startup mount
Alter database archive log;
Alter database begin backup;
Alter tablespace ts_name begin backup;
Copy the *.dbf & *.ctl files @ os level when copying completed issue the statement “alter database end backup;”
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How can you control the amount of free space in your index pages? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What are the different ways you can create databases in sql server? : sql server DBA
What is the default fill factor value? : sql server DBA
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.
how can you create a user-defined lock?
What are the steps you will take to improve performance of a poor performing query?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Why would you call update statistics? : sql server DBA
What is a correlated sub-query? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What purpose does the model database server? : sql server DBA
what is the diffrence between core dba and apps dba?
Can you redefine a table online?
what is a crs resource?
