IOTN :: Field Book :: Altibase

ȸ¿ø°¡ÀÔ

hot backup script [ alter database backup database to '/backup/'; ]

ÃÖ±æÈ£ [LIST]   2016-10-02 11:34:42, Á¶È¸ : 1,181 [ Ãßõ ] ============================================================================= [root@dbsvr backup]# su - altibase [altibase@dbsvr ~]$ is -sysdba -----------------------------------------------------------------      Altibase Client Query utility.      Release Version 6.5.1.1.2      Copyright 2000, ALTIBASE Corporation or its subsidiaries.      All Rights Reserved. ----------------------------------------------------------------- ISQL_CONNECTION = UNIX, SERVER = localhost iSQL(sysdba)> alter database backup database to '/backup/'; Alter success. iSQL(sysdba)> [ ºñÃß ] ============================================================================= # ALTIBASE_ENV . /altibase/product/6.1/conf/altibase_user.env alias sql='isql -s 127.0.0.1 -u SYS -p MANAGER -sysdba' alias sql='isql -u sys -p manager -port 20301 -nls_use MS949 -s 127.0.0.1 -sysdba' alias ah='cd $ALTIBASE_HOME' su - altibase -c '/home/altibase/backup.sh' > /backup/altibase.log 2>&1 #!/bin/sh #backup.sh isql -s localhost -u sys -p manager -sysdba -f backup.sql -- backup.sql set colsize 80 set heading off set Feedback off alter system switch logfile; alter system checkpoint; ! rm backup.lst bk.begin.sql bk.end.sql spool backup.lst SELECT distinct nls_characterset,nls_nchar_characterset FROM v$nls_parameters; select checkpoint_path||'/'||space_name||'*' name from v$mem_tablespaces m, v$mem_tablespace_checkpoint_paths c where m.space_id=c.space_id union all select name from v$datafiles; spool off ! echo $ALTIBASE_HOME/conf/ >> backup.lst ! echo $ALTIBASE_HOME/dbs/ >> backup.lst ! grep ^LOG_DIR $ALTIBASE_HOME/conf/altibase.properties | awk '{print $3}' >> backup.lst ! grep ^LOGANCHOR_DIR $ALTIBASE_HOME/conf/altibase.properties | awk '{print $3}' | sort | uniq >> backup.lst ! grep ^ARCHIVE_DIR $ALTIBASE_HOME/conf/altibase.properties | awk '{print $3}' >> backup.lst -- ! grep ^/ backup.lst spool bk.begin.sql select 'alter tablespace '||name||' begin backup;' SQL from v$tablespaces where name not in ('SYS_TBS_DISK_TEMP') ; spool off @ bk.begin.sql ! find `grep ^/ backup.lst`  | cpio -pdvmu /backup spool bk.end.sql select 'alter tablespace '||name||' end backup;' SQL from v$tablespaces where name not in ('SYS_TBS_DISK_TEMP') ; spool off @ bk.end.sql exit 3.235.78.122

LIST

CategoryTroubleshootAdminInstall & ConfigTuningBackup & RecoveryScript	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Admin	dbf À§Ä¡ È®ÀÎ / »èÁ¦ / create database [$ server create MS949 UTF8 ] / ¼­ºñ½º ½ÃÀÛ	ÃÖ±æÈ£	2020/10/08	263
Troubleshoot	[FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]	ÃÖ±æÈ£	2020/10/07	343
Admin	ÁÖ¼Ò iloader in [ csv data import ]	ÃÖ±æÈ£	2020/10/07	271
Admin	altibase replication test	ÃÖ±æÈ£	2016/11/17	1847
Backup & Recovery	hot backup script [ alter database backup database to '/backup/'; ]	ÃÖ±æÈ£	2016/10/02	1181
Admin	-- ¸ðµç Å×À̺í	ÃÖ±æÈ£	2016/10/02	1092
Admin	[ERR-110A4 : Backup in progress. Please wait until the current backup is completed.]	ÃÖ±æÈ£	2016/10/02	746
Admin	Sybase IQ 15.2 evaluation software	ÃÖ±æÈ£	2013/08/21	2875
Admin	alter database rename datafile	ÃÖ±æÈ£	2013/07/27	4150
Backup & Recovery	aexport lv:9	ÃÖ±æÈ£	2013/07/22	1346
Admin	alter tablespace ts_disk1 alter datafile '/altibase/6.1/dbs/tbs_disk1_200.dbf' autoextend on next 200m maxsize unlimited;	ÃÖ±æÈ£	2013/04/13	2784
Troubleshoot	[FAILURE] The data file '/altibase/6.1/dbs/SYS_TBS_MEM_DIC-0-0' has an invalid header. lv:9	ÃÖ±æÈ£	2013/04/11	1383
Troubleshoot	oracle to altibase data type ȣȯ	ÃÖ±æÈ£	2013/04/05	2892
Admin	getdata.sql [ ¿À¶óŬ, ¾ËƼº£À̽º ¸¶À̱׷¹ÀÌ¼Ç ³»¿ë ] lv:9	ÃÖ±æÈ£	2013/04/05	1299
Admin	http://support.altibase.com/kr/manual [ NLS_DATE_FORMAT = altibase.properties:DEFAULT_DATE_FORMAT ]	ÃÖ±æÈ£	2013/04/04	13605
Admin	altibase ±³À° ÀÚ·á lv:4	ÃÖ±æÈ£	2013/04/03	1496

¸ñ·Ïº¸±â

1

Copyright 1999-2022 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)