OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » rman error (oracle 10g )

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

rman error [message #501616]

Wed, 30 March 2011 02:48

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

hi,
i have created database with below commands after that i connect rman to take backup but it show me 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-06553: PLS-213: package STANDARD not accessible
RMAN-04015: error setting target database character set to WE8MSWIN1252

create database primary
user sys identified by primary
user system identified by primary
logfile group 1('D:\Oracle\oradata\primary\redo01.log')size 10m,
group 2('D:\Oracle\oradata\primary\redo02.log')size 10m
character set US7ASCII
national character set AL16UTF16
datafile 'D:\Oracle\oradata\primary\system01.dbf'size 20m
sysaux datafile 'D:\Oracle\oradata\primary\sysaux01.dbf' size 20m
default temporary tablespace temp
tempfile 'D:\Oracle\oradata\primary\temp01.dbf'size 10m
undo tablespace UNDOTBS1
datafile 'D:\Oracle\oradata\primary\undotbs1.dbf'size 10m
/

Report message to a moderator

Re: rman error [message #501617 is a reply to message #501616]

Wed, 30 March 2011 03:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why do you execute a CREATE DATABASE with RMAN? The appropriate tool is SQL*Plus.

By the way 20M is far far far far too small to create a database.

Regards
Michel

Report message to a moderator

Re: rman error [message #501729 is a reply to message #501616]

Wed, 30 March 2011 23:36

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

thanks for reply, i have actually create database using sql plus for testing purpose, which was created successfully but when i try to connect with rman it will show me error.

ORA-06553: PLS-213: package STANDARD not accessible
RMAN-04015: error setting target database character set to WE8MSWIN1252

Report message to a moderator

Re: rman error [message #501730 is a reply to message #501729]

Wed, 30 March 2011 23:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>which was created successfully
post SQL & results that provides proof above is correct

Report message to a moderator

Re: rman error [message #501744 is a reply to message #501730]

Thu, 31 March 2011 00:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

i have actually create database using sql plus for testing purpose, which was created successfully

What exactly did you do to create this database?
Post extract of alert.log showing this creation.

Regards
Michel

Report message to a moderator

Re: rman error [message #501766 is a reply to message #501744]

Thu, 31 March 2011 05:41

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

dear michel,
thanks for your response, actually the problem was due to low size 20mn creation of system and sysaux file, when i create database again with 400mb the problem resolve.
thanks again for your cooperation

Report message to a moderator

Re: rman error [message #501769 is a reply to message #501766]

Thu, 31 March 2011 06:20

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Always post your Oracle version with 4 digits.

Copy and paste your sql session using sql * plus.

If the Installation successful?,Did you run the rest of the scripts like Catalog.sql catproc.sql AS User SYS ?(As RMAN will send some RPC(Remote Procedure Calls To the Target DB)
Check the invalid objects In your DB.

Execute the following

SELECT owner FROM DBA_OBJECTS WHERE OBJECT_NAME = 'STANDARD';

Come back with results for all the above.

Good luck
Sriram

Report message to a moderator

Re: rman error [message #501779 is a reply to message #501769]

Thu, 31 March 2011 07:38

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OP solved his problem just by giving a correct size for SYSTEM tablespace, so question is closed.

Regards
Michel

Report message to a moderator

Previous Topic:	Restore from newer control file and archived redo log files
Next Topic:	error while restoring database using rman

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:20:28 CST 2024