Home » RDBMS Server » Backup & Recovery » New to RMAN, looking for tutorials
New to RMAN, looking for tutorials [message #456179] Sat, 15 May 2010 11:45 Go to next message
MrMike
Messages: 5
Registered: May 2010
Junior Member
I'm just starting off with RMAN, if anyone knows of some good tutorials for that, I'd be grateful.
Re: New to RMAN, looking for tutorials [message #456180 is a reply to message #456179] Sat, 15 May 2010 11:49 Go to previous messageGo to next message
BlackSwan
Messages: 22897
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=Oracle+RMAN+tutorial

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
including the use of GOOGLE & SEARCH before posting
Re: New to RMAN, looking for tutorials [message #456182 is a reply to message #456180] Sat, 15 May 2010 12:19 Go to previous messageGo to next message
MrMike
Messages: 5
Registered: May 2010
Junior Member
BlackSwan wrote on Sat, 15 May 2010 11:49

It would be helpful if you followed Posting Guidelines


Thanks, I did look through quite a few of the Google listings before I posted; what I was asking for were tutorials that someone here would personally recommend, i.e. the "best of the best". My apologies if I didn't make that clear.

Re: New to RMAN, looking for tutorials [message #456183 is a reply to message #456182] Sat, 15 May 2010 12:24 Go to previous messageGo to next message
BlackSwan
Messages: 22897
Registered: January 2009
Senior Member
http://www.orafaq.com/wiki/Recovery_Manager

some/many/most folks answering here have little use for tutorials RMAN or otherwise

When all else fails, Read The Fine Manuals

http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC
Re: New to RMAN, looking for tutorials [message #456184 is a reply to message #456183] Sat, 15 May 2010 12:34 Go to previous messageGo to next message
MrMike
Messages: 5
Registered: May 2010
Junior Member
Thanks, I'll have a look at the wiki. I did look at the official Oracle docs, but they're definitely suited to a higher level of familiarity than I've got. I was looking for something geared more towards the RMAN beginner.
Re: New to RMAN, looking for tutorials [message #456185 is a reply to message #456184] Sat, 15 May 2010 12:48 Go to previous messageGo to next message
ramoradba
Messages: 2453
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Documents Are the best resource for anyone.
But as you asked...
http://www.front-row-seat.com/html/rman_for_beginners.html
http://lmgtfy.com/?q=rman+begenner

http://psoug.org/reference/rman_demos.html
http://psoug.org/reference/rman.html

sriram Smile

Re: New to RMAN, looking for tutorials [message #456186 is a reply to message #456184] Sat, 15 May 2010 13:11 Go to previous messageGo to next message
BlackSwan
Messages: 22897
Registered: January 2009
Senior Member
MrMike wrote on Sat, 15 May 2010 10:34
Thanks, I'll have a look at the wiki.


If you find the wiki lacking, you are encouraged to enhance to be more to your liking.
Re: New to RMAN, looking for tutorials [message #456188 is a reply to message #456185] Sat, 15 May 2010 15:17 Go to previous messageGo to next message
MrMike
Messages: 5
Registered: May 2010
Junior Member
Thank you! It looks like there's more than enough for me to chew on for a while.

ramoradba wrote on Sat, 15 May 2010 12:48
Documents Are the best resource for anyone.
sriram Smile


Re: New to RMAN, looking for tutorials [message #456769 is a reply to message #456188] Wed, 19 May 2010 08:08 Go to previous messageGo to next message
MrMike
Messages: 5
Registered: May 2010
Junior Member
A followup: I found the "rman_for_beginners.html" tutorial at front-row-seat.com to be very good. Everything was laid out step-by-step; very straightforward and easy to follow. Good diagrams in the "rman restore" section.

The pages on psoug were a bit heavy for me. I did find their oracle error listing helpful: psoug.org/oraerror

The orafaq.com/wiki/Recovery_Manager page was also helpful. More examples would be a good thing to have on the page but I imagine most people here (unlike me) are experienced enough not to need them.

In any case, thank you for the recommendations on tutorials.
Re: New to RMAN, looking for tutorials [message #456793 is a reply to message #456769] Wed, 19 May 2010 08:53 Go to previous messageGo to next message
ramoradba
Messages: 2453
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You Are welcome
sriram Smile
Re: New to RMAN, looking for tutorials [message #564565 is a reply to message #456793] Sat, 25 August 2012 15:28 Go to previous messageGo to next message
gaurav2k7sharma
Messages: 1
Registered: August 2012
Location: india
Junior Member
I am a beginner so want to online self pactice to the Rman if you know any online Database give the working facility so please help to me
Re: New to RMAN, looking for tutorials [message #564573 is a reply to message #564565] Sun, 26 August 2012 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59399
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you just download and install XE?
All (current) Oracle products can be donwloaded at OTN Software Downloads page.

Regards
Michel
Re: New to RMAN, looking for tutorials [message #565231 is a reply to message #564573] Fri, 31 August 2012 18:14 Go to previous message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
Here are some commands you can try on a scratch database to get you going. Don't try anything in production until you really know what you are doing.
devmon01(oracle)/export/home/oracle>rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Aug 31 16:10:24 2012

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

connected to target database: CSWEBD (DBID=4178448068)

RMAN> list copy of datafile 1;

using target database control file instead of recovery catalog

RMAN> list backup of datafile 1 summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
16965   B  F  A DISK        2012-08-26, 15:42:43 1       1       YES        TAG20120826T154209
16974   B  F  A DISK        2012-08-27, 15:42:41 1       1       YES        TAG20120827T154207
16983   B  F  A DISK        2012-08-28, 15:42:45 1       1       YES        TAG20120828T154211
16993   B  F  A DISK        2012-08-29, 15:42:41 1       1       YES        TAG20120829T154207
17003   B  F  A DISK        2012-08-30, 15:42:43 1       1       YES        TAG20120830T154209
17013   B  F  A DISK        2012-08-31, 15:42:41 1       1       YES        TAG20120831T154207

RMAN> exit;


Recovery Manager complete.

Some commands you can try are the following.
rman target /
show all;
backup archivelog all;
backup database;
LIST BACKUP;
LIST BACKUP OF DATABASE;
LIST BACKUP SUMMARY;
LIST INCARNATION;
LIST BACKUP BY FILE;
LIST COPY OF DATABASE ARCHIVELOG ALL;
LIST COPY OF DATAFILE 1, 2, 3;
LIST BACKUP OF DATAFILE 1 SUMMARY;
LIST BACKUPSET OF DATAFILE 1;
LIST BACKUP OF ARCHIVELOG all;
LIST EXPIRED BACKUP;
report obsolete;
delete obsolete;
BACKUP DATABASE PLUS ARCHIVELOG;
DELETE FORCE NOPROMPT OBSOLETE;
backup archivelog all delete input;
BACKUP AS COMPRESSED BACKUPSET DATABASE plus archivelog;
exit;
Previous Topic: Problem in manual DB Recovery.
Next Topic: how to judge the backup set is available(using RMAN)?
Goto Forum:
  


Current Time: Mon Oct 20 04:05:06 CDT 2014

Total time taken to generate the page: 0.12954 seconds