Monday, 9 February 2015

RMAN BACKUP INCREMENTAL LEVEL 1

RMAN BACKUP INCREMENTAL LEVEL 1


Rman target / catalog rman/rman@rman(running it from the production, and the catalog is in backup server(10.0.xx.x and SID of rman is rman ))

RMAN> #
2> connect catalog *
3> connect target *
4>
5> set snapshot controlfile name to '/tmp/PROD_snapshot.ctl';
6>
7>
8> CONFIGURE DEVICE TYPE disk PARALLELISM 1;
9> CONFIGURE CONTROLFILE AUTOBACKUP ON;
10> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rmanbackup/PROD/1_xxxxxx/CTRL_BK_%F';
11>
12> run
13> {
14> allocate channel ch1 type disk;
15> allocate channel ch2 type disk;
16> backup incremental level 1 format '/rmanbackup/PROD/1_xxxxxxxx/DB_FULL_1_%U_%T' database ;
17> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
18> backup incremental level 1 format '/rmanbackup/PROD/1_xxxxxxxx/ARC_FULL_1_%U_%T' archivelog all;
19> release channel ch1;
20> release channel ch2;
21> }
22> crosscheck backup;
23> exit

No comments:

Post a Comment