Home » RDBMS Server » Backup & Recovery » RMAN CLONE using nocatalog (Oracle 10g Rel2,LINUX AS4)
RMAN CLONE using nocatalog [message #346995] Wed, 10 September 2008 06:37 Go to next message
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 #347006 is a reply to message #346995] Wed, 10 September 2008 07:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
set your ORACLE_SID and try again (if the target is your local database) or just "target /"
else
use tns string

[Updated on: Wed, 10 September 2008 07:27]

Report message to a moderator

Re: RMAN CLONE using nocatalog [message #347020 is a reply to message #347006] Wed, 10 September 2008 07:51 Go to previous messageGo to next message
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 #347024 is a reply to message #347020] Wed, 10 September 2008 07:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
How about reading some docs?
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb004.htm#i1006474
Re: RMAN CLONE using nocatalog [message #347089 is a reply to message #347024] Wed, 10 September 2008 11:06 Go to previous messageGo to next message
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 #347091 is a reply to message #347089] Wed, 10 September 2008 11:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Does not matter.
Steps are same. Just do not use a catalog.
RMAN DUPLICATE DATABASE: Options

When duplicating a database, you have the following options:

    *

      You can run the DUPLICATE command with or without a recovery catalog.

[Updated on: Wed, 10 September 2008 11:14]

Report message to a moderator

Re: RMAN CLONE using nocatalog [message #347092 is a reply to message #347091] Wed, 10 September 2008 11:21 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
$rman target /

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 #347148 is a reply to message #347094] Wed, 10 September 2008 20:59 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Thanks Mahesh,

I've read the documentation and your reply , and now it makes sense to me all about. I was little confused abt it .

Actually I was reading a link about RMAN clone from the below site and I was trying that :

http://www.shutdownabort.com/quickguides/clone_rman.php


I'll try that and let you know .

Regards,
Raj

[Updated on: Wed, 10 September 2008 21:02]

Report message to a moderator

Re: RMAN CLONE using nocatalog [message #347390 is a reply to message #347094] Thu, 11 September 2008 08:04 Go to previous messageGo to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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
Previous Topic: Increased Archivelog backup with RMAN catalog
Next Topic: incarnation
Goto Forum:
  


Current Time: Sat Dec 03 17:59:40 CST 2016

Total time taken to generate the page: 0.07351 seconds