Home » RDBMS Server » Backup & Recovery » Can't see my archived file. (Win2k3, 10.2.0.1)
Can't see my archived file. [message #379945] Thu, 08 January 2009 10:09 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

I am facing a weird situation. I have a database sets in archivelog mode, and archiving is automatic. The archive destination is set to the recovery flash area through the use of USE_DB_RECOVERY_FILE.
SQL> archive log list;
mode Database log              mode Archive
Archivage automatique             Activ┌
Destination de l'archive             USE_DB_RECOVERY_FILE_DEST
S┌quence de journal en ligne la plus ancienne     1099
S┌quence de journal suivante Ë archiver      1099
S┌quence de journal courante            1103


I issued the following code
SQL> alter system archive log start 
Then
alter system switch logfile
at least 3 times. A folder named after today's date has been created, but it is empty. It shows nothing inside it.

Is it normal? If no, how can I see them?
Re: Can't see my archived file. [message #379947 is a reply to message #379945] Thu, 08 January 2009 10:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmconfg.htm#1006339
Re: Can't see my archived file. [message #380088 is a reply to message #379947] Fri, 09 January 2009 01:42 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Thanks for the link. Checking it now.
Re: Can't see my archived file. [message #380730 is a reply to message #379945] Tue, 13 January 2009 03:01 Go to previous messageGo to next message
mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad
Junior Member
did you observed any change in system date?
Re: Can't see my archived file. [message #380758 is a reply to message #380730] Tue, 13 January 2009 04:12 Go to previous message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
What kinda change are you talking about? Be explicit please.
Previous Topic: complete recovery through rman
Next Topic: RMAN CONFIGURATION
Goto Forum:
  


Current Time: Sat Dec 03 12:15:22 CST 2016

Total time taken to generate the page: 0.15272 seconds