Question
How does one create a rman recovery catalog?
Answers
Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: 

sqlplus sysSQL>create user rman identified by rman;SQL> alter user rman default tablespace tools temporary tablespace temp;SQL> alter user rman quota unlimited on tools;SQL> grant connect, resource, recovery_catalog_owner to rman;SQL> exit;
Next, log in to rman and create the catalog schema. Prior to Oracle 8i this was done by running the catrman.sql script. rman catalog rman/rman

RMAN>create catalog tablespace tools;RMAN> exit;
You can now continue by registering your databases in the catalog. Look at this example: 
rman catalog rman/rman target backdba/backdba

RMAN> register database;   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What is tidal volume
  • Q What was the most satisfying moment throughout your student teaching?
  • Q In IMPS, “I” stands for
  • Q Who was recommended a proper scheme of education from the primary school to the University for the Whole of British India?
  • Q If u save an object as local object then how do u transport it?.
  • Q What are the two options for entering plan data?
  • Q What is macula
  • Q State the difference between testing and dry running
  • Q Explain what is sas informats?
  • Q Who was the PM of India for two short periods following the deaths of Jawaharlal Nehru in 1964 and Lal Bahadur Shastri in 1966?
  • Q What is represented by the connection object