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 generate profile of pl/sql applications to identify performance bottlenecks?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the default fill factor value? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what is a crs resource?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
what are the performance views in an oracle rac environment?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Where would you look for errors from the database engine?