Re: cloning

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

What is the output of the following;  (from source)

list backup of controlfile;

2016-07-13 19:50 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

RMAN> show all
2> ;

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 LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 4 TIMES TO 'SBT_TAPE';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/UAT/db/11.2.0/dbs/snapcf_UAT.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]$

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/cloning-tp1152p1161.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--