最近几天回东北老家处理些事情,在老家的时候公司正好有一个项目要上线,让我导入数据和数据库备份。原以为数据导入和做RMAN的7策略备份会很快。真是应了那句话了:“事情总是向最坏的方向发展”。
一、讲一下坏境:
操作系统:
#lsb_release-a
LSB Version::core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch
Distributor ID: RedHatEnterpriseServer
Description:Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Release:5.5
Codename:Tikanga
11GRAC
数据库版本:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE11.2.0.1.0Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 – Production
二、我的操作步骤:
2.1、配置启动归档及闪回
--先配归档才可以启动闪回
alter system set cluster_database=false scope=spfile
alter system switch logfile;
startup mount
alter database archivelog;
alter system set cluster_database=true scope=spfile
shutdown immediate;
startup
SQL> archive log list;
Database log modeArchive Mode
Automatic archivalEnabled
Archive destination+DATAASM/orcl/archivelog
Oldest online log sequence129
Next log sequence to archive130
Current log sequence130
SQL> select max(sequence#) from v$archived_log
col NAME format a80
SQL> select SEQUENCE#,NAME,FIRST_TIME, NEXT_TIME FROM v$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE#
NAME
FIRST_TIME NEXT_TIME
---------- -----------------------------
129
++DATAASM/orcl/archivelog/2011_08_02/thread_2_seq_11.257.7184
--查看归档丢失的情况:
SELECT THREAD#,LOW_SEQUENCE#,HIGH_SEQUENCE# from v$archive_gap;
--启动闪回
alter system set db_recovery_file_dest_size=200gscope=both;
alter system set db_recovery_file_dest='+DATAASM/orcl/archivelog ' scope=spfile;
噩梦开始啦,着急操作,11G的直接修改成功,我当时没有反映过来,就继续敲这命令。
alter database flashback ON;
--查看闪回是否开启
select log_mode,open_mode,flashback_on from v$database;
--重启数据库校验
Shutdownimmediate
--启动数据库
Startup
ORA-01261: Parameter db_recovery_file_dest destination string cannot betranslated
我晕,参数文件配置错了,后悔没备份参数文件再修改。现在情况没有参数文件备份文件,并且目前参数文件存放在ASM中,无法启动数据库实例修改参数,只能手工修改参数文件。
解决方法: