Home » RDBMS Server » Backup & Recovery » rman error (oracle 10g )
rman error [message #501616] Wed, 30 March 2011 02:48 Go to next message
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
/


Re: rman error [message #501617 is a reply to message #501616] Wed, 30 March 2011 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: rman error [message #501729 is a reply to message #501616] Wed, 30 March 2011 23:36 Go to previous messageGo to next message
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
Re: rman error [message #501730 is a reply to message #501729] Wed, 30 March 2011 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>which was created successfully
post SQL & results that provides proof above is correct
Re: rman error [message #501744 is a reply to message #501730] Thu, 31 March 2011 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: rman error [message #501766 is a reply to message #501744] Thu, 31 March 2011 05:41 Go to previous messageGo to next message
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
Re: rman error [message #501769 is a reply to message #501766] Thu, 31 March 2011 06:20 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: rman error [message #501779 is a reply to message #501769] Thu, 31 March 2011 07:38 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OP solved his problem just by giving a correct size for SYSTEM tablespace, so question is closed.

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


Current Time: Thu Mar 28 12:10:33 CDT 2024