Should you place Recovery Catalog in the Same DB?
. Can you use RMAN without Recovery catalog
Answers were Sorted based on User's Feedback
Answer / mudit
No ,Recovery catalog should be place in separated database
for security reason as recommended by oracle.
we can use RMAN without RC,by using Target Database control
file.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / guest
Recovery catalog not in same target db
Can take backup without catalog
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / gangaram
Should you place Recovery Catalog in the Same DB?
Recovery catalog can be in the same database. but its
recommended by oracle that we need to have recovery catalog
in other DB.
Can you use RMAN without Recovery catalog
Yes we can use RMAN without catalog.
The information gets stored in the control file.
$>connect target / no catalog
is the command.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rajesh naidu
WE CAN TAKE THE RMAN BACKUP IN THE PRIMARY DATABASE WITHOUT
CATALOG
BY CONNECTING LIKE RMAN NO CATALOG/
| Is This Answer Correct ? | 3 Yes | 1 No |
Describe what redo logs are.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Can you redefine a table online?
Give the reasoning behind using an index.
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
If we issue alter database begin backup. What happens to database?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How do you switch from an init.ora file to a spfile?
Explain how you would restore a database using RMAN to Point in Time?
WHEN DOWN TIME WHAT CAN U DO?
How do you resize a data file?
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)