Home » RDBMS Server » Backup & Recovery » Help using RMAN to do a simple backup (windows xp 64)
Help using RMAN to do a simple backup [message #438871] Tue, 12 January 2010 15:41 Go to next message
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
Re: Help using RMAN to do a simple backup [message #438872 is a reply to message #438871] Tue, 12 January 2010 15:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Help using RMAN to do a simple backup [message #438875 is a reply to message #438871] Tue, 12 January 2010 16:16 Go to previous messageGo to next message
martijn
Messages: 283
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.
Re: Help using RMAN to do a simple backup [message #438876 is a reply to message #438871] Tue, 12 January 2010 16:57 Go to previous messageGo to next message
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
Re: Help using RMAN to do a simple backup [message #438877 is a reply to message #438876] Tue, 12 January 2010 17:07 Go to previous messageGo to next message
BlackSwan
Messages: 25039
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
Re: Help using RMAN to do a simple backup [message #438878 is a reply to message #438871] Tue, 12 January 2010 17:15 Go to previous messageGo to next message
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>
Re: Help using RMAN to do a simple backup [message #438879 is a reply to message #438878] Tue, 12 January 2010 17:21 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>ORA-01031: insufficient privileges
You need to use a USER with sufficient privileges.
Re: Help using RMAN to do a simple backup [message #438880 is a reply to message #438871] Tue, 12 January 2010 18:56 Go to previous messageGo to next message
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
Re: Help using RMAN to do a simple backup [message #438881 is a reply to message #438880] Tue, 12 January 2010 19:09 Go to previous messageGo to next message
BlackSwan
Messages: 25039
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
Re: Help using RMAN to do a simple backup [message #438883 is a reply to message #438871] Tue, 12 January 2010 19:23 Go to previous messageGo to next message
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
Re: Help using RMAN to do a simple backup [message #438884 is a reply to message #438883] Tue, 12 January 2010 19:36 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Please take the time to Read The Fine Manuals found at
http://tahiti.oracle.com

Feel free to run your own tests to learn what happens.
Re: Help using RMAN to do a simple backup [message #438932 is a reply to message #438883] Wed, 13 January 2010 01:40 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I still want to use RMAN for full backup I think.

Yes you need it as exp is NOT a database backup.

Regards
Michel
Previous Topic: How to see which database is currently taken backup in RMAN prompt
Next Topic: alter database enable block change tracking
Goto Forum:
  


Current Time: Mon Dec 05 18:56:49 CST 2016

Total time taken to generate the page: 0.11110 seconds