OraFAQ Forum: Backup & Recovery » Help using RMAN to do a simple backup

Home » RDBMS Server » Backup & Recovery » Help using RMAN to do a simple backup (windows xp 64)

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

Help using RMAN to do a simple backup [message #438871]

Tue, 12 January 2010 15:41

nohacks
Messages: 10
Registered: July 2008

Junior Member

Hi All,

I need help with RMAN. I need to do a real simple backup to a disk file not another database.

I have been reading

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmcomma001.htm

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm

cant seem to figure this out.

Can anyone help me with a simple backup??

Thanks
Phil

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438872 is a reply to message #438871]

Tue, 12 January 2010 15:48

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

Senior Member
Account Moderator

I would rather start here
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
and proceed to
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

RMAN is just a tool.
You connect to target database.
You can backup database using the controlfile of target database (to store backup info) called as nocatalog mode or use a separate catalog (another small oracle database) called as catalog mode.
You can do a full backup, incremental etc.
Within RMAN (prompt) you do these.
configure your channels.
configure your disks (path with backupsets will be written to).
Few more options.

The quick start guide
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14193/toc.htm
and 2 day dba guide will also be handy.

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438875 is a reply to message #438871]

Tue, 12 January 2010 16:16

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

Show us what you have tried sofar, and what you don't understand, then we can maybe see wat the problem is.
O...and while your at it...also show us OS and RDBMS version etc.

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438876 is a reply to message #438871]

Tue, 12 January 2010 16:57

nohacks
Messages: 10
Registered: July 2008

Junior Member

Hi Guys,

Thanks for the quick reply.

This is what I am getting.

at the command prompt in dos I type:

c:\Documents and settings\phil>rman target user/password@sid

I get RMAN-04005 error from target database:

I just want to dump the whole datatbase into a backup file.

Thanks
Phil

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438877 is a reply to message #438876]

Tue, 12 January 2010 17:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

4005, 1, "error from target database: \n%s"
// *Cause:  Oracle error signaled by target database.
//          This message should be accompanied by other error message(s)
//          indicating the cause of the error.
// *Action: Check the accompanying errors.

Since you are not charged by the character to post here, please use CUT & PASTE of the whole session, so we can see what you do & how Oracle responds.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438878 is a reply to message #438871]

Tue, 12 January 2010 17:15

nohacks
Messages: 10
Registered: July 2008

Junior Member

Post results of
SELECT * from v$version

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 64-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

C:\Documents and Settings\phil>rman target userHere/password@sid

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jan 12 18:09:58 2010

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-04005: error from target database:
ORA-01031: insufficient privileges

C:\Documents and Settings\phil>

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438879 is a reply to message #438878]

Tue, 12 January 2010 17:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-01031: insufficient privileges
You need to use a USER with sufficient privileges.

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438880 is a reply to message #438871]

Tue, 12 January 2010 18:56

nohacks
Messages: 10
Registered: July 2008

Junior Member

Ok..thanks..now I can connect to rman

C:\Documents and Settings\phil>rman target user/password@sid

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jan 12 18:56:43 2010

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

connected to target database: ORCL (DBID=1190815447)

RMAN>

how do I do a backup??

Say I just want to backup schema bank.

How do I backup bank compared to backup the whole oracle tables?

Thanks in advance

Phil

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438881 is a reply to message #438880]

Tue, 12 January 2010 19:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When all else fails, Read The Fine Manual

http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC

RMAN is not design to backup a single schema

exp username/password file=bank.dmp owner=bank log=exp_bank.log

above would be a better solution, In My Opinion

Report message to a moderator

Re: Help using RMAN to do a simple backup [message #438883 is a reply to message #438871]

Tue, 12 January 2010 19:23

nohacks
Messages: 10
Registered: July 2008

Junior Member

cool thanks.

I used exp seemed to work fine.

Does EXP do the indexes and all other needed things for restore?

What to you get with RMAN ??

I still want to use RMAN for full backup I think.

Thanks
Phil

Report message to a moderator