How do you find out from the RMAN catalog if a particular
archive log has been backed-up?
Answers were Sorted based on User's Feedback
Answer / narmada kumari
The database should be in ARCHIVE mode if you are going to
use RMAN as backup method.
| Is This Answer Correct ? | 16 Yes | 13 No |
What type of index should you use on a fact table?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is the difference between clustered and non-clustered index? : sql server DBA
what is a user-defined lock?
what is the difference between db2start command and start database manager command?
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.
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How do you resize a data file?
What the different components in replication and what is their use? : sql server DBA
Name a tablespace automatically created when you create a database.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)