I have taken the hotbackup of the 2 tablespaces I have.I intend to do this once in a week and during the remaining days want to take the arch file backup.
I have enabled archiver log (in the init.ora) . However there are no arch files created in the %orahome%db%arch directory.
Does it mean that the arch files are not getting created ?
Please advice me how to take the arch file backup, alternatively.
First, you have to make sure your database is in archivelog mode:
select log_mode from v$database;
If the value is "ARCHIVE", then you are in archive log mode. If not, you have to shutdown your database and bring it up in exclusive mode. Then, issue
alter database archivelog
Shutdown, and restart your database.
Next, force a log switch.
alter system switch logfile
Then, look in v$archived_log to see if you have archived anything.
select name, to_char(completion_time, 'mm/dd/yyyy hh24:mi:ss') comptime
order by completion_time
This will give you the name of the file that was archived. Go to your OS and see if that file is there.