Home » RDBMS Server » Backup & Recovery » backup all datafiles only using RMAN
backup all datafiles only using RMAN [message #582621] Sat, 20 April 2013 04:54 Go to next message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
Need the command for backup all the datafiles using RMAN.
Not any specific data file.

Also another thing, when i try to take full database backup, it creates two .bkp file. Can anyone suggest what the two files for?



input datafile file number=00004 name=/oracle/oradb/oradata/ora138/users01.dbf
channel ORA_DISK_1: starting piece 1 at 20-APR-13
channel ORA_DISK_1: finished piece 1 at 20-APR-13
piece handle=/oracle/oradb/flash_recovery_area/ORA138/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T171350_8q4q2gop_.bkp tag=TAG20130420T171350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 20-APR-13
channel ORA_DISK_1: finished piece 1 at 20-APR-13
piece handle=/oracle/oradb/flash_recovery_area/ORA138/backupset/2013_04_20/o1_mf_ncsnf_TAG20130420T171350_8q4q4jvq_.bkp tag=TAG20130420T171350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-APR-13

[Updated on: Sat, 20 April 2013 04:59]

Report message to a moderator

Re: backup all datafiles only using RMAN [message #582623 is a reply to message #582621] Sat, 20 April 2013 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ backup database
2/ See in the log what it puts in each file. Maybe you allocate 2 channels and so backup in parallel and so RMAN will not write in the same files from the 2 channels otherwise the file would be screwed, simple logic.

ALWAYS post the command you execute and all the parameters you have ("show all").

Regards
Michel
Re: backup all datafiles only using RMAN [message #582627 is a reply to message #582623] Sat, 20 April 2013 05:48 Go to previous messageGo to next message
onkarbanerjee
Messages: 11
Registered: April 2013
Location: Bangalore
Junior Member
This is what i had used as command.


RMAN> backup database;

Starting backup at 20-APR-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/oracle/oradb/oradata/ora138/cbp_workdbs.dbf
input datafile file number=00009 name=/oracle/oradb/oradata/ora138/cbs_user_dat.dbf
input datafile file number=00019 name=/oracle/oradb/oradata/ora138/CBS_DEFAULT_DAT
input datafile file number=00007 name=/oracle/oradb/oradata/ora138/cbs_log_dat.dbf
input datafile file number=00008 name=/oracle/oradb/oradata/ora138/cbs_log_idx.dbf
input datafile file number=00014 name=/oracle/oradb/oradata/ora138/scudatatbs.dbf
input datafile file number=00015 name=/oracle/oradb/oradata/ora138/smpdatatbs.dbf
input datafile file number=00017 name=/oracle/oradb/oradata/ora138/cbs_default_dat_tmp.dbf
input datafile file number=00021 name=/oracle/oradb/oradata/ora138/system03.dbf
input datafile file number=00022 name=/oracle/oradb/oradata/ora138/CBP_WORKDBS02.dbf
input datafile file number=00020 name=/oracle/oradb/oradata/ora138/cbs_user_dat_1.dbf
input datafile file number=00002 name=/oracle/oradb/oradata/ora138/sysaux01.dbf
input datafile file number=00001 name=/oracle/oradb/oradata/ora138/system01.dbf
input datafile file number=00006 name=/oracle/oradb/oradata/ora138/cbs_default_idx.dbf
input datafile file number=00010 name=/oracle/oradb/oradata/ora138/cbs_user_idx.dbf
input datafile file number=00011 name=/oracle/oradb/oradata/ora138/idx_cbptbs.dbf
input datafile file number=00012 name=/oracle/oradb/oradata/ora138/idx_scutbs.dbf
input datafile file number=00013 name=/oracle/oradb/oradata/ora138/idx_smptbs.dbf
input datafile file number=00016 name=/oracle/oradb/oradata/ora138/licsrvdb.dbf
input datafile file number=00018 name=/oracle/oradb/oradata/ora138/licsrvdb_tmp.dbf
input datafile file number=00003 name=/oracle/oradb/oradata/ora138/undotbs01.dbf
input datafile file number=00004 name=/oracle/oradb/oradata/ora138/users01.dbf
channel ORA_DISK_1: starting piece 1 at 20-APR-13
channel ORA_DISK_1: finished piece 1 at 20-APR-13
piece handle=/oracle/oradb/flash_recovery_area/ORA138/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T171350_8q4q2gop_.bkp tag=TAG20130420T171350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 20-APR-13
channel ORA_DISK_1: finished piece 1 at 20-APR-13
piece handle=/oracle/oradb/flash_recovery_area/ORA138/backupset/2013_04_20/o1_mf_ncsnf_TAG20130420T171350_8q4q4jvq_.bkp tag=TAG20130420T171350 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-APR-13


Here it seems it has used the same channel ORA_DISK_1. Rather in one backup it seems it took up all the datafiles and the current ctrl file and spfile in the other backup.

[Updated on: Sat, 20 April 2013 05:52]

Report message to a moderator

Re: backup all datafiles only using RMAN [message #582630 is a reply to message #582627] Sat, 20 April 2013 06:37 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have:
- in the first file all your data files
- in the second file control file and spfile

Regards
Michel
Previous Topic: rman backup instance and tablespace
Next Topic: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198
Goto Forum:
  


Current Time: Thu Mar 28 05:03:57 CDT 2024