Re: cloning

Posted by Roshan on Jul 13, 2016; 4:50pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/cloning-tp1152p1161.html

RMAN> connect target /

connected to target database: PROD (DBID=293518444)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 2;
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 LOA                D TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 4 TIMES TO 'SBT_TAPE';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/PROD/db/11.2.0/dbs/snapcf_PR                OD.f'; # default



[orauat@erpuat backupset]$ ls -al 2016_07_12/
total 19060380
drwxrwxrwx 1 root root        4096 Jul 12 21:51 .
drwxrwxrwx 1 root root        4096 Jul 12 04:09 ..
-rwxrwxrwx 1 root root   473882624 Jul 12 21:52 o1_mf_annnn_AFTERNOON_ARCHIVED_0_crbcddmz_.bkp
-rwxrwxrwx 1 root root   154521088 Jul 12 21:51 o1_mf_annnn_AFTERNOON_ARCHIVED_0_crbcddno_.bkp
-rwxrwxrwx 1 root root   197863424 Jul 12 04:10 o1_mf_annnn_ERP_DAILY_BACKUP_071_cr8f6dv8_.bkp
-rwxrwxrwx 1 root root     6060032 Jul 12 12:22 o1_mf_annnn_MIDDAY_ARCHIVED_LO_0_cr9b2gt4_.bkp
-rwxrwxrwx 1 root root   441806848 Jul 12 12:24 o1_mf_annnn_MIDDAY_ARCHIVED_LO_0_cr9b2gwy_.bkp
-rwxrwxrwx 1 root root  8152350720 Jul 12 03:57 o1_mf_nnnd0_ERP_DAILY_BACKUP_071_cr898c6v_.bkp
-rwxrwxrwx 1 root root 10091331584 Jul 12 04:09 o1_mf_nnnd0_ERP_DAILY_BACKUP_071_cr898c7j_.bkp
[orauat@erpuat backupset]$