아바마 스케쥴 export 후 import 하는 방법

Symptoms
Customer wants to migrate specific group and its settings (name, domain, encryption method, and so forth)  and assigned policy objects (dataset, schedule and retention policy) from one grid to another grid.
Resolution
Starting with 4.1.2-33, the mccli group export and mccli mcs import commands allows this functionality. Information is exported into xml format.  Note that the data exported in this matter will not contain the list of client members. Data exported from 4.1.2-33 grid can be imported into 5.x grids.
To export:
The group TestGroup exists in /clients domain on source grid.

mccli group export --file=<path_to_exported_file> --domain=<name_of_domain> --name=<group_selected_for_export>

example:
mccli group export --file=/home/admin/test.xml --domain=/clients --name=TestGroup

0,23000,CLI command completed successfully.
Using ascii transfer mode, transfer the newly created xml file (test.xml)to the new Avamar grid.
Once the file is on the target grid
To import:

mccli mcs import --file=<path_of_imported_xml>

example:
mccli group import --file=/home/admin/test.xml
MCS data XML file /data01/home/admin/test.xml created by MASSAMAR411 on 2010-02-04 00:15:55.302
0,23000,CLI command completed successfully.
You can use the command to verify the import worked.
mccli group show --domain=/<domain_where_group_was_imported>
mccli client add --name=/clients/user-pc ----------------- ADD는 되나 activity는 되지 않음.

SuSE MAC 변경 방법

SuSE MAC 변경 방법

/etc/init.d/boot.local파일을 열어
해당하는 eth*의 mac변경 값을 넣어 준후 저장하고 나온다.

/sbin/ifconfig eth0 down
/sbin/ifconfig eth0 hw ether AA:50:8D:61:C4:AA
/sbin/ifconfig eth0 up


sync;sync;sync


reboot

Avamar Client move 방법

root@avamar:/data01/#: mccli client move --name=/clients/test/csk00000-pc --new-domain=/clients
0,22515,Client was moved.
Attribute Value
--------- ---------------------------------------------------------------------------------------------------------------------------------------
client    <appdircomponent contact="" domain="/clients/test" email="" id="24a4b6a5caa6b294322c41256bb3b982598abd5c" name="csk00000-pc" phone=""/>

Avamar part Number

Avamar Rman Tapble space 복구 방법

(1) 복구 확인용 테이블스페이스 및 테이블 생성 OS> sqlplus / as sysdba SQL> create tablespace test_ts datafile '/legato/oracle/oradata/master/test.dbf' size 10m; SQL> alter user sys quota unlimited on test_ts; SQL> create table sys.test tablespace test_ts as select 1 as no, sysdate as date1 from dual; SQL> exit OS> rman target / RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> report schema; using target database control file instead of recovery catalog Report of database schema   List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    510      SYSTEM               ***     /legato/oracle/oradata/master/system01.dbf 2    210      UNDOTBS1             ***     /legato/oracle/oradata/master/undotbs01.dbf 3    430      SYSAUX               ***     /legato/oracle/oradata/master/sysaux01.dbf 4    22       USERS                ***     /legato/oracle/oradata/master/users01.dbf 5    300      SPLEXT               ***     /legato/oracle/oradata/master/splext01.dbf 6    1000     ALST                 ***     /legato/oracle/oradata/master/alst01.dbf 7    100      SUJI                 ***     /legato/oracle/oradata/master/suji01.dbf 8    2400     QCO                  ***     /legato/oracle/oradata/master/qco01.dbf 9    500      LIVE                 ***     /legato/oracle/oradata/master/live.dbf 10   1024     SPLEXEE              ***     /legato/oracle/oradata/master/splexee01.dbf 11   10       TEST_TS              ***     /legato/oracle/oradata/master/test.dbf   List of Temporary Files ======================= File Size(MB) Tablespace           Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1    269      TEMP                 32767       /legato/oracle/oradata/master/temp01.dbf    (2) 데이터 파일과 컨트롤 파일 백업 RMAN> backup database; … 생략 … RMAN> backup current controlfile format             '/u01/app/oracle/oradata/devdb_fra/DEVDB/controlfile001.bck'; … 생략 … RMAN> sql 'alter system switch logfile'; RMAN> sql 'alter system switch logfile'; RMAN> sql 'alter system switch logfile'; RMAN> sql 'alter system switch logfile'; RMAN> sql 'alter system switch logfile';   (3) 테이블 스페이스 삭제 RMAN> sql 'drop tablespace test_ts including contents and datafiles';     -테이블스페이스 삭제 RMAN> exit OS> tail -n 20 $ORACLE_HOME/rdbms/log/alert_devdb.log master:root:/usr/bin]tail -f /legato/oracle/admin/master/bdump/alert_master.log         media 'avtar007'         handle 'CONTROLFILE.master.c-2799742462-20111026-04' Wed Oct 26 18:26:04 2011 drop tablespace test_ts including contents and datafiles Wed Oct 26 18:26:20 2011 Deleted file /legato/oracle/oradata/master/test.dbf Starting control autobackup Control autobackup written to DISK device         handle '/legato/oracle/orahome/dbs/c-2799742462-20111026-05' Completed: drop tablespace test_ts including contents and datafiles ^Cmaster:root:/usr/bin]date Wed Oct 26 18:32:38 KORST 2011   18시 27분 시점으로 복구  (4) 테이블스페이스 삭제 상황이므로 컨트롤 파일과 모든 데이터 파일을 복원하고 복구 OS> export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' OS> export NLS_LANG=american OS> rman target / RMAN> shutdown immediate RMAN> startup nomount RMAN> set dbid=2799742462; set controlfile autobackup format for device type sbt to 'CONTROLFILE.master.%F'; run { allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,ENV=(PATH=/usr/sbin:/usr/bin:/sbin:/usr/local/avamar/bin)" format '%d_%U'; send '"--prefix=10g/master/"' ; send '"--flagfile=/usr/local/avamar/var/avtar.txt"' ; restore controlfile from 'CONTROLFILE.master.c-2799742462-20111026-04'; release channel c1; } allocated channel: c1 channel c1: sid=156 devtype=SBT_TAPE channel c1: EMC|Avamar (avtar backup)   sent command to channel: c1   sent command to channel: c1   Starting restore at 26-OCT-11   avtar Info <5241>: Logging to /usr/local/avamar/var/avtar.log avtar Info <5551>: Command Line: /usr/local/avamar/bin/avtar.bin --physicalRAM=5120 --vardir=/usr/local/avamar/var --bindir=/usr/local/avamar/bin --sysdir=/usr/local/avamar/etc --flagfile=/usr/local/avamar/var/avtar.txt --pidname=Oracle --pidnum=5002 --logfile=/usr/local/avamar/var/avtar.log --vardir=/usr/local/avamar/var --id=MCUser --password=******* --account=/clients/master --server=avatest.com --format=xml --history 10g/master/CONTROLFILE.master.c-2799742462-20111026-04 --label=CONTROLFILE.master.c-2799742462-20111026-04 avtar Info <5552>: Connecting to Server (avatest.com) avtar Info <5554>: - Connecting to one node in each datacenter avtar Info <5993>: - Connect: Connected to 192.168.1.120:27000, Priv=0, TCP avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32488.9574 secs) avtar Info <5993>: - Datacenter 0 has 1 nodes: Connected to 192.168.1.120:27000, Priv=0, TCP avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32488.9584 secs) avtar Info <5583>: Login User: "MCUser", Domain: "default", Account: "/clients/master" avtar Info <5580>: - Logging in on connection 0 avtar Info <5582>: - Login successful avtar Info <5018>: - Session ID: 1319623921593353 avtar Info <6509>: Successfully logged into Server avtar Info <5922>: History of 10g/master/CONTROLFILE.master.c-2799742462-20111026-04 for /clients/master as of 2011-10-26 19:12:01 KORST avtar Info <5314>: Command completed (exit code 0: Success) channel c1: restoring control file redirect sbt_stdout avtar Info <5241>: Logging to /usr/local/avamar/var/avtar.log avtar Info <5551>: Command Line: /usr/local/avamar/bin/avtar.bin --physicalRAM=5120 --vardir=/usr/local/avamar/var --bindir=/usr/local/avamar/bin --sysdir=/usr/local/avamar/etc --flagfile=/usr/local/avamar/var/avtar.txt --pidname=Oracle --pidnum=5002 --logfile=/usr/local/avamar/var/avtar.log --vardir=/usr/local/avamar/var --id=MCUser --password=******* --account=/clients/master --server=avatest.com --to-stdout --incpartials --label=CONTROLFILE.master.c-2799742462-20111026-04 -x 10g/master/CONTROLFILE.master.c-2799742462-20111026-04 avtar Info <5552>: Connecting to Server (avatest.com) avtar Info <5554>: - Connecting to one node in each datacenter avtar Info <5993>: - Connect: Connected to 192.168.1.120:27000, Priv=0, TCP avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32488.9652 secs) avtar Info <5993>: - Datacenter 0 has 1 nodes: Connected to 192.168.1.120:27000, Priv=0, TCP avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32488.9647 secs) avtar Info <5583>: Login User: "MCUser", Domain: "default", Account: "/clients/master" avtar Info <5580>: - Logging in on connection 0 avtar Info <5582>: - Login successful avtar Info <5018>: - Session ID: 1319623923968573 avtar Info <6509>: Successfully logged into Server avtar Info <5295>: Starting restore at 2011-10-26 19:12:04 KORST as "oracle" on "master" (5 CPUs) [5.0.106-28] avtar Info <5949>: Backup file system character encoding is UTF-8. avtar Info <8695>: Backup from AIX host "/clients/master" (master) with plugin 5002 - AIX Oracle RMAN avtar Info <5538>: Backup #11 label "CONTROLFILE.master.c-2799742462-20111026-04" timestamp 2011-10-27 03:16:49 KORST, 1 files, 5.750 MB avtar Info <5291>: Estimated size for "10g/master/CONTROLFILE.master.c-2799742462-20111026-04" is 5.750 MB avtar Info <5267>: Restore of "10g/master/CONTROLFILE.master.c-2799742462-20111026-04" completed avtar Info <7875>: Restored 5.750 MB from selection(s) with 5.750 MB in 1 files avtar Info <6090>: Restored 5.750 MB in 0.47 minutes: 731.9 MB/hour (127 files/hour) avtar Info <7833>: Finished at 2011-10-26 19:12:32 KORST, Elapsed time: 0000h:00m:28s avtar Info <6608>: Not sending wrapup anywhere. avtar Info <5314>: Command completed (exit code 0: Success) channel c1: restore complete, elapsed time: 00:00:37 output filename=/legato/oracle/oradata/master/control01.ctl output filename=/legato/oracle/oradata/master/control02.ctl output filename=/legato/oracle/oradata/master/control03.ctl Finished restore at 26-OCT-11   released channel: c1   RMAN>   RMAN> startup mount RMAN> startup mount;   database is already started database mounted   RMAN> RMAN> run { allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,ENV=(PATH=/usr/sbin:/usr/bin:/sbin:/usr/local/avamar/bin)" format '%d_%U'; send '"--prefix=10g/master/"' ; send '"--flagfile=/usr/local/avamar/var/avtar.txt"' ; restore database; release channel c1; }   allocated channel: c1 channel c1: sid=159 devtype=SBT_TAPE channel c1: EMC|Avamar (avtar backup)   sent command to channel: c1   sent command to channel: c1   Starting restore at 27-OCT-11   avtar Info <5241>: Logging to /usr/local/avamar/var/avtar.log avtar Info <5551>: Command Line: /usr/local/avamar/bin/avtar.bin --physicalRAM=5120 --vardir=/usr/local/avamar/var --bindir=/usr/local/avamar/bin --sysdir=/usr/local/avamar/etc --flagfile=/usr/local/avamar/var/avtar.txt --pidname=Oracle --pidnum=5002 --logfile=/usr/local/avamar/var/avtar.log --vardir=/usr/local/avamar/var --id=MCUser --password=******* --account=/clients/master --server=avatest.com --hfsport=27000 --incpartials --encrypt=tls --format=xml --history 10g/master/MASTER_bmmq54us_1_1 --label=MASTER_bmmq54us_1_1 avtar Info <5552>: Connecting to Server (avatest.com) avtar Info <5554>: - Connecting to one node in each datacenter avtar Info <5993>: - Connect: Connected to 192.168.1.120:29000, Priv=0, SSL Cipher=AES128-SHA avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32487.9368 secs) avtar Info <5993>: - Datacenter 0 has 1 nodes: Connected to 192.168.1.120:29000, Priv=0, SSL Cipher=AES128-SHA avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32487.9326 secs) avtar Info <5583>: Login User: "MCUser", Domain: "default", Account: "/clients/master" avtar Info <5580>: - Logging in on connection 0 avtar Info <5582>: - Login successful avtar Info <5018>: - Session ID: 1319685626448011 avtar Info <6509>: Successfully logged into Server avtar Info <5922>: History of 10g/master/MASTER_bmmq54us_1_1 for /clients/master as of 2011-10-27 12:20:26 KORST avtar Info <5314>: Command completed (exit code 0: Success) channel c1: starting datafile backupset restore channel c1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /legato/oracle/oradata/master/system01.dbf restoring datafile 00002 to /legato/oracle/oradata/master/undotbs01.dbf restoring datafile 00003 to /legato/oracle/oradata/master/sysaux01.dbf restoring datafile 00004 to /legato/oracle/oradata/master/users01.dbf restoring datafile 00005 to /legato/oracle/oradata/master/splext01.dbf restoring datafile 00006 to /legato/oracle/oradata/master/alst01.dbf restoring datafile 00007 to /legato/oracle/oradata/master/suji01.dbf restoring datafile 00008 to /legato/oracle/oradata/master/qco01.dbf restoring datafile 00009 to /legato/oracle/oradata/master/live.dbf restoring datafile 00010 to /legato/oracle/oradata/master/splexee01.dbf restoring datafile 00011 to /legato/oracle/oradata/master/test.dbf channel c1: reading from backup piece MASTER_bmmq54us_1_1 redirect sbt_stdout avtar Info <5241>: Logging to /usr/local/avamar/var/avtar.log avtar Info <5551>: Command Line: /usr/local/avamar/bin/avtar.bin --physicalRAM=5120 --vardir=/usr/local/avamar/var --bindir=/usr/local/avamar/bin --sysdir=/usr/local/avamar/etc --flagfile=/usr/local/avamar/var/avtar.txt --pidname=Oracle --pidnum=5002 --logfile=/usr/local/avamar/var/avtar.log --vardir=/usr/local/avamar/var --id=MCUser --password=******* --account=/clients/master --server=avatest.com --hfsport=27000 --incpartials --encrypt=tls --to-stdout --incpartials --label=MASTER_bmmq54us_1_1 -x 10g/master/MASTER_bmmq54us_1_1 avtar Info <5552>: Connecting to Server (avatest.com) avtar Info <5554>: - Connecting to one node in each datacenter avtar Info <5993>: - Connect: Connected to 192.168.1.120:29000, Priv=0, SSL Cipher=AES128-SHA avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32487.9341 secs) avtar Info <5993>: - Datacenter 0 has 1 nodes: Connected to 192.168.1.120:29000, Priv=0, SSL Cipher=AES128-SHA avtar Info <5693>: - Local client time and Server time are significantly different (delta=-32487.9298 secs) avtar Info <5583>: Login User: "MCUser", Domain: "default", Account: "/clients/master" avtar Info <5580>: - Logging in on connection 0 avtar Info <5582>: - Login successful avtar Info <5018>: - Session ID: 1319685633198315 avtar Info <6509>: Successfully logged into Server avtar Info <5295>: Starting restore at 2011-10-27 12:20:33 KORST as "oracle" on "master" (5 CPUs) [5.0.106-28] avtar Info <5949>: Backup file system character encoding is UTF-8. avtar Info <8695>: Backup from AIX host "/clients/master" (master) with plugin 5002 - AIX Oracle RMAN avtar Info <5538>: Backup #15 label "MASTER_bmmq54us_1_1" timestamp 2011-10-27 20:18:23 KORST, 1 files, 1.252 GB avtar Info <5291>: Estimated size for "10g/master/MASTER_bmmq54us_1_1" is 1.252 GB avtar Info <5100>: Status 2011-10-27 12:35:32, 1 files, 76.44 MB (1 files, 15.78 MB, 20.65% new) 19MB 1% CPU avtar Info <5100>: Status 2011-10-27 12:50:33, 1 files, 143.9 MB (1 files, 30.01 MB, 20.85% new) 19MB 1% CPU   (5) 복구 확인 RMAN> report schema; Report of database schema List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of report command at 05/18/2010 17:54:41 RMAN-20021: database not set RMAN-06031: could not translate database keyword RMAN> exit OS> rman target /   RMAN> report schema; using target database control file instead of recovery catalog Report of database schema List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    200      SYSTEM               ***     /u01/app/oracle/oradata/devdb/system01.dbf 2    120      UNDOTBS01            ***     /u01/app/oracle/oradata/devdb/undotbs01.dbf 3    200      SYSAUX               ***     /u01/app/oracle/oradata/devdb/sysaux01.dbf 4    10       UNDO01               ***     /u01/app/oracle/oradata/devdb/undo01.dbf 5    10       USER_TAB_TS          ***     /u01/app/oracle/oradata/devdb/user_tab_ts.dbf 6    5        USER_IND_TS          ***     /u01/app/oracle/oradata/devdb/user_ind_ts.dbf 7    10       TEST_TS              ***     /u01/app/oracle/oradata/devdb/test_ts.dbf List of Temporary Files ======================= File Size(MB) Tablespace           Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1    20       TEMP                 2048        /u01/app/oracle/oradata/devdb/temp01.tmp 2    10       TEMP01               10          /u01/app/oracle/oradata/devdb/temp01.dbf   RMAN> exit OS> sqlplus / as sysdba SQL> select * from sys.test;         NO            DATE1 ---------- -------------------          1 2010-05-18 17:36:59 SQL> exit   (6) 정리 OS> rman target / RMAN> show retention policy; RMAN> crosscheck database; RMAN> crosscheck archivelog all; RMAN> report obsolete; RMAN> delete obsolete; RMAN> list backup by file; RMAN> exit