Tag Info

Hot answers tagged

3

This answer is wrong, because the value for rownum is assigned before the order by is executed. Below is the correct one, SELECT start_date, end_date, resort_id, ROWNUM FROM (SELECT start_date, end_date, resort_id FROM employee_activity WHERE employee_id = 27 ...


2

While copying a tablespace, it automatically includes data files and indexes associated with it. You need to make sure that tablespace is self contained. Confirm that tablespace is self contained execute DBMS_TTS.TRANSPORT_SET_CHECK('<TABLESPACENAME>', true); Use the TRANSPORT_SET_VIOLATIONS view to check if any violations condition exists select * ...


1

NOAFFIRM means the redo transport will be acknowledged before writing the received redo to disk (standby redo logs). ASYNC noaffirm means the log transfer method is ARCH right? No, it does not. Without specifying LGWR or ARCH, LGWR is the default. You can check it on the primary database by: select archiver from v$archive_dest where dest_id = 5; ...


1

Just start the database normally and run DBMS_DST.UPGRADE_DATABASE Then you must see the messages "An upgrade window has been successfully ended." and "Failures:0" Double check that it succeeded by running: 1: SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY ...


1

No. The rman command 'BACKUP FULL ...' makes a backup of the datafiles but does not backup any archivelogs. If you want to backup archivlogs you have to make an archivlog backup too. This can be done by adding the 'PLUS ARCHIVLOG' clause to the 'BACKUP FULL' command or by issuing a 'BACKUP ARCHIVELOG' command after the 'BACKUP FULL' command. Online ...



Only top voted, non community-wiki answers of a minimum length are eligible