| RMAN CLONE using nocatalog [message #346995] |
Wed, 10 September 2008 06:37  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello All,
I'm trying to implement a clone database using RMAN . when I'm trying to give
$rman target sys@<source database> nocatalog
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 10 17:27:14 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
target database Password:
It's asking for a password . What should be the password. I did give change_on_install and also the one which I gave while creating a password file , but its giving me an error.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
Can you please guide me .
Regards,
Raj
|
|
|
|
|
|
| Re: RMAN CLONE using nocatalog [message #347020 is a reply to message #347006] |
Wed, 10 September 2008 07:51  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello Mahesh,
If I'm giving
[rsreddy@dba18 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 10 18:36:17 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: RAJA (DBID=2134427516)
RMAN>
It works , but how do I give auxiliary instance with this one
I gave
$ rman target auxiliary /
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "auxiliary": expecting one of: "double-quoted-string, equal, identifier, single-quoted-string"
RMAN-01007: at line 2 column 1 file: command line arguments
But it's giving me an error,
Can you help me out .
Regards,
Raj
|
|
|
|
|
|
| Re: RMAN CLONE using nocatalog [message #347089 is a reply to message #347024] |
Wed, 10 September 2008 11:06 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi Mahesh,
I did read that documentation , but they have given using the concept of a Catalog DB .
I want to clone a DB using RMAN and that too with NOCATALOG .
Can you please help me out with that .
Regards,
Raj
|
|
|
|
|
|
| Re: RMAN CLONE using nocatalog [message #347092 is a reply to message #347091] |
Wed, 10 September 2008 11:21 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Mahesh,
Just one simple answer , I hope this does not confuse you
1. If i get connect and take the backup of the local target DB with no catalog using RMAN , I use
$rman target /
This works .
2 . If I want to duplicate my target DB with RMAN using NOCATALOG what would I be giving .
This is the only answer I'm expecting Mahesh . Please help me out .
Regards,
Raj
|
|
|
|
| Re: RMAN CLONE using nocatalog [message #347094 is a reply to message #347092] |
Wed, 10 September 2008 11:45 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> Just one simple answer , I hope this does not confuse you
No I am not confused, but spoonfeeding will effect your learning curve. Everything is already in docs.
That is why i asked you to refer docs.
You need to understand basics before proceeding to anything with backups.
This code
will work based on ORACLE_SID defined.
Whatever instance is defined in ORACLE_SID will be backed up.
ORACLE_SID will always point to one unique instance.
If you want to connect to other instance, use tns entries.
All these are said in my first response
and
also from the piece of documentation that i have requested to look into.
quoting docs
| Quote: | *
Task 1: Create an Oracle Password File for the Auxiliary Instance
*
Task 2: Establish Oracle Net Connectivity to the Auxiliary Instance
*
Task 3: Create an Initialization Parameter File for the Auxiliary Instance
*
Task 4: Start the Auxiliary Instance
*
Task 5: Mount or Open the Target Database
*
Task 6: Make Sure You Have the Necessary Backups and Archived Redo Logs
*
Task 7: Allocate Auxiliary Channels if Automatic Channels Are Not Configured
|
Had you actually read the said link, you might have come across
ask 7: Allocate Auxiliary Channels if Automatic Channels Are Not Configured
| Quote: |
Start RMAN with a connection to the target database, the auxiliary instance, and, if applicable, the recovery catalog database. You can start the RMAN client on any host so long as it can connect to all the instances. If the auxiliary instance requires a client-side initialization parameter file, then this file must exist on the same host that runs the RMAN client.
In this example, a connection is established to three instances, all through the use of net service names:
% rman TARGET SYS/oracle@trgt CATALOG rman/cat@catdb AUXILIARY SYS/oracle@aux
|
[/QUOTE]
Where trgt is your target (source database) and aux is your auxillary database.
As said before, only difference is you are not using catalog.
so
You need to use
rman TARGET SYS/oracle@trgt nocatalog |
|
|
|
|
|
| Re: RMAN CLONE using nocatalog [message #347390 is a reply to message #347094] |
Thu, 11 September 2008 08:04 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello Mahesh,
I did try to do an RMAN clone of my target DB, but this time using a Catalog DB . The steps what I did was
1. took an RMAN backup using a catalog DB by giving
$rman catalog rman/rman target sys/sys@totgt
[b]RMAN>backup database include current controlfile plus archivelog;[/b]
It worked and after that I did send all my RMAN backup pieces to my auxiliary instance and also created a same directory structure and next I gave
2 . [b]$rman catalog rman/rman target sys/sys@totgt auxiliary sys/sys@toaux
[/b]
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 12 00:16:51 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PWC (DBID=459113913)
connected to recovery catalog database
connected to auxiliary database: PWC (not mounted)
RMAN>
And gave
RMAN>configure auxiliary channel 2 device type disk format '/disk1/oradata/pwc/rman/%U.dbf';
RMAN> duplicate target database for clone dorecover;
Then it showed me an error stating that :
[b]Starting Duplicate Db at 12-SEP-08
configuration for DISK channel 2 is ignored
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=46 devtype=DISK
contents of Memory Script:
{
set until scn 215438;
restore clone controlfile;
sql clone 'alter database mount clone database';
}
executing Memory Script
executing command: SET until clause
Starting restore at 12-SEP-08
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /disk1/oradata/pwc/rman/c-459113913-20080911-04
ORA-19870: error reading backup piece /disk1/oradata/pwc/rman/c-459113913-20080911-04
ORA-19505: failed to identify file "/disk1/oradata/pwc/rman/c-459113913-20080911-04"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /disk1/oradata/pwc/rman/0ejqbesv_1_1.dbf
ORA-19870: error reading backup piece /disk1/oradata/pwc/rman/0ejqbesv_1_1.dbf
ORA-19505: failed to identify file "/disk1/oradata/pwc/rman/0ejqbesv_1_1.dbf"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/12/2008 00:22:04
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
[/b]
Can you help me in rectifying my mistake . All the backups which are present in target location are also present in Auxiliary location also.
Regards,
Raj
Edit: applied code tags
[Updated on: Thu, 11 September 2008 09:43] by Moderator Report message to a moderator |
|
|
|
| Re: RMAN CLONE using nocatalog [message #347409 is a reply to message #347390] |
Thu, 11 September 2008 09:42 |
|
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>I did send all my RMAN backup pieces to my auxiliary instance
What do you mean by that?
Is the AUX instance residing in another server?
I assume you have all filesystem perms all set. Did you also copy archives?
The aux instance does not need to be with the same directory structure.
Where are you executing these scrips from?
Typically "dorecover" option is used only in standby databases (still it is not relevant to error you get).
I would configure controlfile autobackup (search this forum/google/docs on how to) and try again along with TSPITR duplication.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb006.htm#sthref1308
And format your code.use CODE AND /CODE tags
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
