What are three purposes of the RMAN “FROM” clause?
A.
to support PUSH-based active database duplication
B.
to support synchronization of a standby database with the primary database in a Data
environment
C.
To support PULL-based active database duplication
D.
To support file restores over the network in a Data Guard environment
E.
To support file recovery over the network in a Data Guard environment
Explanation:
E:
* With a control file autobackup, RMAN can recover the database even if the current control file,
recovery catalog, and server parameter file are inaccessible.
* RMAN uses a recovery catalog to track filenames for all database files in a Data Guard
environment. A recovery catalog is a database schema used by RMAN to store metadata about
one or more Oracle databases. The catalog also records where the online redo logs, standby redo
logs, tempfiles, archived redo logs, backup sets, and image copies are created.
You mean “FROM SERVICE”. This is for Data Guard operations. Therefore: B, D and E.
Exactly
DUPLICATE DATABASE TO NEWDB FROM ACTIVE DATABASE
why not C?
12c RMAN Features
Table or partition point-in-time recovery in RMAN
SQL interface support
Backup, recovery enhancements for Very large data files
Restore/Recover data files over the network
Active Database Duplication additions & improvements
correct BCE
Can somebody tell me what is wrong with D?
According to this link “D” is correct.
RMAN> CONNECT TARGET “rman_user@primary_tns AS SYSBACKUP”;
RMAN> RESTORE DATAFILE 9 FROM SERVICE standby_tns;
http://www.toadworld.com/platforms/oracle/w/wiki/10565.recovery-manager-rman-enhancements-in-oracle-database-12c.aspx
D and E are both in harmony and make more sense together.
According to these links “B”, “D” and “E” are correct!!
“As of Oracle Database 12c, RMAN lets you restore or recover files by connecting, over the network, to a physical standby database that contains the required files. You can restore an entire database, data files, control files, spfile, or tablespaces. Restoring files over the network is very useful in scenarios where you need to synchronize the primary and standby databases.”
http://docs.oracle.com/database/121/SBYDB/rman.htm#SBYDB5457
https://docs.google.com/document/d/16jLzBuLu6gTBN7UpL51oXp3rKgvZWZfzyMY0rhdv4i4/edit?hl=en
http://blog.dbvisit.com/oracle-database-12c-and-three-new-rman-features/
Pay attention – in D an E it say “Data Guard environment” but in B “Data
environment” we don’t have “Data environment” in Oracle – so “smbd.smth” are right.
I agree that BDE are correct answers. “C” is not correct. There is no PULL or PUSH based duplication with this option.
A,B,C
duplicate using “from active database” does not need restore & recovery.
That is not correct, the duplicate “from active database” uses restore.
Just that I can’t add picture, I have a screenshot of that.
CDE
Push and Pull Method are valid I think that D and E Is not correct only by “from service”
so The Correct option Must be ABC
http://www.oracle.com/technetwork/es/articles/database-performance/push-based-active-db-duplication-2549979-esa.html
some consensus?
for D and E, “From Service” Clause will be used. for A and C we can use “from” for Active duplication along with “dorecover” option for Standby.
ABC.
BDE
BDE
BDE