Home » RDBMS Server » Backup & Recovery » Database up to date (10.2.0.2.0 ,windows)
Database up to date [message #440527] Mon, 25 January 2010 06:56 Go to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member

Hi,

How to check databases(production/preprod/devlopment) are up to date from SQLPLUS tool client ?

Thanks
Re: Database up to date [message #440529 is a reply to message #440527] Mon, 25 January 2010 07:00 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hitman11 wrote on Mon, 25 January 2010 18:26

How to check databases(production/preprod/devlopment) are up to date from SQLPLUS tool client ?


Its not clear Quote:
up to date
of what?

sriram Smile

[Updated on: Mon, 25 January 2010 07:00]

Report message to a moderator

Re: Database up to date [message #440530 is a reply to message #440529] Mon, 25 January 2010 07:01 Go to previous messageGo to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member

I mean how to check databases logs are till date from sqlplus ?

[Updated on: Mon, 25 January 2010 07:02]

Report message to a moderator

Re: Database up to date [message #440531 is a reply to message #440530] Mon, 25 January 2010 07:05 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
which kind of logs you are talking about?
There are so may logs..based on our requirement.
still its not clear......

sriram Smile
Re: Database Till date [message #440532 is a reply to message #440531] Mon, 25 January 2010 07:06 Go to previous messageGo to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member
Archive logs

This i can check from archive log destination.But is there any query by which we can know this ?

or

How to check the latest archive log generated in database using sqlplus ?


Regards,

[Updated on: Mon, 25 January 2010 07:10]

Report message to a moderator

Re: Database Till date [message #440533 is a reply to message #440532] Mon, 25 January 2010 07:11 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
V$ARCHIVED_LOG
Displays historical archived log information from the control file. If you use a recovery catalog, the RC_ARCHIVED_LOG view contains similar information.
V$LOG
Displays all redo log groups for the database and indicates which need to be archived.
V$LOG_HISTORY
Contains log history information such as which logs have been archived and the SCN range for each archived log.


sriram Smile
Previous Topic: Backup Offline
Next Topic: recover a single table from backup
Goto Forum:
  


Current Time: Sun Dec 04 04:49:05 CST 2016

Total time taken to generate the page: 0.03832 seconds