This content has been marked as final.
Show 23 replies
-
1. Re: RMAN again?
Girish Sharma Feb 26, 2013 7:10 AM (in response to yxes2013)many more :1 person found this helpful
http://docs.oracle.com/cd/B14117_01/server.101/b10770/rcmsynta.htm -
2. Re: RMAN again?
Niket Kumar Feb 26, 2013 7:11 AM (in response to yxes2013)check rman policies1 person found this helpful
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. -
3. Re: RMAN again?
Vedant.. Feb 26, 2013 7:12 AM (in response to yxes2013)Please refer foll. link1 person found this helpful
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta040.htm -
4. Re: RMAN again?
asahide Feb 26, 2013 7:19 AM (in response to yxes2013)Hi,1 person found this helpful
Check archive log mode :)
Regards, -
5. Re: RMAN again?
Sunny kichloo Feb 26, 2013 7:22 AM (in response to yxes2013)Also this will help1 person found this helpful
http://www.rmanbackup.com/ -
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 -
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? -
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; -
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 -
10. Re: RMAN again?
DB_Janitor Feb 26, 2013 9:32 AM (in response to yxes2013)yxes2013 wrote:
It depends... but don't take my word for it: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?
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? -
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) -
12. Re: RMAN again?
864103 Feb 26, 2013 9:43 AM (in response to yxes2013)yes you can
just add in your rman configuration
the above command will take backed up on your spfile and controlfile when you do any backed up ,configure controlfile autobackup on ;
also any phisical change add datafile , remove datafile ,...,etc with this configuration will take backed up also
to your controlfile. -
-
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...