Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you open a cluster administrator? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the importance of a recovery model? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Can you redefine a table online?
Explain materialized views and how they are used.
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
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 to start SQL Server in minimal configuration mode?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
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.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is transparent data encryption? : sql server DBA
