|
|
|
|
| Re: New to RMAN, looking for tutorials [message #456182 is a reply to message #456180] |
Sat, 15 May 2010 12:19   |
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 #456184 is a reply to message #456183] |
Sat, 15 May 2010 12:34 |
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 #456769 is a reply to message #456188] |
Wed, 19 May 2010 08:08 |
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 #565231 is a reply to message #564573] |
Fri, 31 August 2012 18:14 |
 |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
