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 |
What would you do with an "in-doubt" distributed transaction?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What the different types of replication and why are they used? : sql server DBA
Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is a system database and what is a user database? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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?
how can you create a user-defined lock?
What types of replication are supported in sql server? : sql server DBA
Explain CREATE DATABASE syntax?
Why would you call update statistics? : sql server DBA