转换成快照备库，在转回物理备库

select status from v$instance;

select database_role from v$database;

VKaTeX parse error: Expected 'EOF', got '#' at position 113: …相同的归档日志记录THREAD#̲，SEQUENCE#和FIRS…archived_log group by thread#;

flashback_on闪回功能是否开启
select flashback_on from v$database;

alter database flashback on;

select flashback_on from v$database;

select status,instance_name,database_role,open_mode from v$database,v$Instance;

alter system switch logfile;

select thread#,max(sequence#) from v$archived_log group by thread#;

select flashback_on from v$database;

alter database recover managed standby database cancel;

alter database flashback on;

select flashback_on from v$database;

shutdown immediate;

startup mount

将物理备用数据库转换为快照备用数据库
alter database convert to snapshot standby;

select status,instance_name,database_role,open_mode from v$database,v$Instance;

alter database open;

select status,instance_name,database_role,open_mode from v$database,v$Instance;

connect scott/123;

创建一张表
Create table lihao
(
id number,
name varchar2(100)
);

insert into lihao values(001,‘lihao’);

alter system switch logfile;
select thread#,max(sequence#) from v$archived_log group by thread#;

connect sys as sysdba
select thread#,max(sequence#) from v$archived_log group by thread#;

SELECT al.thrd “Thread”, almax “Last Seq Received”, lhmax “Last Seq Applied” FROM (select thread# thrd, MAX(sequence#) almax FROM vKaTeX parse error: Expected 'EOF', got '#' at position 36: …esetlogs_change#̲=(SELECT resetl…database) GROUP BY thread#) al, (SELECT thread# thrd, MAX(sequence#) lhmax FROM vKaTeX parse error: Expected 'EOF', got '#' at position 35: …esetlogs_change#̲=(SELECT resetl…database) GROUP BY thread#) lh WHERE al.thrd = lh.thrd;


V$RESTOR{E}_{P}OINT显示有关还原点的信息。SCN:创建还原点时的数据库SCNGUARANTE{E}_{F}LASHBAC{K}_{D}ATABASE:表示是否保留闪回日志文件以确保闪回此点（YES）（NO）STORAG{E}_{S}IZE:当前占用的支持此还原点的磁盘空间的大概字节数。对于保证的还原点，该值将仅为非零TIME:创建还原点时的挂钟时间RESTOR{E}_{P}OIN{T}_{T}IME:创建还原点时指定的时间。如果未指定时间，则该值为NULL。PRESERVED：指示是否必须明确删除还原点（YES）或（NO）NAME：还原点名称select\ast fromv$restore_point;

select database_role from v$database;

shutdown immediate;

startup mount

将快照备用数据库转换为物理备用数据库
alter database convert to physical standby;

shutdown immediate;

startup mount

alter database recover managed standby database using current logfile disconnect from session;

select process,status,client_process,sequence#,block#,block# from v$managed_standby;

select * from v$restore_point;

转换回去之后，就不能在操作了