OraFAQ Forum: Backup & Recovery » Restoring Oracle database with RMAN and have some problem

Home » RDBMS Server » Backup & Recovery » Restoring Oracle database with RMAN and have some problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restoring Oracle database with RMAN and have some problem [message #180345]

Mon, 03 July 2006 03:07

VBScript
Messages: 3
Registered: July 2006
Location: Russia, Moscow

Junior Member

This is content of log file with error :

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 3 14:38:34 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-01017: invalid username/password; logon denied

And this rman's recovery script :

connect target sys/*****@orcl;
connect catalog sys/****@orcl;
run {

allocate channel t1 type 'SBT_TAPE';
allocate channel t2 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_SERVER=stend-lns-srv.stend.corp,
NSR_CLIENT=123.stend.corp)';
restore database;
release channel t1;
release channel t2;

Report message to a moderator

Re: Restoring Oracle database with RMAN and have some problem [message #180346 is a reply to message #180345]

Mon, 03 July 2006 03:09

VBScript
Messages: 3
Registered: July 2006
Location: Russia, Moscow

Junior Member

Please help me Anybody to understan my's mistake Embarassed

Report message to a moderator

Re: Restoring Oracle database with RMAN and have some problem [message #180360 is a reply to message #180345]

Mon, 03 July 2006 04:35

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> ORA-01017: invalid username/password; logon denied
Clearly explained.

Quote:

connect target sys/*****@orcl;
connect catalog sys/****@orcl;

And, your target database( the one you are backing) and catalog database the same?

[Updated on: Mon, 03 July 2006 08:12]

Report message to a moderator

Re: Restoring Oracle database with RMAN and have some problem [message #180555 is a reply to message #180360]

Tue, 04 July 2006 03:26

VBScript
Messages: 3
Registered: July 2006
Location: Russia, Moscow

Junior Member

Yes

Report message to a moderator

Re: Restoring Oracle database with RMAN and have some problem [message #180560 is a reply to message #180555]

Tue, 04 July 2006 03:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Then how can you restore?
You have database DB1
You take backups of DB1 and save those information in RMANDB ( a seperate database used for RMAN).
Whe you want to restore DB1,
Just mount instance of DB1, connect to RMANDB , do restore.

If your catalog is inside DB1, you have already lost it.
Start reading documentation
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/toc.htm

Report message to a moderator

Re: Restoring Oracle database with RMAN and have some problem [message #180656 is a reply to message #180560]

Tue, 04 July 2006 10:30

imtj
Messages: 12
Registered: July 2006
Location: Chinese

Junior Member

You problem is catalog database same backup database.
You can use fllow step recover database.
(1)
connect target sys/*****@orcl;
recover databse
alter database open resetlogs

Report message to a moderator

Previous Topic:	Oracle Secure Backup Installation for RMAN on Solaris 9
Next Topic:	RMAN Duplication failing with RMAN-06136

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:37:33 CDT 2024