您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

RMAN系统完全备份动手操作第一步

2025/11/13 17:56:27发布11次查看
[oracle@localhost ~]$ . .bash_profile [oracle@localhost ~]$ sqlplus /as sysdba sql*plus: release 11.2.0.1.0 production
[oracle@localhost ~]$ . .bash_profile
[oracle@localhost ~]$ sqlplus /as sysdba
sql*plus: release 11.2.0.1.0 production on tue feb 14 17:02:29 2012
copyright (c) 1982, 2009, oracle.  all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the partitioning, olap, data mining and real application testing options
sql> exit
disconnected from oracle database 11g enterprise edition release 11.2.0.1.0 - production
with the partitioning, olap, data mining and real application testing options
[oracle@localhost ~]$ rman
recovery manager: release 11.2.0.1.0 - production on tue feb 14 17:25:15 2012
copyright (c) 1982, 2009, oracle and/or its affiliates.  all rights reserved.
rman> connect target /
connected to target database: orcl (dbid=1290854593, not open)
rman> show all;
using target database control file instead of recovery catalog
rman configuration parameters for database with db_unique_name orcl are:
configure retention policy to redundancy 1; # default
configure backup optimization off; # default
configure default device type to disk; # default
configure controlfile autobackup off; # default
configure controlfile autobackup format for device type disk to '%f'; # default
configure device type disk parallelism 1 backup type to backupset; # default
configure datafile backup copies for device type disk to 1; # default
configure archivelog backup copies for device type disk to 1; # default
configure maxsetsize to unlimited; # default
configure encryption for database off; # default
configure encryption algorithm 'aes128'; # default
configure compression algorithm 'basic' as of release 'default' optimize for load true ; # default
configure archivelog deletion policy to none; # default
configure snapshot controlfile name to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
rman> backup database format '/u01/app/oracle/rmanbak/whole_%d_%u';
starting backup at 14-feb-12
allocated channel: ora_disk_1
channel ora_disk_1: sid=20 device type=disk
channel ora_disk_1: starting full datafile backup set
channel ora_disk_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ora_disk_1: starting piece 1 at 14-feb-12
rman-00571: ===========================================================
rman-00569: =============== error message stack follows ===============
rman-00571: ===========================================================
rman-03009: failure of backup command on ora_disk_1 channel at 02/14/2012 17:28:39
ora-19504: failed to create file /u01/app/oracle/rmanbak/whole_orcl_01n3ahu3_1_1
ora-27040: file create error, unable to create file
linux error: 2: no such file or directory
rman>  backup database format '/u01/app/oracle/rmanbak/whole_%d_%u';
starting backup at 14-feb-12
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=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ora_disk_1: starting piece 1 at 14-feb-12
channel ora_disk_1: finished piece 1 at 14-feb-12
piece handle=/u01/app/oracle/rmanbak/whole_orcl_02n3ai5f_1_1 tag=tag20120214t173230 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:19:21
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 14-feb-12
channel ora_disk_1: finished piece 1 at 14-feb-12
piece handle=/u01/app/oracle/rmanbak/whole_orcl_03n3aj9q_1_1 tag=tag20120214t173230 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:01
finished backup at 14-feb-12
rman>

该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product