Standby制作.docx

主库：数据库备份前校验1：是否启动归档：Archive log list;如果不启动则这样操作：Shutdown immediate;Startup mount;Alter database archivelog;Alter system switch logfile;2：修改归档路径：Alter system set log_archive_dest_1=location=/data/oracle/oradata/crms/arch scope=both;主库：RMAN备份数据库1:启动RMAN并连接上去：RmanConnect target2:设置控制文件自动备份：CONFIGURE CONTROLFILE AUTOBACKUP ON;3：备份数据库：Backup database;主库：创建备库相关路径及参数文件1：主库创建参数文件：create pfile from spfile;2：把参数文件传递到备库：Cd $ORACLE_HOMECd dbsLs –ltrh一般情况下最新的一个，就是参数文件，顺带把密码文件也传递过去：Scp *.*?oracle@192.168.1.2:路径备库：启动数据库到NOMOUNT状态1：修改环境变量，每次登录都要修改ORACLE_SID=XXXX是主库的SID2：修改及创建路径More initxx.ora查看路径，只要文件里出现的路径，都要创建：Mkdir –p?路径2：到参数文件传递地方，把数据库启动到NOMOUNT状态；Sqlplus “/ as sysdba”startup nomount pfile=’initxx.ora’;OrSqlplus “/ as sysdba”startup nomount;主库：查看备份情况及备份路径一般屏幕输出如下：RMAN backup database;?Starting backup at 2010-10-15 14:16:46using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00005 name=/data/oracle/oradata/crms/Caesar_data01.dbfinput datafile file number=00007 name=/data/oracle/oradata/crms/undotbs02.dbfinput datafile file number=00008 name=/data/oracle/oradata/crms/undotbs03.dbfinput datafile file number=00009 name=/data/oracle/oradata/crms/Caesar_data02.dbfinput datafile file number=00010 name=/data/oracle/oradata/crms/Caesar_data03.dbfinput datafile file number=00011 name=/data/oracle/oradata/crms/Caesar_data04.dbfinput datafile file number=00012 name=/data/oracle/oradata/crms/undotbs04.dbfinput datafile file number=00013 name=/data/oracle/oradata/crms/undotbs05.dbfinput datafile file number=00025 name=/data/oracle/oradata/crms/undotbs06.dbfinput datafile file number=00026 name=/data/oracle/oradata/crms/undotbs07.dbfinput datafile file number=00001 name=/data/oracle/oradata/crms/system01.dbfinput datafile file number=00002 name=/data/oracle/oradata/crms/sysaux01.dbfinput datafile file number=00006 name=/data/oracle/oradata/crms/bi_sys01.dbfinput datafile file number=0001