ITPub博客

首页 > 数据库 > Oracle > Oracle OCP IZ0-053 Q241(RMAN Recovery Catalog Keep)

Oracle OCP IZ0-053 Q241(RMAN Recovery Catalog Keep)

原创 Oracle 作者:abstractcyj 时间:2016-03-18 19:02:08 0 删除 编辑
241.You issued the following RMAN command to back up the database:
RMAN> RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt
BACKUP DATABASE
TAG quarterly
KEEP FOREVER
RESTORE POINT FY06Q4;}
Which two statements are true regarding the backup performed? (Choose two.)
A. Archived redo log files are backed up along with data files.
B. Only data files are backed up and a restore point named FY06Q4 is created.
C. Archived log files are backed up along with data files, and the archived log files are deleted.
D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is
consistent.
Answer: AD

验证:
RMAN> register database;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 03/18/2016 05:21:08
RMAN-06428: recovery catalog is not installed


RMAN> create catalog tablespace rman_ts;


recovery catalog created


RMAN> register database;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 03/18/2016 05:22:10
RMAN-06171: not connected to target database


RMAN> connect target /


connected to target database: INST1 (DBID=193461069)


RMAN> register database;


database registered in recovery catalog
starting full resync of recovery catalog
full resync complete


RMAN> RUN{
2> ALLOCATE CHANNEL c1 DEVICE TYPE disk;
3> BACKUP DATABASE
4> TAG quarterly
5> KEEP FOREVER
6> RESTORE POINT FY06Q4;}


allocated channel: c1
channel c1: SID=147 device type=DISK


Starting backup at 18-MAR-16
current log archived


backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/inst1/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/inst1/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/inst1/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/inst1/undotbs01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/inst1/user_data01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/inst1/users01.dbf
channel c1: starting piece 1 at 18-MAR-16
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/18/2016 05:22:54
ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes


RMAN> RUN{
2> ALLOCATE CHANNEL c1 DEVICE TYPE disk;
3> BACKUP DATABASE
4> TAG quarterly
5> KEEP FOREVER
6> RESTORE POINT FY06Q4 format '/home/oracle/%U';}


allocated channel: c1
channel c1: SID=147 device type=DISK


Starting backup at 18-MAR-16
current log archived


backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/inst1/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/inst1/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/inst1/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/inst1/undotbs01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/inst1/user_data01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/inst1/users01.dbf
channel c1: starting piece 1 at 18-MAR-16
channel c1: finished piece 1 at 18-MAR-16
piece handle=/home/oracle/0nr0ouj8_1_1 tag=QUARTERLY comment=NONE
channel c1: backup set complete, elapsed time: 00:01:05


backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 18-MAR-16
channel c1: finished piece 1 at 18-MAR-16
piece handle=/home/oracle/0or0oula_1_1 tag=QUARTERLY comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01




current log archived
backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=11 RECID=14 STAMP=906787499
channel c1: starting piece 1 at 18-MAR-16
channel c1: finished piece 1 at 18-MAR-16
piece handle=/home/oracle/0pr0oulc_1_1 tag=QUARTERLY comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01


backup will never be obsolete
archived logs required to recover from this backup will be backed up
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 18-MAR-16
channel c1: finished piece 1 at 18-MAR-16
piece handle=/home/oracle/0qr0oule_1_1 tag=QUARTERLY comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 18-MAR-16
released channel: c1

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2059682/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091618