OraFAQ Forum: Backup & Recovery » Database up to date

Home » RDBMS Server » Backup & Recovery » Database up to date (10.2.0.2.0 ,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database up to date [message #440527]

Mon, 25 January 2010 06:56

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

Report message to a moderator

Re: Database up to date [message #440529 is a reply to message #440527]

Mon, 25 January 2010 07:00

ramoradba
Messages: 2456
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

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

ramoradba
Messages: 2456
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

Report message to a moderator

Re: Database Till date [message #440532 is a reply to message #440531]

Mon, 25 January 2010 07:06

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

ramoradba
Messages: 2456
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

Report message to a moderator

Previous Topic:	Backup Offline
Next Topic:	recover a single table from backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 05:25:54 CDT 2024