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 |
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
Where in the Oracle directory tree structure are audit traces placed?
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
what is the difference between off-line back up and on-line back up in ibm db2 udb?
How can you rebuild an index?
How would you determine the time zone under which a database was operating?
what are the types of connection load-balancing?
How can we know the exact updation date of a particular database?
How would you force a log switch?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
WHEN DOWN TIME WHAT CAN U DO?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
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)