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
What is the difference between clustered and non-clustered index? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you communicate with operating system files from oracle?
What is a system database and what is a user database? : sql server DBA
Can you redefine a table online?
What are the different sql server versions you have worked on? : 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 use of recording information about current session?
Why would you call update statistics? : sql server DBA
what are the types of connection load-balancing?
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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What authentication modes does sql server support? : sql server DBA
