1 2 Previous Next 23 Replies Latest reply on Mar 16, 2013 2:05 AM by yxes2013

RMAN again?

yxes2013 Feb 26, 2013 7:09 AM

Hi All,

I have not used RMAN for a long time, as I am only supporting development systems for the past months and i do export/import for backups only.

I forgot my RMAN lessons already :( and I want to use it now for standby and replication testing.

Can I have a refresher please. Just the simplest default & basic commands.

1. rman target /
2. backup database;
3. crosscheck backup;
4. delete obsolete;

What else do I miss?

Thanks a lot,

zxy

Edited by: yxes2013 on 25.2.2013 23:09

1. Re: RMAN again?

Girish Sharma Feb 26, 2013 7:10 AM (in response to yxes2013)

many more :
http://docs.oracle.com/cd/B14117_01/server.101/b10770/rcmsynta.htm
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: RMAN again?

Niket Kumar Feb 26, 2013 7:11 AM (in response to yxes2013)

check rman policies

rman>show all; --- to configure rman policied (include controlfile and spfile backup.)
rman>backup archivelog all; -------- to take archivelog backup;other thins you are already using. change format for backup for backup location.
1 person found this helpful
Like Show 0 Likes(0)

Actions
3. Re: RMAN again?

Vedant.. Feb 26, 2013 7:12 AM (in response to yxes2013)

Please refer foll. link
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta040.htm
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: RMAN again?

asahide Feb 26, 2013 7:19 AM (in response to yxes2013)

Hi,

Check archive log mode :)
Regards,
1 person found this helpful
Like Show 0 Likes(0)

Actions
5. Re: RMAN again?

Sunny kichloo Feb 26, 2013 7:22 AM (in response to yxes2013)

Also this will help

http://www.rmanbackup.com/
1 person found this helpful
Like Show 0 Likes(0)

Actions
6. Re: RMAN again?

Osama_Mustafa Feb 26, 2013 7:23 AM (in response to yxes2013)

You can start by reading oracle documentation
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcncpt.htm
Like Show 0 Likes(0)

Actions
7. Re: RMAN again?

yxes2013 Feb 26, 2013 7:36 AM (in response to Osama_Mustafa)

I thank you all :)

I just want the simplest backup command that backs up everything and not the complex ones. Just to live a day and be able to pass the "connect until archive freed" error.

Is "backup database" command backs up everything + controlfile + spfile + archives?
What else do I need to backup?
Like Show 0 Likes(0)

Actions
8. Re: RMAN again?

Vedant.. Feb 26, 2013 7:43 AM (in response to yxes2013)

You can use the foll in RMAN:

crosscheck archivelog all;
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
Like Show 0 Likes(0)

Actions
9. Re: RMAN again?

yxes2013 Feb 26, 2013 8:50 AM (in response to Vedant..)

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
I dont like compression as this might corrupt the file :(. I just want a simple backup but complete.

My question is > Is the command "backup database" includes controlfile and spfile? or do I need to state it literally as backup database plus controlfile plus spfile plus archivelog plus all other files.
Are there other files missing?

Thanks
Like Show 0 Likes(0)

Actions
10. Re: RMAN again?

DB_Janitor Feb 26, 2013 9:32 AM (in response to yxes2013)

yxes2013 wrote:
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
I dont like compression as this might corrupt the file :(. I just want a simple backup but complete.

My question is > Is the command "backup database" includes controlfile and spfile? or do I need to state it literally as backup database plus controlfile plus spfile plus archivelog plus all other files.
Are there other files missing?
It depends... but don't take my word for it:

If CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and the current server parameter file (if used to start up the database) at the end of a successful BACKUP command. If the database runs in ARCHIVELOG level, RMAN makes control file autobackups when a structural change to the database affects the contents of the control file.

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#i1016424

>
Thanks
If I may ask you a question, why are you asking questions that are all answered in the documentation? Wouldn't you rather read the documentation and have a thorough understanding of the database, rather than depending on answers that may lack accuracy on an Internet forum?
Like Show 0 Likes(0)

Actions
11. Re: RMAN again?

Vedant.. Feb 26, 2013 9:39 AM (in response to yxes2013)

My question is > Is the command "backup database" includes controlfile and spfile? or do I need to state it literally as backup database plus controlfile plus spfile plus archivelog plus all other files.
Set the foll RMAN parameter:

CONFIGURE CONTROLFILE AUTOBACKUP to ON
(Refer link : http://docs.oracle.com/cd/B19306_01/rac.102/b14197/rmanops.htm)

and then use the command BACKUP DATABASE PLUS ARCHIVELOG;
(Refer link : http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#CHDBGAJB)
Like Show 0 Likes(0)

Actions
12. Re: RMAN again?

864103 Feb 26, 2013 9:43 AM (in response to yxes2013)
yes you can

just add in your rman configuration

configure controlfile autobackup on ;
the above command will take backed up on your spfile and controlfile when you do any backed up ,
also any phisical change add datafile , remove datafile ,...,etc with this configuration will take backed up also
to your controlfile.
Like Show 0 Likes(0)

Actions
13. Re: RMAN again?

yxes2013 Feb 26, 2013 9:46 AM (in response to 864103)

I thanks you all :)
Like Show 0 Likes(0)

Actions
14. Re: RMAN again?

yxes2013 Feb 26, 2013 9:53 AM (in response to DB_Janitor)

Thanks Justin ;)

If I may ask you a question, why are you asking questions that are all answered in the documentation? Wouldn't you rather read the documentation and have a thorough understanding of the database, rather than depending on answers that may lack accuracy on an Internet forum?
Hmmm...docs are quite confusing :( because there are lots of choices and options. It is very much far better here because it is self-explanatory ;)

cheers...
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post