SQL> select dbid from v$database ;
DBID --1546337699
SQL> select file_id,file_name from dba_data_files ;
FILE_ID FILE_NAME
--------------------------------------------------------------------------------
7 /u01/oracle/oradata/ORCL/datafile/users_.dbf
4 /u01/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_gqdkcwkx_.dbf
1 /u01/oracle/oradata/ORCL/datafile/o1_mf_system_gqdk7gpx_.dbf
3 /u01/oracle/oradata/ORCL/datafile/o1_mf_sysaux_gqdk9j4p_.dbf
RMAN> select group#,member from v$logfile ;
GROUP# MEMBER
--------------------------------------------------------------------------------
3 /u01/oracle/oradata/ORCL/onlinelog/o1_mf_3_gqdkjbhw_.log
3 /u01/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_3_gqdkkm51_.log
2 /u01/oracle/oradata/ORCL/onlinelog/o1_mf_2_gqdkf6yy_.log
2 /u01/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_2_gqdkghss_.log
1 /u01/oracle/oradata/ORCL/onlinelog/o1_mf_1_gqdkf6y6_.log
1 /u01/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_1_gqdkgj2t_.log
SQL> show parameter control_files ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/oracle/oradata/ORCL/controlfile/o1_mf_gqdkf3bm_.ctl,
u01/oracle/fast_recovery_area/orcl/ORCL/controlfile/o1_mf_gqdkf3gc_.ctl
整个数据库的full备份
OR
整个数据库的0级备份
OR
各个表空间的0+增量备份
RMAN>backup full database format '/u01/backup/db_full_%T_%U' ;
RMAN>list backup of controlfile ;
RMAN>alter system switch logfile ;
查看归档路径
show parameter log_archiverd_dest ;
select name from v$archived_log ;
a. 数据文件的备份copy到新服务器同名目录下:
scp /u01/backup/db_0_20190910_03ubdvs0_1_1 IP:/u01/backup
b. 控制文件的自动备份
scp /u01/oracle/fast_recovery_area/orcl/ORCL/autobackup/2019_09_17/o1_mf_s_1019240775_gr1f69cl_.bkp IP:/u01/oracle/fast_recovery_area/orcl/ORCL/autobackup/2019_09_17
c.拷贝归档
scp /u01/oracle/fast_recovery_area/orcl/ORCL/archivelog/2019_09_17/o1_mf_1_6_gr1ls91v_.arc IP:/u01/oracle/fast_recovery_area/orcl/ORCL/archivelog/
[oracle@rhel7 Desktop]$ export ORACLE_SID=orcl
[oracle@rhel7 Desktop]$ rman target /
RMAN> startup nomount ;
RMAN> set dbid 1546337699 ;
RMAN> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/backup/%F';
RMAN> restore spfile from autobackup ;
RMAN> create pfile='/u01/oracle/product/12.2.0/dbs/initorcl.ora' from spfile ;
cat /u01/oracle/product/12.2.0/dbs/initorcl.ora
对里面的一些路径进行排查,如果不存在就需要现在手动创建
比如:
*.audit_file_dest='/u01/oracle/admin/orcl/adump'
[oracle@rhel7 autobackup]$ mkdir -p /u01/oracle/admin/orcl/adump
*.db_recovery_file_dest='/u01/oracle/fast_recovery_area/orcl'
这样做的目的是为了防止重启实例的时候出现如下错误
RMAN> startup nomount ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/18/2019 17:15:07
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
当然也可以手动修改pfile的参数(将路径修改为本台服务器的正确路径)然后重新创建spfile ;
RMAN> shutdown ;
RMAN> startup nomount;
RMAN> restore controlfile from autobackup;
RMAN> alter database mount;
run {
set until scn 1983669;
restore database;
recover database;
}
RMAN> alter database open resetlogs;
[oracle@rhel7]$orapwd file="$ORACLE_HOME/dbs/orapworcl" password="Qaz_1234"
# 【原创声明】版权所有非经授权请勿做任何商业用途,仅限技术交流; 转载请注明出处,谢谢;
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞3
添加新评论0 条评论