Home » Server Options » Data Guard » not get archivelog in v$archived_log view
not get archivelog in v$archived_log view [message #323659] Thu, 29 May 2008 03:00 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

i create logical standby database (cold backup).

i get all archive log file in standby arch destination but not that display in V$archived_log view

why?

Re: not get archivelog in v$archived_log view [message #339548 is a reply to message #323659] Thu, 07 August 2008 17:18 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member


You made DR by cold backup Cool do they require archive file ? every thing is consistent.

When we create DR we have to open it like
SQL>STARTUP MOUNT;
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

After this if you issueon primary
SQL>alter system switch logfile;

Then we see information in V$ARCHIVED_LOG
Re: not get archivelog in v$archived_log view [message #339755 is a reply to message #339548] Fri, 08 August 2008 06:35 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Sunil,

Quote:
You made DR by cold backup


Explain me DR?

Babu
Re: not get archivelog in v$archived_log view [message #339763 is a reply to message #339755] Fri, 08 August 2008 07:08 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Babu please check the below link Wink

http://blog.chinaunix.net/u2/66205/showart_668048.html

DR (Disaster Recovery server) termed As Standby server ...
Previous Topic: DGMGRL logon
Next Topic: logs are not in sync (sync problem)
Goto Forum:
  


Current Time: Fri Mar 29 08:22:16 CDT 2024