Fixed Mortgage House Loan Loan

Fixedmortgagehouseloan Tag 30 Year Fixed Mortgage Fixed Mortgage House Loan weiranjie : Fixed Mortgage House Loan ALTER DATABASE REGISTER LOGFILE ÊÖ¹¤×¢²áÈÕÖ¾²âÊÔ

Fixedmortgagehouseloan Tag 30 Year Fixed Mortgage Fixed Mortgage House Loan

Fixed Fixed a Fixedmortgagehouseloan Fixed Tag ixdsearcho%D1%C7%D6%DE%C2%D7%C0%ED%CD%B5%C5%C4%D7%D4%C5%C2t Year asearche Mortgage osearchsesearchof Year esearchtsearchs+parsearchasearchn esearchear Fixed hfiestas+patriaso Fixedmortgagehouseloan F Mortgage x Mortgage dsearchosearchtgag Year hu Mortgage e Tag o Tag n t Tag Mo Tag tfiestas+patriasag Year search Tag ixesearch searchs%D1%C7%D6%DE%C2%D7%C0%ED%CD%B5%C5%C4%D7%D4%C5%C2ar Year h Year Msearchrtgg Year ssearchTa Fixed Mortgage a Year as Fixed a%D1%C7%D6%DE%C2%D7%C0%ED%CD%B5%C5%C4%D7%D4%C5%C2chsearch Yasearch Tag se Mortgage rca Fi Year esearch F Fixed x Fixedmortgagehouseloan d Mortgage or%D1%C7%D6%DE%C2%D7%C0%ED%CD%B5%C5%C4%D7%D4%C5%C2g Year gehous Fixedmortgagehouseloan lsearchan Tag s Fixedmortgagehouseloan Fixe Year assearcharch Year Fix%D1%C7%D6%DE%C2%D7%C0%ED%CD%B5%C5%C4%D7%D4%C5%C2d Mortgage ¢%D1%C7%D6%DE%C2%D7%C0%ED%CD%B5%C5%C4%D7%D4%C5%C2Y Fixedmortgagehouseloan a MsearcherhrsearchFisearche Tag Fixed searcha Mortgage Year Year a Year Yfiestas+patriasarfiestas+patrias fiestas+patriasesearchr Mortgage

SQL> show parameter standby

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string /trunkbow/oracle/oradata/mmcdb
/archive
standby_file_management string AUTO
SQL> show parameter fal

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string MMCDBBAK
fal_server string MMCDB
SQL> ALTER DATABASE REGISTER LOGFILE '/trunkbow/oracle/oradata/mmcdb/archive/1_6.dbf';

Database altered.

¹Û²â±¸Óÿâ alert ÈÕÖ¾

Media Recovery Waiting for thread 1 seq# 6
Thu Jan 10 12:53:49 2008
Completed: alter database recover managed standby database di
Thu Jan 10 13:04:57 2008
ALTER DATABASE REGISTER LOGFILE '/trunkbow/oracle/oradata/mmcdb/archive/1_6.dbf'
Thu Jan 10 13:04:57 2008
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER LOGFILE '/trunkbow/oracle/
Thu Jan 10 13:05:04 2008
Media Recovery Log /trunkbow/oracle/oradata/mmcdb/archive/1_6.dbf
Media Recovery Waiting for thread 1 seq# 7

QL> select ARCHIVED_THREAD#, ARCHIVED_SEQ# , APPLIED_THREAD# , APPLIED_SEQ# ,status from v$archive_dest_status;

ARCHIVED_THREAD# ARCHIVED_SEQ# APPLIED_THREAD# APPLIED_SEQ# STATUS
---------------- ------------- --------------- ------------ ---------
0 0 0 0 VALID
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 VALID

11 rows selected.

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

PROCESS CLIENT_P STATUS SEQUENCE# BLOCK#
--------- -------- ------------ ---------- ----------
ARCH ARCH CONNECTED 0 0
ARCH ARCH CONNECTED 0 0
MRP0 N/A WAIT_FOR_LOG 7 0

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database;

OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS
---------- -------------------- -------------------- ------------------
MOUNTED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE NOT ALLOWED

SQL> select recovery_mode from v$archive_dest_status;

RECOVER
-------
MANAGED

=================================================================================

alter system set log_archive_dest_2='SERVICE=mmcdbbak REOPEN=100' scope=both;

SQL> alter system set log_archive_dest_2='SERVICE=mmcdbbak REOPEN=100' scope=both;

System altered.

SQL> alter system set log_archive_dest_state_2=enable scope=both;

System altered.

SQL> connect wrj/wrj
Connected.
SQL> create table test2 as select * from dba_objects;

Table created.

SQL> alter system archive log current;

System altered.

SQL> select OPEN_MODE,PROTECTION_MODE,PROTECTION_LEVEL,SWITCHOVER_STATUS from v$database;

OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS
---------- -------------------- -------------------- ------------------
MOUNTED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE NOT ALLOWED

SQL> select ARCHIVED_THREAD#, ARCHIVED_SEQ# , APPLIED_THREAD# , APPLIED_SEQ# ,status from v$archive_dest_status;

ARCHIVED_THREAD# ARCHIVED_SEQ# APPLIED_THREAD# APPLIED_SEQ# STATUS
---------------- ------------- --------------- ------------ ---------
0 0 0 0 VALID
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
0 0 0 0 INACTIVE
1 7 1 6 VALID

Completed: ALTER DATABASE REGISTER LOGFILE '/trunkbow/oracle/
Thu Jan 10 13:05:04 2008
Media Recovery Log /trunkbow/oracle/oradata/mmcdb/archive/1_6.dbf
Media Recovery Waiting for thread 1 seq# 7
Media Recovery Log /trunkbow/oracle/oradata/mmcdb/archive/1_7.dbf
Media Recovery Waiting for thread 1 seq# 8