In first commad, you are connecting to Recovery catalog with user RMAN which suppose to be the catalog owner. After this you will need to provide one more statement to connect to Target database.
rman catalog rman/rman@orcl rman target scott/tiger catalog rman/rman@orcl
user12050217 wrote:To test backup and recovery, you need a connection with target database, evidently. So the second command will be more useful. Although you can issue the first command, and then use on more command within RMAN: connect target scott/tiger
I wish to test backup and recovery, so which of the above command should be used.
C:\Windows\>rman target rman/rman@orcl Recovery Manager: Release 220.127.116.11.0 - Production on Sat Apr 28 15:03:53 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1349204074) RMAN>
After this you will need to provide one more statement to connect to Target database.What do you mean please elaborate it, what statement need to be connected, when I am getting connected to target database:....
You can perform can backup only connecting with catalog .I think this is wrong. We can backup only when rman session is connected to the target database.
3.rman target rman/rman@orcl-->No user in v$session-->Backup possibleyou should check the connecion as
So, for entry in v$session, connect command should have "catalog" word.I didn't get this line . But i guess no catalog word is required .
rman target scott/tiger catalog rman/rman@orcl
Here scott user is having DBA role too. Recovery catalog owner is rman. I wish to test backup and recovery,You cannot backup the database wih a user with DBA role, you need to have SYSDBA privlage to backup the database and RMAN by default connect with the target database as a SYSDBA only.
so which of the above command should be used.It depends on where is your catalog database and your target database.
user12050217 wrote:This is going to connect you the recovery catalog database but not to the target database. So you would need to issue another statement while being connected to RMAN to make the connection to the target database. Here the user RMAN is the Catalog owner's name .
Please tell me what are difference between these two commands :
rman catalog rman/rman@orcl
rman target scott/tiger catalog rman/rman@orclYou are trying to connect to the Target database as Scott user and Catalog db as RMAN user.
Here scott user is having DBA role too. Recovery catalog owner is rman. I wish to test backup and recovery, so which of the above command should be used.The backup would be done using the Sysdba role, not with the DBA role. So you would need to issue anyways the command to connect to the target db.In the 2nd command you are making that connection and in the 1st , you would need to take one more step for it.
Kindly elaborate it.Its elaborated already in the Backup and Recovery reference guide. Please read it,