OraFAQ Forum: Server Administration » Manually archiving the log files

Home » RDBMS Server » Server Administration » Manually archiving the log files

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

Manually archiving the log files [message #61949]

Sat, 12 June 2004 08:12

Sanjay
Messages: 236
Registered: July 2000

Senior Member

How Can I manually archive the redo log files.

Report message to a moderator

Re: Manually archiving the log files [message #61959 is a reply to message #61949]

Mon, 14 June 2004 03:56

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Look at this example:

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /app/oracle/arch/orcl/log
Oldest online log sequence     14028
Next log sequence to archive   14033
Current log sequence           14033

SQL> alter system switch logfile;
System altered.

SQL> archive log all;
ORA-00271: there are no logs that need archiving

Best regards.

Frank

Report message to a moderator

Previous Topic:	Database Administration
Next Topic:	Update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:26:17 CDT 2024