solaris下oracle自动物理备份的脚本怎么写

云裴

solaris下oracle自动物理备份的脚本怎么写？我这样不对，提示shutdown、host等命令找不到。
$ORACLE_HOME/bin/sqlplus "/as sysdba"
shutdown immediate
host cp /oracle/oracic/oradata/szdb/* /oracle/oracic/bak/szdb
startup
exit

cht11cht

http://download-west.oracle.com/ ... rcmsynta9.htm#78484
这个网址说的很详细！

pq777

关于RMAN的使用.那位大哥可以发过使用详细说明上来...谢谢了.

johnz002

$ORACLE_HOME/bin/sqlplus << EOF
conn sys as sysdba
shutdown immediate
EOF
cp /oracle/oracic/oradata/szdb/* /oracle/oracic/bak/szdb
$ORACLE_HOME/bin/sqlplus << EOF1
conn sys as sysdb
startup
EOF1
exit

cht11cht

如果你不想立即删除归档日志可以改为如下：
connect target test/test@grid;
RUN{
allocate channel c1 type disk;
backup tablespace 'SYSTEM','UNDOTBS1','SYSAUX','USERS','UNDOTBS2' format '/tmp/marsbak_test2_tablespace_%s.bak';
sql 'alter system archive log current';
backup archivelog all format '/tmp/marsbak_test2_archivelogFile_1125363757_%s.bak';
delete copy of archivelog all completed before 'sysdate-14';（保留14天以内的日志）
release channel c1;
}

cht11cht

用rman备呀
connect target test/test@grid;
RUN{
allocate channel c1 type disk;
backup tablespace 'SYSTEM','UNDOTBS1','SYSAUX','USERS','UNDOTBS2' format '/tmp/marsbak_test2_tablespace_%s.bak';
sql 'alter system archive log current';
backup archivelog all delete input format '/tmp/marsbak_test2_archivelogFile_1125363757_%s.bak';
release channel c1;
}
增量：
connect target test/test@grid;
RUN{
allocate channel c1 type disk;
backup incremental level 1 cumulative  tablespace 'SYSTEM','UNDOTBS1','SYSAUX','USERS','UNDOTBS2' format '/tmp/marsbak_test2_tablespace_%s.bak';
sql 'alter system archive log current';
backup archivelog all delete input format '/tmp/marsbak_test2_archivelogFile_1125363757_%s.bak';
release channel c1;
}

恢复：
RMAN> connect target test/test@grid;
shutdown immediate;
startup mount pfile=/export/home/oracle/admin/grid/pfile/init.ora.729200519032;
RUN{
allocate channel c1 type disk;
restore database;
recover database;
sql  'ALTER DATABASE OPEN ';
release channel c1;
}
你可以把它写到脚本中

blue_stone

如果使用的是spfile则是
$ORACLE_HOME/dbs/spfile$ORACLE_SID.ora
如果使用pfile则是
$ORACLE_HOME/dbs/init$ORACLE_SID.ora

云裴

spfile或者pfile是不是只initSID.ora文件？

blue_stone

spfile或者pfile最好也备份