rman create script and execute script

 backup as compressed backupset database format '/u01/oracle/rman/clean/compress_db_%U.dbf' ;

 

RMAN> create script lvl_1 { backup incremental level 1 database format '/u01/oracle/rman/ocm/db_%U.dbf' plus archivelog format '/u01/oracle/rman/ocm/log_%U.log' delete all input;}

created script lvl_1

RMAN> run { execute script lvl_1;}


executing script: lvl_1

http://blog.youkuaiyun.com/robinson_0612/article/details/6073020

SQL> create restore point initial_point guarantee flashback database;


Restore point created.

 

 

RMAN> backup as compressed backupset database format '/u01/app/oracle/rman/ocm/db-%U.dbf' plus archivelog format '/u01/app/oracle/rman/ocm/archivelog-%U.arc' delete input ;

Starting backup at 14-MAY-13
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 05/14/2013 18:36:00
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/app/oracle/arch/ocm/1_4_815408977.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

RMAN> change archivelog all crosscheck;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
validation failed for archived log
archive log filename=/u01/app/oracle/arch/ocm/1_4_815408977.dbf recid=1 stamp=815409928
validation failed for archived log
archive log filename=/u01/app/oracle/arch/ocm/1_5_815408977.dbf recid=2 stamp=815410151
validation failed for archived log

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

createorreplace auth_role   authidcurrent_user is   procedureset_role(role_name varchar2) end; /   createorreplace package body auth_role_pkg is   procedureset_role(role_name varchar2) as   begin     if sys_context('userenv','current_user') = 'QDL'then       dbms_session.set_role(role_name);     endif;   end; end;