rman DUPLICATE DATABASE BACKUP LOCATION


run{                                                                                                                                  backup as compressed backupset database format '/u80/inc0_%d_%T_p%p_s%s';                                                                backup as compressed backupset archivelog all format '/u80/arc_%d_%T_p%p_s%s'; backup spfile format '/u80/spfile_%d_%T_p%p_s%s';                                                           backup current controlfile format '/u80/ctl_%d_%T_p%p_s%s';                                                                              }   scp *20110921* oracle@xh002:$PWD   cddbs   vi initTWINT01.ora   db_name=TWINT01 db_unique_name=TWINT01 control_files='/u01/control01.ctl' audit_file_dest='/u01' compatible='11.2.0' diagnostic_dest='/u01' db_create_file_dest='/u01' log_archive_dest_1='LOCATION=/u01' log_archive_format='TWINT01_%t_%s_%r.arc'   export ORACLE_SID=TWINT01 sqlplus / as sysdba startup nomount  ... Continue Reading →

Advertisements

Blog at WordPress.com.

Up ↑