You can see where your database’s archived redo goes as follows:
SQL> l
1 select value from v$parameter
2* where name = 'log_archive_dest'
SQL> /
VALUE
------------------------------
/old_dir/arch
SQL>
And you can see them on disk too:
SOLARIS > /old_dir > ls -1 *arc
arch8190_TEST11_1_705064488.arc
arch8191_TEST11_1_705064488.arc
arch8192_TEST11_1_705064488.arc
arch8193_TEST11_1_705064488.arc
arch8194_TEST11_1_705064488.arc
SOLARIS > /old_dir >
You can send archived redo to a new location like this:
SQL> alter system set log_archive_dest =
2 '/new_dir/arch'
3 scope = both;
System altered.
SQL>
When you have done this you should always test that the archiving is working:
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL>
And check in the operating system that the files are arriving:
SOLARIS > /new_dir > ls -1 *arc
arch8195_TEST11_1_705064488.arc
arch8196_TEST11_1_705064488.arc
arch8197_TEST11_1_705064488.arc
SOLARIS > /new_dir >
No comments:
Post a Comment